SQL_QUIZ

which of the following are some common RDBMS in use?

• oracle

• MySql

• heidiSql

• all of the above

which of the following are the types of Unicode character string types in SQL?

• nchar

• ntext

• both of them

• none of them

what does BLOB in SQL stand for?

• binary large objects

• big large objects

• binary language for objects

• none

which of the following datatype is most appropiate for storing a string of upto 255 characters?

• text

• tiny text

• blob

• binary

what happens when no value is inserted in an ENUM list?

• nothing happens

• the code will crash

• a blank value is inserted in that case

• none of the these

what is the range of integers that can be held in the MEDIUMINT datatype of SQL?

• signed numbers in the range of -8388608 to 8388607

• unsigned numbers in the range of 0 to 16777215

• both A and B

• NONE

WHAT DOES THE FOLLOWING CODE SNIPPET DO?

ALTER TABLE STUDENT ADD(ADDRESS VARCHAR(255));

• adds a column called address

• checks if column address is present

• invalid syntax

• none of these

which of the following commands is used to delete all rows and free up space from the table?

• truncate

• drop

• delete

• alter

which of the following commands are part of DCL?

• GRANT

• REVOKE

• both A and B

• NONE OF THESE

WHAT DOES THE FOLLOWING CODE SNIPPET DO?

DELETE FROM STUDENTS

WHERE AGE=16;

ROLLBACK;

• perform an undo operation on the delete operation

• deletes the rows from the table where age=16

• delete entire table

• none