Tag: databases

Questions Related to databases

Which of the following is FALSE about a ALTER TABLE command of SQL?
technology databases

  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.

Show answer
Correct Option: D

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

  1. Unique constraints

  2. Primary keys

  3. Cascading actions

  4. Foreign keys

Show answer
Correct Option: A

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

technology databases

  1. Cursors

  2. Host Variables

  3. Indicator Variable

  4. SQLCA

Show answer
Correct Option: A

A control file contain information about
technology databases

  1. Control file

  2. Redo Logfile and datafile

  3. Database

  4. Current SCN Number

  5. All of the above

Show answer
Correct Option: E

Log switch is
technology databases

  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

Show answer
Correct Option: B

Which memory area is used to cache the data dictionary information?
technology databases

  1. Database Buffer Cache

  2. Redo Log Buffer

  3. Shared Pool

  4. PGA

Show answer
Correct Option: C

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

technology databases

  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

Show answer
Correct Option: A

What is a cluster Key

technology databases

  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.

Show answer
Correct Option: A

What is Privilidge auditing
technology databases

  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

Show answer
Correct Option: B

What is a Two-Phase Commit
technology databases

  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.

Show answer
Correct Option: B