Database (DBMS) Quiz

Description: Database (DBMS) Quiz
Number of Questions: 10
Created by:
Tags: database
Attempted 0/10 Correct 0 Score 0
  1. GRANT ALL PRIVILEGES WHERE FROM ON TO

  2. GRANT ALL PRIVILEGES TO WHERE FROM

  3. GRANT ALL PRIVILEGES WHERE FROM TO

  4. GRANT ALL PRIVILEGES ON TO

  5. GRANT ALL PRIVILEGES ON WHERE FROM


Correct Option: D

In your program you want to use the JDBC-ODBC Bridge driver. What code do you use?

  1. Class.callName("sun.jdbc.odbc.JdbcOdbcDriver");

  2. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

  3. Class.callfunc("JdbcOdbcDriver");

  4. Class.Name.init("sun.jdbc.odbc.JdbcOdbcDriver");


Correct Option: B
  1. User issues request -> DBMS retrieves relevant mappings and executes the request DBMS intercepts the request DBMS presents the request to the user.

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

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

  4. None of the above


Correct Option: B
  1. repetition of data

  2. separation of data

  3. incompatibility of files

  4. data dependence

  5. All of the above


Correct Option: E

Which of the following are valid rowset classes that you can use in your Java application ?

  1. A CachedRowSet class

  2. A JavaSource class

  3. A WebRowSet class

  4. A JDBCRowSet class

  5. Either AC&D


Correct Option: E
  1. A read lock prevents other transactions from reading the locked data

  2. A write lock prevents other transactions from reading or writing to the locked data

  3. Multiple transactions can have write locks on the same data item.

  4. Multiple transactions can have read locks on the same data item.

  5. Either B&D


Correct Option: E
  1. Fixed length string of n characters

  2. Variable length string up to n characters

  3. Floating point number of p bits precision

  4. 16-bit signed integer

  5. 32-bit signed integer


Correct Option: B
- Hide questions