0

databases Online Quiz - 30

Description: databases Online Quiz - 30
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following Sql statements is correct?

  1. TRUNCATE * from TABLE Sales

  2. TRUNCATE TABLE Sales

  3. TRUNCATE Sales TABLE

  4. TRUNCATE * FROM Sales


Correct Option: B

What is true about Sequences?

  1. Once created a sequence belongs to a specific schema.

  2. Once created, a sequence is linked to a specified table.

  3. Once created a sequence is automatically available to all users.

  4. Only the DBA can control which sequence is used by a certain table.

  5. Once created a sequence is automatically used in all INSERT and UPDATE statements.


Correct Option: A,C
  1. If the datafile resides on only one disk, there is no advantage of using parallel backups

  2. The size of all the sections of a datafile involved in “Parallel backup” are always same

  3. The size of all the sections of a datafile involved in “Parallel backup” are always same except the size of the last section

  4. All the sections of one datafile are backed up by the same channel

  5. All the sections of one datafile are backed up by different channels


Correct Option: A,C,E
  1. COMMITTED UNDO data is NEVER backed up

  2. COMMITTED UNDO data is backed up depending on the status of the transaction

  3. COMMITTED UNDO data is backed up always

  4. UNCOMMITTED UNDO data is never backed up

  5. UNCOMMITTED UNDO data is backed up depending on the status of the transaction

  6. UNCOMMITTED UNDO data is backed up always


Correct Option: A,F

What is the benefit of “Virtual Private Catalog” feature in Oracle 11g?

  1. Create one catalog database per Database Administrator to share the maintenance workload

  2. Restrict SYSDBA and SYSOPER access from Database Administrators and yet allow them to perform database backup and recovery related tasks i.e. Virtualization of the SYSDBA and SYSOPER access

  3. Maintain only one database for the RMAN repository catalog yet establish secure boundaries for individual database owners to manage their own virtual repositories

  4. Make Oracle 11g database compliant with global Backup and Recovery standards


Correct Option: C

What is true about “IMPORT CATALOG” command? Choose all that apply

  1. It is used to consolidate multiple catalog database repositories into a single catalog database

  2. Once the import is successful, it unregisters the database from the destination catalog database i.e. the database where the metadata is imported

  3. Once the import is successful, it unregisters the database from the source catalog database i.e. the database which holds the original metadata

  4. If NO UNREGISTER clause is used, it will not unregister the database from the destination catalog database i.e. the database where the metadata is imported

  5. If NO UNREGISTER clause is used, it will not unregister the database from the source catalog database i.e. the database which holds the original metadata


Correct Option: A,C,E
  1. Duplicating the database from its backup has been available since Oracle8i Database

  2. Duplicating the database from its backup has been available since Oracle9i Database

  3. Duplicating the database from its backup has been available since Oracle10g Database

  4. Duplicating the database from its backup has been available since Oracle11g Database


Correct Option: B

Which CLAUSE is used in the DUPLICATE DATABASE command to let RMAN know that you aren’t using prior backups of the target database as source but are instead using the network for the database duplication?

  1. from target database

  2. from live database

  3. from source database

  4. from active database


Correct Option: D

PRODUCT ======= Product ID Product Description Manufacturer ID MANUFACTURER ============ Manufacturer ID Manufacturer Name Referring to the above table, what type of relationship exists between the Product table and the Manufacturer table?

  1. Product - Many Manufacturer - Many

  2. Product - One or Many Manufacturer - One or Many

  3. Product - Many Manufacturer - One

  4. Product - One Manufacturer - One

  5. Product - One Manufacturer - Many


Correct Option: B
  1. The right table will return ALL rows

  2. The right table will return NULL

  3. Both tables will return NULL

  4. The left table will return ALL rows

  5. The left table will return NULL.


Correct Option: D

Which phase of the data modeling process contains security review?

  1. Structure

  2. Design Issue

  3. Data Source

  4. Storage Issue

  5. Operational Process


Correct Option: B

Which statements below are correct for TRUNCATE command

  1. Command is used to delete all the rows of the table.

  2. Command is used to delete complete table structure.

  3. Command free the space used by the table.

  4. Command deletes all the constraints,relations and previleges with other tables


Correct Option: A,C
  1. Primary key constraint creates clustered index by default.

  2. Unique key constraint creates clustered index by default.

  3. Primary key constraint allows null values.

  4. Unique key constraint allows null values


Correct Option: A,D
  1. Data about Data

  2. Describes a data dictionary

  3. Self-describing

  4. Includes user data


Correct Option: D
  1. 10.2.0.1

  2. 10.2.0.3

  3. 10.2.0.2

  4. 10.2.0.4


Correct Option: D
- Hide questions