Databases - Upwork

Question: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?
A
SYSTEM, SYSAUX, and UNDOTBS

B
SYSTEM and UNDOTBS

C
SYSAUX and UNDOTBS

D
SYSTEM and SYSAUX

Note: not sure
1. Report
Question: To grant a system privilege with the GRANT statement, one should:
A
Have been granted the GRANT ROLE PRIVILEGE system privilege

B
Have been granted the system privilege with the ADMIN OPTION

C
Have been granted the GRANT ANY PRIVILEGE system privilege

D
Have been granted the system privilege with the GRANT OPTION

Note: not sure
1. Report
Question: Which two statements are true about rebuilding an index?
A
The resulting index may contain deleted entries

B
A new index is built using an existing index as the data source

C
Queries cannot use the existing index while the new index is being built

D
During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces

Note: not sure
1. Report
Question: When a deadlock shutdown is detected by Oracle, where is the trace file generated?
A
SQL_TRACE

B
TRACE_DEST

C
USER_DUMP_DEST

D
CORE_DUMP_DEST

Note: not sure
1. Report
Question: How can the SQL Access Advisor be managed?
A
Through the DBMS_SQLTUNE package

B
Through the DBMS_ADVISOR package

C
Through the SQL_TUNE package

D
Through the DBA_ADVISOR package

Note: not sure
1. Report
Question: User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?
A
DBA_INDEXES only

B
DBA_IND_COLUMNS only

C
DBA_INDEXES and DBA_USERS

D
DBA_IND COLUMNS and DBA_USERS

Note: not sure
1. Report
Question: For which two tasks would it be best not to use the utility SQL*Loader?
A
When loading selected rows into each table

B
When loading data from an export dump file

C
When loading data from disk, tape, or named pipes

D
When data is not being inserted from a flat file

Note: not sure
1. Report
Question: Which of the following helps the user identify his statement in the DBA_TUNE_MVIEW view?
A
The STATEMENT variable

B
The STATEMENT_ID column

C
The VIEW_ID column

D
The TASK_NAME variable

Note: not sure
1. Report
Question: Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining?
A
REMOVE_LOGFILE

B
CONTINUOUS_MINE

C
NO_ROWID_IN_STMT

D
AUTOMATIC_LOGFILE

Note: not sure
1. Report
Question: Which of the following commands are used to copy ASM files?
A
RMAN commands

B
OMF commands

C
Operating system commands

D
Logical Volume Manager commands

Note: not sure
1. Report

First Prev 70 71 72 73 74 Next Last

Question: Which of the following sets of tablespaces is mandatory for any Oracle 10g database?

Question: To grant a system privilege with the GRANT statement, one should:

Question: Which two statements are true about rebuilding an index?

Question: When a deadlock shutdown is detected by Oracle, where is the trace file generated?

Question: How can the SQL Access Advisor be managed?

Question: User Smith created indexes on some tables owned by user John. The following has to be displayed: 1.Index names 2.Index types Which data dictionary view(s) should be queried?

Question: For which two tasks would it be best not to use the utility SQL*Loader?

Question: Which of the following helps the user identify his statement in the DBA_TUNE_MVIEW view?

Question: Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining?

Question: Which of the following commands are used to copy ASM files?