Oracle 10g, Databases

Question: Evaluate the following SQL: CREATE USER sam IDENTIFIED BY sam; GRANT CREATE ANY MATERIALIZED VIEW, CREATE ANY DIMENSION, DROP ANY DIMENSION, QUERY REWRITE, GLOBAL QUERY REWRITE TO dw_manager WITH ADMIN OPTION; GRANT dw_manager TO sam WITH ADMIN OPTION; Which of the following actions is the user SAM able to perform?
A
Select from a table

B
Create and drop a materialized view

C
Alter a materialized view that you created

D
Grant and revoke the role to and from other users

E
Enable the role and exercise any privileges in the role's privilege domain

Note: Not available
1. Report
Question: ASM disk groups provide:
A
Redundancy through striping

B
Performance through mirroring.

C
Redundancy through mirroring

D
Performance through striping

Note: Not available
1. Report
Question: Consider the following SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?
A
The server process places the commit record in the redo log buffer

B
Log Writer (LGWR) writes the redo log buffer entries to the redo log files and data files

C
The user process notifies the server process that the transaction is complete

D
The user process notifies the server process that the resource locks can be released

Note: Not available
1. Report
Question: The initialization parameter UNDO_RETENTION is used:
A
To specify the length of time for which Oracle must retain undo data in the undo tablespace

B
To specify the length of time for which Oracle must retain undo data in the flash recovery area

C
To specify the length of time for which Oracle must retain undo data in the data files

D
To specify the length of time for which Oracle will retain undo data in the flashback database logs

Note: Not available
1. Report
Question: The SQL Access Advisor is 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 available
1. Report
Question: ______________ is mandatory for using the easy connect naming method.
A
Host name

B
Database name

C
Service name

D
Port number

Note: Not available
1. Report
Question: The utility SQL*Loader should not be used:
A
While loading selected rows into each table

B
While loading data from an export dump file

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

D
While the data is NOT being inserted from a flat file

Note: not sure
1. Report
Question: What does the ARBn background process do in an ASM instance?
A
Coordinates disk activity

B
Performs disk rebalance work

C
Coordinates disk rebalance work

D
Manages the RBAL process

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: What is the purpose of the flashback technology in Oracle Database 10g?
A
Recovery from physical corruption of a data file

B
Recovery from physical and logical corruption of a data file

C
Recovery from logical corruption of a data file

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

Note: not sure
1. Report

First Prev 1 2 3 Next Last

Question: ASM disk groups provide:

Question: Consider the following SQL statement: UPDATE employees SET first_name = 'John' WHERE emp_id = 1009; COMMIT; What happens when a user issues the COMMIT in the above SQL statement?

Question: The initialization parameter UNDO_RETENTION is used:

Question: The SQL Access Advisor is managed:

Question: ______________ is mandatory for using the easy connect naming method.

Question: The utility SQL*Loader should not be used:

Question: What does the ARBn background process do in an ASM instance?

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: What is the purpose of the flashback technology in Oracle Database 10g?