Dumps Moneyack Guarantee - 1z0-063 Dumps UpTo 50% Off
Updated Dec-2021 Pass 1z0-063 Exam - Real Practice Test Questions
More Info
For more info visit: Oracle 12c Official 1Z0-063 Exam Reference
NEW QUESTION 136
Which two are prerequisites for setting up Flashback Data Archive?
- A. Fast Recovery Area should be defined.
- B. Supplemental logging should be enabled.
- C. Undo retention guarantee should be enabled.
- D. Automatic Undo Management should be enabled.
- E. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
- F. All users using Flashback Data Archive should have unlimitedquota on the Flashback Data Archive tablespace.
Answer: D,E
Explanation:
Reference:http://www.oracle.com/technetwork/database/focus-areas/storage/total-recallwhitepaper-171749.pdf(page 8)
NEW QUESTION 137
The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:
What is the outcome of the import?
- A. It succeeds but the database is not automatically registered in the RC12ccatalog.
- B. It succeeds and all global scripts in the RC11catalog that have the same name as existing global scripts in the RC12Ccatalog are automatically renamed.
- C. It fails because the target database and recovery catalog database are of different versions.
- D. It fails because RMAN is not connected to the target database with DBID=1423241.
Answer: C
NEW QUESTION 138
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQL> CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQL> GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL;
SQL> GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?
- A. It can create only local users in all the PDBs.
- B. It can create only local users in the CDB.
- C. It can create common users only when it is logged in to the CDB.
- D. It has a common schema for all the PDBs.
- E. It can be granted only common roles in the PDBs.
Answer: A,D
NEW QUESTION 139
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true? (Choose two.)
- A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
- B. The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.
- C. Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.
- D. The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.
- E. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
Answer: A,D
Explanation:
Explanation/Reference:
Explanation:
https://docs.oracle.com/cd/E18283_01/server.112/e17120/restart001.htm
NEW QUESTION 140
One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open?
(Choose four.)
- A. Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace.
- B. Recover both tablespaces.
- C. Take both tablespaces OFFLINE IMMEDIATE.
- D. Bring both tablespaces ONLINE.
- E. Restore both tablespaces from the most recent backup.
- F. Take both tablespaces OFFLINE NORMAL.
Answer: B,C,D,E
NEW QUESTION 141
You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?
- A. The backup must be performed in mount state.
- B. All files must be backed up as backup sets.
- C. The database must be backed up as an image copy.
- D. The tablespace must betaken offline.
Answer: A
NEW QUESTION 142
In which three situations must you use a recovery catalog? (Choose three.)
- A. when you want to perform incremental backups by using a block change tracking file
- B. when you want to list data files that were in a target database at a given time by using the ATclause with the REPORT SCHEMAcommand
- C. when you want to store RMAN global scripts that can be used across multiple databases
- D. when you want to restrict the amount of space used by backups
- E. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIMEparameter
Answer: B,C,E
Explanation:
A: Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.
A local stored script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to this target database. A global stored script can be run against any database registered in the recovery catalog.
D: If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command:
RMAN> REPORT SCHEMA AT TIME 'SYSDATE-14'; # schema 14 days ago
RMAN> REPORT SCHEMA AT SCN 1000; # schema at scn 1000
RMAN> REPORT SCHEMA AT SEQUENCE 100 THREAD 1; # schema at sequence 100
RMAN> REPORT SCHEMA FOR DB_UNIQUE_NAME standby1;
E: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter determines the minimum number of days that records are retained in the control file before they are candidates for being overwritten. Thus, you must ensure that you resynchronize the recovery catalog with the control file records before these records are erased.
References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm
https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911
NEW QUESTION 143
You take your database backups by using the RMAN media management interface (MMI).
Which two are true about the use of the RMAN MMI? (Choose two.)
- A. You can use it to create image copies for entire file systems.
- B. You can use it to create proxy copies for entire file systems.
- C. You can use it to create backup sets for database files.
- D. You can use it to create image
- E. You can use it to create proxy copies for database files.
Answer: C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/ADMQS/GUID-0A8FC1FE-0994-49A7-9F22-
2E3F5FAEAF68.htm#ADMQS0926
NEW QUESTION 144
Which three statements are true about compression of backup sets?
- A. Compressed backups cannot have section size defined during a backup operation
- B. It works only for locally managed tablespaces.
- C. Unused blocks below the high-water mark are not backed up.
- D. Compressed backups can only be written to media.
- E. Binary compression creates performance overhead during a backup operation.
Answer: B,C,E
NEW QUESTION 145
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHA
R2,v_SALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure frominserting values into tables on which they do not have any privileges?
- A. Create the create_test procedure with invoker's rights.
- B. Create the create_test procedure as part of a package and grant users the execute privilege on the package.
- C. Create the create_test procedure with definer's rights.
- D. Grant the execute privilege to users with grant option on the create_test procedure.
Answer: A
NEW QUESTION 146
Identify three benefits of unified auditing.
- A. It guarantees zero-loss auditing.
- B. An audit trail cannot be modified because it is read-only.
- C. It automatically audits Recovery Manager (RMAN) events.
- D. It reduces overhead on a database caused by auditing,by having a single audit trail.
- E. It helps to reduce disk space used to store an audit trail in a database.
Answer: B,C,D
NEW QUESTION 147
Your multitenant container database (CDB) CDB1 has two pluggable databases, PDB1 and PDB2. The local net service name CDB1 connects to the root database, and the service names PDB1 and PDB2 connect to the pluggable databases (PDBs), PDB1 and PDB2, respectively.
Examine the commands to change the value of the PDB modifiable initialization parameter:
Which statement is true about the OPTIMIZER_USE_SQL_PLAN_BASELINES parameter?
- A. It is set to TRUE for the root database and all the PDBs, because the value set at the root level has higher precedence.
- B. It gives an error because it cannot be set for the root database.
- C. It is set to TRUE for the root database and all the PDBS, but is effective only when the CDB is restarted and the PDBs are reopened.
- D. It is set to TRUE for the root database and the pluggable database PDBs, because values can be set for this parameter at the PDB level in a PDB.
Answer: D
NEW QUESTION 148
In your database, the user SCOTT wants to retrieve the dropped HR. EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed?
- A. No duplicates of the HR. EMPLOYEES table should exist in the recyclebin of the HR schema.
- B. No other table with the same name should exist in the HR schema.
- C. The recycle bin should be enabled.
- D. Undo retention guarantee must be enabled.
- E. SCOTT should have the FLASHBACK ANY TABLE privilege.
- F. SCOTT should have the SELECT privilege on the HR schema and its recyclebin.
Answer: C,E,F
NEW QUESTION 149
Which Oracle Database component is audited by default if the Unified Auditing option is enabled?
- A. Oracle Label Security
- B. Oracle Data Pump
- C. Oracle Real Application Security
- D. Oracle Database Vault
- E. Oracle Recovery Manager (RMAN)
Answer: E
NEW QUESTION 150
Which statement is true about the loss or damage of a temp file that belongs to the temporary tablespace of a pluggable database (PDB)?
- A. The PDB does not close and the temp file is re-created automatically whenever the container database (CDB) is opened.
- B. The PDB is closed and the temp file is re-created automatically when the PDB is opened.
- C. The PDB does not close and starts by using the default temporary tablespace defined for the CDB.
- D. The PDB is closed and requires media recovery at the PDB level.
Answer: A
NEW QUESTION 151
View the Exhibit showing steps to create a database resource manager plan.
SQL>execute dbms_resource_manager.create_pendingarea();
PL/SQL procedure successfully completed.
SQL>exec dbms_resource_manager, create_consumergroup
( consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQL procedure successfully completed.
SQL>exec bras resource_manager.create plan
( plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive
( plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comment=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After executing the steps in the exhibit you execute this procedure, which
results in an error:
SQL> EXECUTE dbms_resource_manager. validate_pending_area ();
What is the reason for the error?
- A. The sys_group group is not included in the resource plan.
- B. The other_groups group is not included in the resource plan.
- C. The procedure must be executed before creating any plan directive.
- D. The pending area is automatically submitted when creating plan directives.
- E. Pending areas can not be validated until submitted.
Answer: B
NEW QUESTION 152
Which two are benefits of unified auditing in full mode? (Choose two.)
- A. The audit trail is in a single format.
- B. The audit trail uses less space.
- C. All audit data is written to both the traditional locations and to the unified location.
- D. The audit trail is read-only.
- E. Pre 12c audit data is written to the traditional locations and new 12c audit data is written to the unified location.
Answer: A,D
NEW QUESTION 153
Examine the probable steps involved in the basic backup process of RMAN and Oracle Secure Backup (OSB):
1. RMAN initiates backup and passes the database backup storage selector to OSB.
2. RMAN creates the backup job.
3. OSB creates the backup job with an OSB user.
4. RMAN updates its repository.
5. RMAN executes the job and transfers data from a client to media.
6. OSB executes the job and transfers data from a client to media.
7. OSB updates its repository.
Identify the required steps in the correct order.
- A. 1, 3, 6, 7, 4
- B. 1, 3, 5, 7, 4
- C. 1, 3, 6, 4, 7
- D. 2, 1, 6, 4, 7
Answer: A
Explanation:
The storage selector act as a layer between RMAN, which accesses the database, and the Oracle Secure Backup software, which manages the backup media.
For backups, Oracle Secure Backup stores metadata about RMAN backup pieces in the Oracle Secure Backup catalog.
The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm
NEW QUESTION 154
Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
- A. Tables or table partitions from the system and sysaux tablespaces cannot be recovered.
- B. Tables or table partitions can be recovered by using an auxiliary instance only.
- C. Tables with not null constraints cannot be recovered.
- D. Tables or table partitions with a foreign key cannot be recovered.
- E. Tables or table partitions can be recovered only when the database is in mount state.
Answer: A,B
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/database/121/BRADV/rcmresind.htm#BRADV695 (Limitations of Recovering Tables and Table Partitions from RMAN Backups)
NEW QUESTION 155
Examine the statements that use flashback technologies:
1. FLASHBACK TABLEcustomers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00',
'YYYY-MM-DD HH:MI:SS');
2. SELECT * FROM customers AS OF SCN 123456;
3. FLASHBACK TABLE customers TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5. SELECT * FROM customers VERSIONS BETWEEM SCN 123456 AND 123999;
6. ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?
- A. 3, 4, 5
- B. 1, 2, 5
- C. 1, 3, 6
- D. 2, 3, 5, 6
Answer: B
NEW QUESTION 156
The CATDB12cdatabase contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both databases are open.
You execute the RMAN commands:
Which two tasks are performed as part of the import? (Choose two.)
- A. Imported databases are unregistered from the RC11 catalog.
- B. Recovery catalog is resynchronized with the control files of the registered databases.
- C. Local and global stored scripts that have the same name as existing scripts in the RC12Ccatalog are automatically renamed.
- D. All databases registered in the RC11catalog are registered in the RC12Ccatalog.
- E. Databases from the RC12C catalog are implicitly unregistered if the RC11catalog has registered databases with same name.
Answer: A,D
NEW QUESTION 157
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)
- A. tracking the most recent write time for a table segment in a user tablespace
- B. tracking the most recent read time for a table segment in the sysaux tablespace
- C. tracking the most recent read time for a table segment in a user tablespace
- D. tracking the most recent write time for each block in a table segment
- E. tracking insert time by row for table rows
- F. tracking the most recent write time for a table segment in the sysaux tablespace
Answer: A,C,D
NEW QUESTION 158
When is the UNDO_RETENTIONparameter value ignored by a transaction?
- A. when Flashback Database is enabled
- B. when the undo tablespace is of a fixed size and retention guarantee is not enabled
- C. when the data file of the undo tablespace is autoextensible
- D. when there are multiple undotablespaces available in a database
Answer: B
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/undo.htm (undo retention, see the bullets)
NEW QUESTION 159
Examine this command:
Which two statements are true after successful execution? (Choose two.)
- A. PDB2 will be open read-only.
- B. PDB2 will use shared UNDO.
- C. A metadata description of PDB2 is stored in an XML file in '/disk2/oracle/pdb2/'.
- D. PDB2 will be in MOUNT state.
- E. A metadata description of PDB2 is stored in the system tablespace of PDB1.
Answer: D,E
NEW QUESTION 160
......
Download Free Oracle 1z0-063 Real Exam Questions: https://www.pass4sures.top/12c/1z0-063-testking-braindumps.html