Which is the default value of any column, when it is unassigned or unknown? a. Char b. Zero C. Space O d. Null Previous page Next page Ms. Aseela, a student of UTAS-IBRI used the following SQL statement in her assignment. Analyse the statement and identify which type of join is she implementing. Select *from teacher t join teacher h ON (t.id = h.id); O a. Inner Join O b. Self Join O C. Cross Join O d. Full Outer Join AnyDe Evaluate the given below SQL query and answer the following: CREATE TABLE Student (College_id VARCHAR2(9), National_id NUMBER(9)); You are a member of the SYSDBA role, but you are logged in under your own schema. You issue this CREATE TABLE statement. Choose the valid statement from the following PDI azhar O a. You created the student table in the SYS schema O b. You created the student table in the public schema Adob Creati O c. You created the student table in your schema de you created the table in the SYSDBA schema PDE TDB20 Ent-Pro Previous case Choose the correct statement, which helps us in implementing natural join. we PDI O a. Columns with the same name and datatype O b. Columns with the same name and with different datatype. O c. Columns with the different name and datatype O d. Columns with the same name char: dah UTAS-IBRA database contains many tables in it. There are two tables, which contains two columns with same name and datatype. In-order to perform the join operation between these two tables, what type of join will you implement O a. Full Outer Join O b. Outer Join O c. Natural Join O d. Cross Join