Question 1

How many tables may be included with a join?

technology databases

1
2
3
all of the above

Answer

Correct Option: D

Question 2

Which of the following is true concerning triggers?

technology databases

You do not create them with SQL.
They execute against only some applications that access a database.
They have an event, condition, and action.
They cannot cascade (cause another trigger to fire).

Answer

Correct Option: C

Question 3

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

technology databases

TRUE
FALSE
DO not know
Both

Answer

Correct Option: A

Question 4

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

technology databases

TRUE
FALSE
BOTH
DO NOT KNOW

Answer

Correct Option: A

Question 5

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

technology databases

Log buffer is one-third full
Commit transaction
every three seconds
redo log file switch

Answer

Correct Option: A,B,C

Question 6

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

technology databases

True
False

Answer

Correct Option: B

Question 7

Which process kicks in DBWR process?

technology databases

LGWR
DBWR
CKPT
ARCH

Answer

Correct Option: C

Question 8

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

technology databases

Segment
Block
Tablespace
View

Answer

Correct Option: C

Question 9

Rollback transaction data is stored in which data file.

technology databases

System
Sysaux
Undo
Index

Answer

Correct Option: C

Question 10

Which process creates archive log files?

technology databases

LGWR
ARCH
ZIP
CKPT

Answer

Correct Option: B

Question 11

Which is the smallest logical unit in Oracle database?

technology databases

Extent
Block
Segment
Table

Answer

Correct Option: B

Question 12

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

technology databases

Redo log file
Data file
Archive log file
Control file

Answer

Correct Option: D

Question 13

Give names of different segments.

technology databases

Data Segment
Index Segment
Table Segment
Rollback Segment
Temporary Segment

Answer

Correct Option: A,B,D,E

Question 14

Which file contains all different Oracle configuration parameters?

technology databases

Data file
Control file
Parameter file
Redo log file

Answer

Correct Option: C

Question 15

Which Oracle background process performs instance recovery?

technology databases

PMON
SMON
INSTMON
IMON

Answer

Correct Option: B

Question 16

Which Oracle background process performs server process recovery?

technology databases

PMON
SMON
PROMON
IMON

Answer

Correct Option: A

Question 17

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

technology databases

True
False

Answer

Correct Option: B

Question 18

which are ETL tools

technology databases

Informatica
Datastage
Abnitio
All the above

Answer

Correct Option: D

Question 19

who is the father of datawarehouse

technology databases

Bill Inmon
Dennis Ritchie
shiva
Tal mukha talma

Answer

Correct Option: A

Question 20

which is an passive transformation

technology databases

filter
aggregator
expression
none

Answer

Correct Option: C

Description: databases Online Quiz - 19
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 19

Find more quizzes from top tags