WorksheetsDBMS Quiz2
Total questions: 10
Worksheet time: 5mins
What does BLOB in SQL stand for?
Binary Large Object
Big Large Object
Binary Language for Objects
None of the above
What does the following code snippet do?
ALTER TABLE STUDENT ADD(ADDRESS VARCHAR2(20));
Adds a Column called Address
Checks if a column called ADDRESS is present in the table Student
Invalid Syntax
None of the above
What does the following code snippet do?
DELETE FROM STUDENTS WHERE AGE = 16;
ROLLBACK;
Performs an undo Operation on the Delete Operation
Deletes the rows from the table where age=16
Deletes the entire table
None of the above
Which SQL constraint do we use to set some value to a field whose value has not been added explicitly?
Unique
Not Null
Default
Check
Primary key can be?
Null
Not Null
Both Null & Not Null
Depends on Situation
Which of the following commands is used to delete a trigger in SQL?
Drop
Delete
Alter
None of the above
Which of the following is the right syntax for assertion?
Create assertion 'assertion-name' check 'predicate';
Create assertion check 'predicate' 'assertion-name';
Create assertions 'predicates';
All of the mentioned
Views can be created for?
One table
Many table
another view
All of the above
What are the major components of the JDBC?
DriverManager, Driver, Connection, Statement, and ResultSet
DriverManager, Driver, Connection, and Statement
DriverManager, Statement, and ResultSet
DriverManager, Connection, Statement, and ResultSet
Select the packages in which JDBC classes are defined?
jdbc and javax.jdbc
rdb and javax.rdb
jdbc and java.jdbc.sql
sql and javax.sql
