Oracle 10g Database Administration, Databases

Question: What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?
A
Global statistics only

B
Global and partition statistics only

C
Global, partition, and subpartition statistics

D
No partitioned table statistics

Note: not sure
1. Report
Question: Which of the following commands must be used to apply incremental backups?
A
RECOVER BACKUP OF DATABASE

B
RECOVER DATAFILE

C
RECOVER COPY OF DATAFILE

D
RECOVER COPY OF DATABASE

Note: not sure
1. Report
Question: Who will be the owner of the job, if you create a job in user SCOTT's schema?
A
SYS will be the owner of the job

B
You will be the owner of the job

C
PUBLIC will be the owner of the job

D
SCOTT will be the owner of the job

Note: not sure
1. Report
Question: Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?
A
The User Global Area (UGA) may only contain sort areas

B
The User Global Area (UGA) may be accessible to dedicated servers

C
The User Global Area (UGA) components may reside in the large pool

D
The User Global Area (UGA) components may reside in the buffer cache

Note: not sure
1. Report
Question: Which three among the following dynamic performance views obtain information from the control file?
A
V$LOG

B
V$SGA

C
V$THREAD

D
V$VERSION

E
V$DATAFILE

Note: not sure
1. Report
Question: Which option lists the correct hierarchy of storage structures, from largest to smallest?
A
Segment, extent, tablespace, data block

B
Data block, extent, segment, tablespace

C
Tablespace, extent, data block, segment

D
Tablespace, segment, extent, data block

Note: not sure
1. Report
Question: What is the priority level for a job in a job class?
A
From 1 to 5

B
From 1 to 999

C
From 1 to 10

D
A job can only take a value of HIGH or LOW.

Note: not sure
1. Report
Question: For which two constraints are indexes created when the constraint is added?
A
Check

B
Unique

C
Not null

D
Primary key

Note: not sure
1. Report
Question: Which conditions among the following must be met, if the tablespace is to be made read only?
A
The tablespace must contain an active rollback segments

B
The tablespace must be online

C
The tablespace must not contain any active rollback segments

D
The tablespace must not be involved in an open backup

E
The tablespace must be involved in an open backup

Note: not sure
1. Report
Question: Which background process performs a checkpoint in the database,by writing modified blocks from the database buffer cache in the SGA to the data files?
A
LGWR

B
SMON

C
DBWn

D
CKPT

Note: not sure
1. Report

First Prev 1 2 3 4 5 Next Last

Question: What statistics will Oracle collect If LIST subpartitioning is used, and the value of the GRANULARITY argument is specified as AUTO?

Question: Which of the following commands must be used to apply incremental backups?

Question: Who will be the owner of the job, if you create a job in user SCOTT's schema?

Question: Which statement is true when connecting to the Oracle instance using the multithreaded server configuration?

Question: Which three among the following dynamic performance views obtain information from the control file?

Question: Which option lists the correct hierarchy of storage structures, from largest to smallest?

Question: What is the priority level for a job in a job class?

Question: For which two constraints are indexes created when the constraint is added?

Question: Which conditions among the following must be met, if the tablespace is to be made read only?

Question: Which background process performs a checkpoint in the database,by writing modified blocks from the database buffer cache in the SGA to the data files?