0

databases Online Quiz - 120

Description: databases Online Quiz - 120
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Using a view to access the table

  2. Using a referential constraint on the table

  3. Revoking access from the phone_number column

  4. Defining a table check constraint on the table


Correct Option: A
  1. forces cursor to close after commit

  2. Keeps cursor open after commit

  3. Does not allow cursor to close till all rows are fetched

  4. Locks the cursor

  5. None of the above


Correct Option: B

The tables can be combined together in SQL using the concept of

  1. Normalization

  2. Indexing

  3. Sequence

  4. Join


Correct Option: D

If the value is null in order to place a value in it the function used is

  1. Substitute( )

  2. Place value ( )

  3. NVL ( )

  4. Place( )


Correct Option: C

Which of the following joins is possible in SQL

  1. EQUI-JOIN

  2. NON EQUI-JOIN

  3. Both A. and B.

  4. None of the Above


Correct Option: C

A table T1 having 100 rows is joined with a table T2 with 50 rows without specifying the joined column in the where clause then result will have

  1. 100 rows

  2. 50 rows

  3. 150 rows

  4. 5000 rows


Correct Option: D
  1. ALTER TABLE command is used to create a table

  2. ALTER TABLE command is used to change the column elements in a table

  3. ALTER TABLE command is used to delete a table

  4. Both A. and C.


Correct Option: D

Which one of the following does not help to maintain referential integrity?

  1. Unique constraints

  2. Primary keys

  3. Cascading actions

  4. Foreign keys


Correct Option: A

What are the memory structures used to handle multiple row selections at a time

  1. Cursors

  2. Host Variables

  3. Indicator Variable

  4. SQLCA


Correct Option: A
  1. Control file

  2. Redo Logfile and datafile

  3. Database

  4. Current SCN Number

  5. All of the above


Correct Option: E
  1. It is the point at which ORACLE starts writing to one online redo log file and begins writing to another at same time

  2. It is the point at which ORACLE ends writing to one online redo log file and begins writing to another

  3. It is the point at which ORACLE starts writing to one online redo log file and ends writing to another

  4. It is the point at which ORACLE ends writing to one online redo log file and starts writing to another


Correct Option: B
  1. Database Buffer Cache

  2. Redo Log Buffer

  3. Shared Pool

  4. PGA


Correct Option: C

Which statement represents a default characteristic of the database if a database is created using the database creation assistant?

  1. To access the HR user account, the account should be unlocked first

  2. All accounts created by the Database Creation Assistant are locked

  3. The SYS and SYSTEM accounts use the same default password as in previous Oracle versions

  4. All accounts created by the Database Creation Assistant initially have expired passwords


Correct Option: A

What is a cluster Key

  1. The related columns of the tables are called the cluster key. The cluster key is indexed using a cluster index and its value is stored only once for multiple tables in the cluster.

  2. The related columns of the tables are called the cluster key. The cluster key is indexed using a b+ tree index and its value is stored only once for multiple tables in the cluster.

  3. The related columns of the tables are called the cluster key. The cluster key is indexed using a bitmap index and its value is stored only once for multiple tables in the cluster.

  4. The related columns of the tables are called the cluster key. The cluster key is indexed using a range index and its value is stored only once for multiple tables in the cluster.


Correct Option: A

What is Privilidge auditing

  1. It is the auditing of the use of normal system privileges with regard to specifically named objects

  2. It is the auditing of the use of powerful system privileges without regard to specifically named objects

  3. It is the auditing of the use of powerful system privileges with regard to specifically named objects

  4. None of these


Correct Option: B

What is a Two-Phase Commit

  1. Two-phase commit is mechanism that guarantees a distributed transaction that always commits on all involved nodes to maintain data consistency across the global distributed database.

  2. Two-phase commit is mechanism that guarantees a distributed transaction either commits on all involved nodes or rolls back on all involved nodes to maintain data consistency across the global distributed database. It has two phase, a Prepare Phase and a C

  3. Two-phase commit is mechanism that guarantees a distributed transaction that always rollback on all involved nodes to maintain data consistency across the global distributed database.

  4. Two-phase commit is mechanism that guarantees a distributed transaction that always commit on all involved nodes to maintain data consistency across the global heirarchical database.


Correct Option: B
- Hide questions