Which two tasks does DBUA perform by default? (Choose two.)
A. setting user tablespaces to "read only" before starting the upgrade
B. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade
C. running the Pre-Upgrade information tool
D. starting the source database instance if not started
E. enabling flashback in the source database if not enabled
Which two statements are true about the tablespace SEGMENT SPACE MANAGEMENT clause? (Choose two.)
A. It applies only to tablespaces with uniform extent size.
B. It overrides the DEFAULT STORAGE clause specified for a tablespace.
C. It specifies whether used and free extents are tracked using free lists or bitmaps.
D. It specifies whether users have direct control over space allocation for the objects in a tablespace.
E. It applies only to permanent tablespaces.
F. It applies only to smallfile tablespaces.
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.
Examine these steps:
1.
Shut down the database instance.
2.
Modify the parameter in the spfile with scope = SPFILE.
3.
Modify the parameter in a pfile.
4.
Use the spfile to create a pfile.
5.
Use the pfile to create a spfile.
6.
Modify the parameter in the spfile with scope = BOTH.
7.
Start up the database instance.
Which are the minimum required steps in the correct order?
A. 2, 1, 7
B. 1, 7, 2
C. 1, 2, 7
D. 6, 1, 7
E. 1, 4, 3, 5, 7
Which two are true about complete and incomplete recovery? (Choose two.)
A. Uncommitted transactions will be rolled back after complete recovery completes.
B. The database must have FLASHBACK enabled in order to perform incomplete recovery.
C. Uncommitted transactions will be rolled back after incomplete recovery completes.
D. Incomplete recovery is possible only when the database is open.
E. Only incremental backups can be used to roll forward the database while performing complete recovery.
A user complains about poor database performance. You suspect that the user's session is waiting for an
event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)
A. V$SYSTEM_EVENT
B. V$SESSION_EVENT
C. V$SESSION_WAIT_CLASS
D. V$SESSION_WAIT
E. V$SESSION
A user complains about poor database performance. You suspect that the user's session is losing time waiting for events to complete.
You want to verify this.
Which view reveals on what events a session has spent time waiting in the past?
A. V$SESSION_WAIT_CLASS
B. V$SYSTEM_EVENT
C. V$SESSION
D. V$SESSION_EVENT
E. V$SESSION_WAIT
Which two types of files are opened by a database instance in the NOMOUNT state?
A. control files
B. the alert log
C. the initialization parameter file
D. data files
E. online redo logs
Which two are true about RETENTION GUARANTEE? (Choose two.)
A. It is a tablespace attribute.
B. It prevents FLASHBACK DATABASE operation failure.
C. It prevents out-of-space errors.
D. It prevents "Snapshot too old" errors.
E. It is a static parameter.
As the DBA, you execute this command:
BROWN then executes this command:
GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;
Which is true?
A. You can revoke only WITH GRANT OPTION from BROWN.
B. BROWN can revoke only WITH GRANT OPTION from SCOTT.
C. When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
D. When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
E. When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.
Which two are true about roles? (Choose two.)
A. The ALTER USER statement must be used to set specific default roles for a user.
B. A role must be disabled before it can be revoked from a user.
C. The SET ROLE statement can be used once per session.
D. The SET ROLE statement enables as well as disables roles in a session.
E. All privileges and roles granted to a user are enabled by default when the user logs in.
