Welcome to DataBase Quiz, Randomly Selected !!

Question 1. How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Question 2. Given the following relation instance.
x  y  z
1  4  2
1  5  3
1  6  3
3  2  2 
Which of the following functional dependencies are satisfied by the instance?

XY -> Z and Z -> Y

YZ -> X and Y -> Z

YZ -> X and X -> Z

XZ -> Y and Y -> X

Question 3. Which of the following correctly describe the sequence of the DBMS operational process?

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS intercepts the request DBMS presents the request to the user.

User issues request -> DBMS intercepts the request DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user.

User issues request -> DBMS retrieves relevant mappings and executes the request DBMS presents the request to the user DBMS intercepts the request.

None of the above

Question 4. Which SQL statement is used to delete data from a database?

TRUNCATE

DELETE

DROP

REMOVE

Question 5. What statement do you use to remove a schema and its related objects from your relational database?

DROP SCHEMA RESTRICT

DROP SCHEMA ALL

DROP SCHEMA CASCADE

DROP SCHEMA OPTS

Question 6. Which SQL statement is used to extract data from a database?

GET

OPEN

EXTRACT

SELECT

Question 7. What statement do you use to remove a schema and ensure that the removal takes place only if the schema is empty?

DROP SCHEMA RESTRICT

DROP SCHEMA OPTS

DROP SCHEMA CASCADE

DROP SCHEMA CLEAR

Question 8. Under JDBC, which of the following types of instances can be created by the Connection object?

PreparedStatement

CallableStatement

Statement

All of the above

Question 9. Which of the following is true of a network structure?

It is a physical representation of the data

It allows a many-to-many relationship

It is conceptually simple

It will be dominant data base of the future

Question 10. In JDBC, what represents a single instance of a particular database session?

a thread

an opened connection

a closed connection

a pipe