[Practical] 1Z0-063 Oracle test preparation 11-20 (Oct 2017)

Your success in Oracle 1Z0-063 is our sole target and we develop all our 1Z0-063 braindumps in a way that facilitates the attainment of this target. Not only is our 1Z0-063 study material the best you can find, it is also the most detailed and the most updated. 1Z0-063 Practice Exams for Oracle Database 12c 1Z0-063 are written to the highest standards of technical accuracy.

Q11. The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rci2c user. 

The CATD3H database contains an Oracle Database Ug catalog schema owned by the rch user. 

A database with dbid=H2324I is registered in the catdbII catalog. Both the recovery catalog databases are open. 

In the CATD3i2c database, you execute the commands: 

: r-ar. 

RKAN> CONNECT CATALOG rci2c/passI2c@catdbi2c 

RKAN> IMPORT CATALOG rcii/pwdcatUQcatdfoil DBI2=142324i; 

What is the outcome of the import? 

A. It fails because the target database and recovery catalog database are of different versions. 

B. It succeeds and all global scripts in the rci: catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed. 

C. It succeeds but the database is not automatically registered in the rc:2c catalog. 

D. It fails because RMAN is not connected to the target database with r3:T=:42324:. 

Answer:


Q12. Examine the commands executed in CDBS ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB): 

SQL> CREATE ROLE c ##role1 CONTAINER-ALL; 

SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL; 

SQL>CREATE USER c##adnin IDENTIFIED BY orcl123; 

SQL>GRANT c##role1 TO c##admin CONTAINER=ALL; 

SQL> GRANT SELECT ON DBA_USERS to c##rola1 CONTAINER*ALL; 

Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role? 

A. The command fails and gives an error because object privileges cannot be granted to a common user. 

B. The command fails because container is not set to current. 

C. The command succeeds and the common user cmadnxn can create a session and query the D3A_users view incdbssoo? and all the PDBs. 

D. The command succeeds and the common user ct (admin can create a session in cdbSroot and all the PDBs, but can only query the dba_users view in ct3S?cdt. 

E. The command succeeds and the common user c#(admin can create a session and query the D3A users view only in cdbsrooi. 

Answer:


Q13. Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs): 

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123; 

SQL> CREATE ROLE c##role1 CONTAINER=ALL; 

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL; 

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL; 

SQL> REVOKE c##role1 FROM c##a_admin; 

What is the result of the revoke command? 

A. It executes successfully and the c##role1role is revoked from the c##a_admin user only in the root container. 

B. It fails and reports an error because the container=all clause is not used. 

C. It executes successfully and the c##rocl1 role is revoked from the c##a_admin user in the root database andall the PDBs. 

D. It fails and reports an error because the comtainer=current clause is not used. 

Answer:


Q14. Examine the commands executed to monitor database operations: $> conn sys/oracle@prod as sysdba 

SQL> VAR eid NUMBER 

SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job’,FORCED_TRACKING=>'Y'); 

Which two statements are true? 

A. Database operations will be monitored only when they consume a significant amount of resource. 

B. Database operations for all sessions will be monitored. 

C. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING. 

D. Only DML and DDL statements will be monitored for the session. 

E. All subsequent statements in the session will be treated as one database operation and will be monitored. 

Answer: C,E 

Explanation: C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack. 

Note: 

* The DBMS_SQL_MONITOR package provides information about Real-time SQL 

Monitoring and Real-time Database Operation Monitoring. 

*(not B) BEGIN_OPERATION Function starts a composite database operation in the 

current session. 

/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'. 

/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'. 


Q15. Which three statements are true about the keystore storage framework for transparent data encryption? 

A. It facilitates and helps to enforce keystore backup requirements. 

B. It handles encrypted data without modifying applications. 

C. It enables a keystore to be stored only in a file on a file system. 

D. It enables separation of duties between the database administrator and the security administrator. 

E. It transparently decrypts data for the databaseusers and applications that access this data. 

F. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations. 

Answer: A,D,F 

Reference: http://oradb-srv.wlv.ac.uk/E16655_01/network.121/e17729/asotrans.htm#CHDEABCA (benefits of the keystore storage framework) 


Q16. You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameterto YYYY-MM-DD. The default format of which two data types would be affected by this setting? 

A. DATE 

B. TIMESTAMP 

C. INTERVAL YEAR TO MONTH 

D. INTERVAL DAY TO SECOND 

E. TIMESTAMP WITH LOCAL TIME ZONE 

Answer: B,E 


Q17. A user issues a query on thesales table and receives the following error: 

ERROR at line 1: 

ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf' 

ORA-27037: unable to obtain file status 

Which two actions would you take to recover the temporary tablespace? 

A. Drop the tenpOi.dbf file, and then re-create the temp file. 

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file. 

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database. 

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online. 

E. Create a new temporary tablespace and assign it as the default to the user. 

Answer: D,E 


Q18. In your database, there are tablespaces that were read-only when thelast backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. 

What precaution must you take for the read-only tablespaces before performing anincomplete recovery? 

A. All the read-only tablespaces should be taken offline. 

B. All the read-only tablespaces should be restored separately. 

C. All the read-only tablespaces should be renamed to have the MISSINGnnnn format. 

D. All the read-only tablespacesshould be made online with logging disabled. 

Answer:


Q19. Examine the command: 

$expdp SYSTEM FULL=YES DUMPFILE=dpump_dir1:fulll%U.dmp, dpump_dir2:full2% U.dmp, dpump_dir3:full3%U.djnp FILESIZE=400M PARALLEL=3 JOB_NAME=expfull 

Which statement is true about the execution of the command? 

A. It fails because the log file parameter is not specified. 

B. It fails because no absolutepath is specified for the log file and dump file. 

C. It succeeds and exports the full database, simultaneously creating three copies of dump files at three different locations. 

D. It succeeds and exports the full database, simultaneously creating three dump files at three different locations, but the total number of dump files can exceed three. 

Answer:


Q20. Which three RMAN persistent settings can be set for a database? 

A. backup retention policy 

B. default backup device type 

C. default section size for backups 

D. default destinations for backups 

E. multiple backup device types for a single backup 

Answer: A,B,D 

Reference:http://docs.oracle.com/cd/B19306_01/backup.102/b14192/setup004.htm#i10197 39