0

databases Online Quiz - 19

Description: databases Online Quiz - 19
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

How many tables may be included with a join?

  1. 1

  2. 2

  3. 3

  4. all of the above


Correct Option: D

AI Explanation

To answer this question, let's discuss the concept of a join in the context of database management systems.

A join is a operation that combines rows from two or more tables based on a related column between them. The purpose of a join is to retrieve data from multiple tables by specifying how the tables are related to each other.

When performing a join, you can include any number of tables as long as they are related through common columns. Therefore, the correct answer is option D - all of the above. With a join, you can include 1, 2, 3, or even more tables, depending on your data and the relationships you want to establish.

It is important to note that including multiple tables in a join can be complex, and you need to ensure that the join conditions are correctly specified to avoid incorrect or unexpected results.

Which of the following is true concerning triggers?

  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).


Correct Option: C

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

  1. TRUE

  2. FALSE

  3. BOTH

  4. DO NOT KNOW


Correct Option: A

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

  1. Log buffer is one-third full

  2. Commit transaction

  3. every three seconds

  4. redo log file switch


Correct Option: A,B,C

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

  1. True

  2. False


Correct Option: B

Which process kicks in DBWR process?

  1. LGWR

  2. DBWR

  3. CKPT

  4. ARCH


Correct Option: C

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

  1. Segment

  2. Block

  3. Tablespace

  4. View


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.

  1. System

  2. Sysaux

  3. Undo

  4. Index


Correct Option: C

Which process creates archive log files?

  1. LGWR

  2. ARCH

  3. ZIP

  4. CKPT


Correct Option: B

Which is the smallest logical unit in Oracle database?

  1. Extent

  2. Block

  3. Segment

  4. Table


Correct Option: B

Which file contains database name, location of data files and important information used to start the Oracle database?

  1. Redo log file

  2. Data file

  3. Archive log file

  4. Control file


Correct Option: D

Give names of different segments.

  1. Data Segment

  2. Index Segment

  3. Table Segment

  4. Rollback Segment

  5. Temporary Segment


Correct Option: A,B,D,E

Which file contains all different Oracle configuration parameters?

  1. Data file

  2. Control file

  3. Parameter file

  4. Redo log file


Correct Option: C

Which Oracle background process performs instance recovery?

  1. PMON

  2. SMON

  3. INSTMON

  4. IMON


Correct Option: B

Which Oracle background process performs server process recovery?

  1. PMON

  2. SMON

  3. PROMON

  4. IMON


Correct Option: A

Archive log is generated only when database is working in ARCHIVELOG mode.

  1. True

  2. False


Correct Option: B

which are ETL tools

  1. Informatica

  2. Datastage

  3. Abnitio

  4. All the above


Correct Option: D

who is the father of datawarehouse

  1. Bill Inmon

  2. Dennis Ritchie

  3. shiva

  4. Tal mukha talma


Correct Option: A

which is an passive transformation

  1. filter

  2. aggregator

  3. expression

  4. none


Correct Option: C
- Hide questions