Database (DBMS) Quiz 2

Description: Database (DBMS) Quiz 2
Number of Questions: 10
Created by:
Tags: database
Attempted 0/10 Correct 0 Score 0
  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


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?

  1. DUBPLICATE

  2. INDIVIDUAL

  3. SEPARATE

  4. DISTINCT

  5. INDEX


Correct Option: D

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

  1. Atomicity

  2. Consistency

  3. Isolation

  4. Durability

  5. All of the above


Correct Option: E
  1. a thread

  2. an opened connection

  3. a closed connection

  4. a pipe


Correct Option: B

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

  1. DROP SCHEMA CASCADE

  2. DROP SCHEMA RESTRICT

  3. DROP SCHEMA ALL

  4. DROP SCHEMA CLEAR

  5. DROP SCHEMA OPTS


Correct Option: A
  1. Process Manager

  2. Cache Manager

  3. Transaction Manager

  4. Lock Manager

  5. C&D


Correct Option: E
  1. CREATE SCHEMA

  2. CREATE TABLE

  3. CREATE DOMAIN

  4. CREATE INDEX

  5. All of the above


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?

  1. DROP SCHEMA RESTRICT

  2. DROP SCHEMA OPTS

  3. DROP SCHEMA CASCADE

  4. DROP SCHEMA CLEAR


Correct Option: A
  1. two phase commit

  2. prefetch transaction

  3. one phase commit

  4. backup and restore

  5. All of the above


Correct Option: A
  1. PreparedStatement

  2. CallableStatement

  3. Statement

  4. SQLStatement

  5. AB&C


Correct Option: E
- Hide questions