DBMS Security and Authorization
Description: DBMS Security and Authorization | |
Number of Questions: 15 | |
Created by: Arav Srivastava | |
Tags: DBMS Security and Authorization Java/Oracle /C/C++ Oracle Database Database Management System |
Which type of command is GRANT?
In Oracle, which of the following is a group of privileges that are collected together and granted to users?
Create, Revoke, Grant and Drop commands are parts of _____________ language in Oracle.
Which of the following locks in Oracle locks the table allowing other users to only query but not insert, update or delete rows in a table?
Which of the following objectives of Data Distribution is achieved by having redundant fragment allocation meeting the site requirements?
A director's salary details are hidden from the employee. This process is called
In a multi-user database, if two users wish to update the same record at the same time, they are prevented by
What is the SQL statement to grant select, update privileges to the user RAKESH for the DEPT relation?
Data security threat includes
Which are the different phases in two-phase locking protocol?
A locked file can be
Locking can be used for
In an Oracle distributed database system, which of the following is the one in which each server participating in a distributed database is administered independently from all other databases?
_______ lock does not permit to share the resource.
What type of statement is executed automatically as an event after or before modification to the database?