Database Reference
In-Depth Information
16.
When issuing the
DUPLICATE DATABASE
command, you use the parameter
DB_FILE_
NAME_CONVERT
. For what purpose do you use this parameter?
A.
To indicate the location of the auxiliary-instance online redo logs.
B.
To indicate the location of the target database data files.
C.
To indicate the location of the auxiliary-instance control file and online redo logs.
D.
To indicate the location of the auxiliary-instance database data files.
E.
This is not a valid parameter when duplicating a database.
17.
What is the end result of the following commands?
recover tablespace users
until time '10/06/2013:22:42:00'
auxiliary destination 'c:\oracle\auxiliary';
sql 'alter tablespace users online';
recover tablespace users
until time '10/06/2013:20:40:00'
auxiliary destination 'c:\oracle\auxiliary';
sql 'alter tablespace users online';
A.
The commands will be successful. The
USERS
tablespace will be recovered until
10/06/2013 at 20:40.
B.
The first
RECOVER TABLESPACE
command will fail because the syntax is incorrect.
C.
The first
ALTER TABLESPACE USERS ONLINE
command will fail because the
tablespace will already be online after the
RECOVER
command.
D.
The second
RECOVER TABLESPACE
command will fail because it will be unable to
complete the recovery.
E.
The second
ALTER TABLESPACE USERS ONLINE
command will fail because you can-
not perform two TSPITRs in a row without backing up the database between the
first and the last recovery.
18.
Which of the following is not a valid method of duplicating a database?
A.
Connect to target, connect to auxiliary, do not connect to catalog and perform
active database duplication.
B.
Connect to auxiliary, don't connect to target, don't connect to the catalog and per-
form an active database duplication.
C.
Connect to auxiliary, connect to the catalog and perform a normal database
duplication.
D.
Connect to the target in ARCHIVELOG mode, connect to the auxiliary and con-
nect to the catalog database and perform an active database duplication.
E.
All of the above are valid options.
Search WWH ::
Custom Search