Tag: databases

Questions Related to databases

For which two constraints,does the oracle server implicitly creates an index ?
technology databases

  1. NOT NULL

  2. PRIMARY KEY

  3. FOREIGN KEY

  4. CHECK

  5. UNIQUE

Show answer
Correct Option: B,E

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

technology databases

  1. 8

  2. 2

  3. 3

  4. 4

  5. 5

  6. There is no such criteria

Show answer
Correct Option: C

Which of the following Sql statements is correct?

technology databases

  1. TRUNCATE * from TABLE Sales

  2. TRUNCATE TABLE Sales

  3. TRUNCATE Sales TABLE

  4. TRUNCATE * FROM Sales

Show answer
Correct Option: B

What is true about Sequences?

technology databases

  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.

Show answer
Correct Option: A,C

What is true about “Parallel Backups” in Oracle 11g? Choose all that apply

technology databases

  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

Show answer
Correct Option: A,C,E

What is true about “UNDO DATA” in the context of database backups in Oracle 11g using RMAN?

technology databases

  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

Show answer
Correct Option: A,F

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

technology databases

  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

Show answer
Correct Option: C

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

technology databases

  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

Show answer
Correct Option: A,C,E

What is true about “Database Duplication” in Oracle using RMAN?

technology databases

  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

Show answer
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?

technology databases

  1. from target database

  2. from live database

  3. from source database

  4. from active database

Show answer
Correct Option: D