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

AI Explanation

To answer this question, we need to understand the concept of referential integrity.

Referential integrity is a database constraint that ensures the relationships between tables are maintained correctly. It ensures that foreign key values in a table match primary key values in another table, or are null.

Let's go through each option to understand why it does or does not help to maintain referential integrity:

Option A) Unique constraints - This option is incorrect because unique constraints help to maintain referential integrity. They ensure that no two rows in a table have the same values in the specified columns.

Option B) Primary keys - This option is correct because primary keys help to maintain referential integrity. They uniquely identify each record in a table and are used as foreign keys in other tables to establish relationships.

Option C) Cascading actions - This option is incorrect because cascading actions help to maintain referential integrity. They define what happens to related records in other tables when the referenced record is updated or deleted.

Option D) Foreign keys - This option is incorrect because foreign keys help to maintain referential integrity. They establish relationships between tables by referencing the primary key of another table.

Based on the explanations above, the correct answer is A) Unique constraints. Unique constraints do not directly help to maintain referential integrity; instead, they ensure that no duplicate values are present in specified columns.

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