Databases - Upwork

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
Question: Which of the following items are stored in the flash recovery area?
A
Datafiles

B
Undo segments

C
Datafile copies

D
Archived redo log files

Note: not sure
1. Report
Question: What is the purpose of the flashback technology in Oracle Database 10g?
A
Recovery of a data file from physical corruption

B
Recovery of a data file from physical and logical corruption

C
Recovery of a data file from logical corruption

D
Recovery from a problem brought on by a damaged disk drive

Note: not sure
1. Report
Question: Where can the nondefault parameters be found when the instance is started?
A
Alert log

B
Online redo log

C
Archiver redo log

D
SYSTEM user's trace file

Note: not sure
1. Report
Question: Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?
A
TEMP

B
DATA

C
SYSTEM

D
ROLLBACK

Note: not sure
1. Report
Question: Which of the following are considered types of segments?
A
Only LOBS

B
Only nested tables

C
Only index-organized tables

D
Only LOBS and index-organized tables

E
Nested tables, LOBS, index-organized tables, and boot straps

Note: not sure
1. Report
Question: What does the RMAN CATALOG command do?
A
Helps create image copies of datafiles

B
Helps create image copies of current control files

C
Helps catalog any new files that aren't a part of the recovery catalog

D
Helps catalog only the old files

Note: not sure
1. Report
Question: Which command would revoke the ROLE_DATA role from all users?
A
REVOKE role_data FROM ALL;

B
REVOKE role_data FROM PUBLIC;

C
REVOKE role_data FROM default;

D
REVOKE role_data FROM ALL_USERS;

Note: not sure
1. Report

First Prev 69 70 71 72 73 Next Last

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?

Question: Which of the following items are stored in the flash recovery area?

Question: What is the purpose of the flashback technology in Oracle Database 10g?

Question: Where can the nondefault parameters be found when the instance is started?

Question: Which tablespace is used as the temporary tablespace if 'TEMPORARY TABLESPACE' is not specified for a user?

Question: Which of the following are considered types of segments?

Question: What does the RMAN CATALOG command do?

Question: Which command would revoke the ROLE_DATA role from all users?