1z0-067 | 10 Tips For Updated 1z0-067 examcollection
Q21. Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table) Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
A. It recovers the structure, data, and indexes of the first emp table.
B. It recovers only the structure of the second emp table.
C. It returns an error because two tables with the same name exist in the recycle bin.
D. It recovers the structure, data, and indexes of the second emp table.
Answer: A
Q22. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?
A. by using the RMAN switch command to set the new location for the data files
B. by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host
C. by using the RMAN duplicate command with dbid and set nekname for tablespace to recover the database to the new host
D. by creating a new database in the new host, and then using the RMAN recover command
Answer: D
144. Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ; RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?
A. The script is executed and bothDC1and chi channels are used for script execution.
B. The execution of the script fails because multiple channels cannot exist simultaneously.
C. The persistent configuration parameter,DC1, is overridden because a new channel is allocated in the RMAN run block.
D. The new channel, chi, is ignored because a channel has been configured already.
Answer: C
Q23. While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?
A. Configure backup optimization.
B. Configure the channel to increase maxopenfiles.
C. Configure a backup policy by using incremental backups.
D. Configure the channel to increase capacity with the rate parameter.
E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.
F. Configure large_pool, if not done already. Alternatively, you can increase the size of
G. LARGE_POOL.
Answer: A,D
Q24. Which four actions are possible during an Online Datafile Move operation?
A. Creating and dropping tables in the datafile being moved
B. Performing file shrink of the data file being moved
C. Querying tables in the datafile being moved
D. Performing Block Media Recovery for a data block in the datafile being moved
E. Flashing back the database
F. Executing DML statements on objects stored in the datafile being moved
Answer: A,C,E,F
Explanation: You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM.
-New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running): It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You con use this Command to move the Datafile
-A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback. Oracle0 Database Administrator's Guide 12c Release 1 (12.1)
Q25. You want the execution of large database operations to suspend, and then resume, in the event of space allocation failures.
You set the value of the initialization parameter resumable_timeout to 3600.
Which two statements are true?
A. A resumable statement can be suspended and resumed only once during execution.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.
C. A suspended statement will report an error if no corrective action has taken place during a timeout period.
D. Before a statement executes in resumable mode, the alter session enable resumable statement must be issued in its session.
E. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.
Answer: A,D
Q26. On your Oracle 12c database, you invokeSQL*Loaderto load data into the employees table
in the hr schema by issuing the command:
S>sqlldrhr/hr@pdb table=employees
Which two statements are true about the command?
A. It succeeds with default settings if the employees table exists in the hr schema.
B. It fails because noSQL*Loaderdata file location is specified.
C. It fails if the hr user does not have the create any directory privilege.
D. It fails because noSQL*Loadercontrol file location is specified.
E. It succeeds and creates the employees table in theHRschema.
Answer: A,C
Q27. Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?
A. Reduced logical I/O
B. Reduced virtual memory utilization
C. Improved Serial Execution performance
D. Reduced physical I/O
E. Reduced CPU utilization
Answer: B,C,E
Q28. You issue the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RKAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUPON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which three tasks are performed by the BACKUP DATABASEcommand?
A. switching the online redo log file
B. backing up all data files as image copies and archive log files, and deleting those archive log files
C. backing up only the used blocks in the data files
D. backing up all used and unused blocks in the data files
E. backing up all archived log files and marking them as obsolete
Answer: A,C,E
Q29. A database is running in archivelog mode. You want to back up a 10 TB data file belonging to the users tablespace. The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?
A. image copy backup by using RMAN
B. multisection image copy backup by using RMAN
C. multisection parallel backup by using RMAN
D. cold backup after taking the tablespace offline
E. cold backup after placing the tablespace in backup mode
Answer: A
Q30. Which two statements are true about dropping a pluggable database (PDB)?
A. A PDB must be in mount state or it must be unplugged.
B. The data files associated with a PDB are automatically removed from disk.
C. A dropped and unplugged PDB can be plugged back into the same multitenant container database (CDB) or other CDBs.
D. A PDB must be in closed state.
E. The backups associated with a PDB are removed.
F. A PDB must have been opened at least once after creation.
Answer: A,D
Reference:http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13858