Back
0

Database (DBMS) Quiz 2

Description: Database (DBMS) Quiz 2
Number of Questions: 10
Created by:
Tags: database
Start the Quiz
Attempted 0/10 Correct 0 Score 0
‹
›

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

  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

Show answer
Correct Option: D

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

  1. DUBPLICATE

  2. INDIVIDUAL

  3. SEPARATE

  4. DISTINCT

  5. INDEX

Show answer
Correct Option: D

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

database

  1. Atomicity

  2. Consistency

  3. Isolation

  4. Durability

  5. All of the above

Show answer
Correct Option: E

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

  1. a thread

  2. an opened connection

  3. a closed connection

  4. a pipe

Show answer
Correct Option: B

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

database

  1. DROP SCHEMA CASCADE

  2. DROP SCHEMA RESTRICT

  3. DROP SCHEMA ALL

  4. DROP SCHEMA CLEAR

  5. DROP SCHEMA OPTS

Show answer
Correct Option: A

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

  1. Process Manager

  2. Cache Manager

  3. Transaction Manager

  4. Lock Manager

  5. C&D

Show answer
Correct Option: E

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

  1. CREATE SCHEMA

  2. CREATE TABLE

  3. CREATE DOMAIN

  4. CREATE INDEX

  5. All of the above

Show answer
Correct Option: E

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

database

  1. DROP SCHEMA RESTRICT

  2. DROP SCHEMA OPTS

  3. DROP SCHEMA CASCADE

  4. DROP SCHEMA CLEAR

Show answer
Correct Option: A

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

  1. two phase commit

  2. prefetch transaction

  3. one phase commit

  4. backup and restore

  5. All of the above

Show answer
Correct Option: A

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

  1. PreparedStatement

  2. CallableStatement

  3. Statement

  4. SQLStatement

  5. AB&C

Show answer
Correct Option: E
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions