Tag: databases

Questions Related to databases

Which of the following is a correlated subquery?

technology databases

  1. Uses the result of an inner query to determine the processing of an outer query.

  2. Uses the result of an outer query to determine the processing of an inner query.

  3. Uses the result of an inner query to determine the processing of an inner query.

  4. Uses the result of an outer query to determine the processing of an outer query.

Show answer
Correct Option: B

How many tables may be included with a join?
technology databases

  1. 1

  2. 2

  3. 3

  4. all of the above

Show answer
Correct Option: D

Which of the following is true concerning triggers?
technology databases

  1. You do not create them with SQL.

  2. They execute against only some applications that access a database.

  3. They have an event, condition, and action.

  4. They cannot cascade (cause another trigger to fire).

Show answer
Correct Option: C

There should be one condition within the WHERE clause for each pair of tables being joined.
technology databases

  1. TRUE

  2. FALSE

  3. DO not know

  4. Both

Show answer
Correct Option: A

The code to create triggers and routines is stored in only one location and is administered centrally.
technology databases

  1. TRUE

  2. FALSE

  3. BOTH

  4. DO NOT KNOW

Show answer
Correct Option: A

When LGWR process write redo log buffer to redo log files?

technology databases

  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch

Show answer
Correct Option: A,B,C

C-EMS Oracle database is configured as NO ARCHIVELOG mode.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which process kicks in DBWR process?
technology databases

  1. LGWR

  2. DBWR

  3. CKPT

  4. ARCH

Show answer
Correct Option: C

Name logical unit of storage which is combination of one of more datafiles.

technology databases

  1. Segment

  2. Block

  3. Tablespace

  4. View

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of storage in a database system.

Option A) Segment - This option is incorrect. A segment is a logical unit of storage in a database that consists of one or more extents, which in turn are made up of multiple data blocks.

Option B) Block - This option is incorrect. A block is the smallest unit of storage in a database, and it is used to store data within a datafile.

Option C) Tablespace - This option is correct. A tablespace is a logical unit of storage in a database that is made up of one or more datafiles. It is used to group related data together and provides a way to manage and allocate storage for database objects such as tables, indexes, and partitions.

Option D) View - This option is incorrect. A view is a virtual table that is derived from one or more tables or other views. It does not represent a logical unit of storage.

The correct answer is C) Tablespace. This option is correct because a tablespace is a logical unit of storage that is made up of one or more datafiles.

Rollback transaction data is stored in which data file.
technology databases

  1. System

  2. Sysaux

  3. Undo

  4. Index

Show answer
Correct Option: C