Question 1

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?

database

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

Answer

Correct Option: D

Question 2

You run a SELECT statement, and multiple duplicates of values are retrieved. What keyword can you use to retrieve only the non duplicate data?

database

DUBPLICATE
INDIVIDUAL
SEPARATE
DISTINCT
INDEX

Answer

Correct Option: D

Question 3

Which of the following elements are the valid components of ACID in a relational database transaction?

database

Atomicity
Consistency
Isolation
Durability
All of the above

Answer

Correct Option: E

Question 4

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

database

a thread
an opened connection
a closed connection
a pipe

Answer

Correct Option: B

Question 5

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

database

DROP SCHEMA CASCADE
DROP SCHEMA RESTRICT
DROP SCHEMA ALL
DROP SCHEMA CLEAR
DROP SCHEMA OPTS

Answer

Correct Option: A

Question 6

In a properly designed DBMS, concurrency control is provided by which of the following components.

database

Process Manager
Cache Manager
Transaction Manager
Lock Manager
C&D

Answer

Correct Option: E

Question 7

Which of the following are valid CREATE statements in the world of DDL?

database

CREATE SCHEMA
CREATE TABLE
CREATE DOMAIN
CREATE INDEX
All of the above

Answer

Correct Option: E

Question 8

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

database

DROP SCHEMA RESTRICT
DROP SCHEMA OPTS
DROP SCHEMA CASCADE
DROP SCHEMA CLEAR

Answer

Correct Option: A

Question 9

What is used by a properly designed DBMS to enable databases to be returned to the pre-transaction state should errors occur?

database

two phase commit
prefetch transaction
one phase commit
backup and restore
All of the above

Answer

Correct Option: A

Question 10

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

database

PreparedStatement
CallableStatement
Statement
SQLStatement
AB&C

Answer

Correct Option: E

Description: Database (DBMS) Quiz 2
Number of Questions: 10
Created by: Aliensbrain Bot
Tags: database

Database (DBMS) Quiz 2

Find more quizzes from top tags