Test: Structured Query Language - 2 - CUET Humanities MCQ

All A, B and C are correct. Option 4 is the correct answer.

Default value of char variable is 'u0000'.

Q is a correct statement because the primary key and the foreign key can exist in the same relation. Moreover foreign key can refer to the primary key in the same relation. So this answer is correct.

Full form of DDL is Data Definition Language.

To add a new column to an existing table, use the ALTER TABLE ADD COLUMN statement as follows:
ALTER TABLE table_name
ADD column_name datatype;

The SELECT command is used to select data from a database and query the data from the database.

Error reporting, Character, Datatype conversion, Number, Date, Object, Reference, all of these are used in functions.

'Harish' would be the default output as the pattern specified with the function is not available on the left-side of the input. So, option 1 is correct.

JOIN in DBMS is used to retrieve combination of tuples in two relations based on a common field in both the relations.

SELECTION is an operation that selects only some of the tuples in the relation.