Tag: database

Quizzes (4) Questions (19)

Questions Related to database

Multiple choice database

You are managing the in-house database systems.You need to ensure that the user AMY can execute all operations against the SALES relation. What SQL statement sequence will you use?

GRANT ALL PRIVILEGES WHERE FROM ON TO
GRANT ALL PRIVILEGES TO WHERE FROM
GRANT ALL PRIVILEGES WHERE FROM TO
GRANT ALL PRIVILEGES ON TO
GRANT ALL PRIVILEGES ON WHERE FROM

Reveal answer Fill a bubble to check yourself

Multiple choice database

You are managing the in-house database systems. You are creating a series of secondary indexes in your relational database. By doing so, which of the following issues must be carefully considered .

confusion in selection of optimal query execution method
disk space consumption
performance overhead
security
Either AB&C

Reveal answer Fill a bubble to check yourself

Multiple choice database

Which of the following are the factors to consider when you want to select a DBMS based on the criteria of physical capabilities, as recommended by CIW ?

hardware requirements
data compression support
encryption support
All of the above

Reveal answer Fill a bubble to check yourself

Multiple choice database

Which of the following types of JDBC drivers allows your Java programs to communicate with the ODBC driver of your DBMS?

Pure Java
JDBC-ODBC Bridge
Native-API
JDBC-net

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Class.callName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Class.callfunc("JdbcOdbcDriver");
Class.Name.init("sun.jdbc.odbc.JdbcOdbcDriver");

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

Reveal answer Fill a bubble to check yourself

Multiple choice database

You reject someone's proposal to use File-based databases. Which of the following are the disadvantages of such databases?

repetition of data
separation of data
incompatibility of files
data dependence
All of the above

Reveal answer Fill a bubble to check yourself

Multiple choice database

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

A CachedRowSet class
A JavaSource class
A WebRowSet class
A JDBCRowSet class
Either AC&D

Reveal answer Fill a bubble to check yourself

Multiple choice database

Which of the following correctly describe the locking mechanism in a RDBMS?

A read lock prevents other transactions from reading the locked data
A write lock prevents other transactions from reading or writing to the locked data
Multiple transactions can have write locks on the same data item.
Multiple transactions can have read locks on the same data item.
Either B&D

Reveal answer Fill a bubble to check yourself

Multiple choice database

In the world of SQL relational database, the data type for varchar, in general, is:

Fixed length string of n characters
Variable length string up to n characters
Floating point number of p bits precision
16-bit signed integer
32-bit signed integer

Reveal answer Fill a bubble to check yourself

← Previous
1
2
Next →