Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the clause to the appropriate grant command.
a. with grant
b. grant user
c. grant pass privelege
d. with grant option
Q. Which of the following is used to avoid cascading of authorizations from the user?
a. granted by current role
b. revoke select on department from amit, satoshi restrict;
c. revoke grant option for select on department from amit;
d. revoke select on department from amit, satoshi cascade;
Q. The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation
a. the privilege must be granted only by roles
b. the privilege is granted by roles and users
c. the user role cannot be removed once given
d. by restricting the user access to the roles
Q. Which of the following is used to access the database server at the time of executing the program and get the data from the server accordingly?
a. embedded sql
b. dynamic sql
c. sql declarations
d. sql data analysis
Q. Which of the following header must be included in java program to establish database connectivity using JDBC ?
a. import javsql.*;
b. import java.sql.odbc.jdbc.*;
c. import java.jdb*;
d. import java.sql.jdbc.*;
Q. Which of the following invokes functions in sql?
a. prepared statements
b. connection statement
c. callable statements
d. all of the mentioned
Q. Which of the following is used as the embedded SQL in COBOL?
a. exec sql <embedded sql statement >;
b. exec sql <embedded sql statement > end-exec
c. exec sql <embedded sql statement >
d. exec sql <embedded sql statement > end exec;
Q. Which of the following is used to access large objects from a database ?
a. setblob()
b. getblob()
c. getclob()
d. all of the mentioned
Q. A is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
a. procedures
b. triggers
c. functions
d. none of the mentioned
Q. What are the after triggers?
a. triggers generated after a particular operation
b. these triggers run after an insert, update or delete on a table
c. these triggers run after an insert, views, update or delete on a table
d. all of the mentioned
Q. Which of the following is NOT an Oracle- supported trigger?
a. before
b. during
c. after
d. instead of