Oracle Upgrade to Oracle Database 12c - 1Z0-060 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1with SQL:

There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1failure group becomes unavailable due to error or for maintenance?

A. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed. B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online. C. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring. D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated. E. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 2

You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?

A. The database must use block change tracking for the flashback to succeed. B. The database must have multiplexed redo logs for the flashback to succeed. C. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN. D. The database must be opened with the RESETLOGSoption after the flashback is complete. E. The database must be opened in restricted mode for the flashback to succeed. F. The database must be MOUNTED for the flashback to succeed.

Discussion 0

Correct Answer: D,F Vote an answer

Question 3

You are planning the creation of a new multitenant container database (CDB) and want to store the ROOT and SEED container data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this?

A. Specify all files in the CREATE DATABASE statement without using Oracle managed Files (OMF). B. Specify the DB_FILE_NAMECONVERT initialization parameter. C. Specify the PDB_FILE_NAME_CONVERT initialization parameter. D. Specify the SEED FILE_NAME_CONVERT clause. E. Use Oracle Managed Files (OMF).

Discussion 0

Correct Answer: C,D,E Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 4

Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1
service.
3. An aggregated trace file is created for all the sessions that are
running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?

A. 2 and 5 B. 3 and 5 C. 2 and 4 D. 1 E. 3 and 4

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 5

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

A. Each Oracle process runs an SCMN thread. B. Thread creation must be routed through a dispatcher process. C. The local listener may pass the request to an existing process which in turn will create a thread. D. Each multithreaded Oracle process has an SCMN thread.

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set. B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set. C. Data is never redacted for the EMP_V.SAL column. D. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Discussion 0

Correct Answer: C,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 7

The persistent configuration settings for RMAN have default for all parameters.
Identify four RMAN commands that produce a multi-section backup.

A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; C. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M; D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M; E. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; F. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; G. BACKUP SPFILE SECTION SIZE 1M;

Discussion 0

Correct Answer: A,B,C,F Vote an answer

Question 8

A redaction policy was added to the SALcolumn of the SCOTT.EMPtable:

All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A. SYSTEM session, only if the MGR role is set in the session B. SYSTEM sessions, regardless of the roles that are set in the session C. SCOTT sessions, because he is the owner of the table D. SCOTT sessions, only if the MGR role is set in the session E. SCOTT sessions, only if the MGR role is granted to SCOTT F. SYS sessions, regardless of the roles that are set in the session

Discussion 0

Correct Answer: B,E,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 9

You execute the following PL/SQL:

Which two statements are true?

A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed. B. FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICE column. C. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed. D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

Discussion 0

Correct Answer: A,D Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 10

Which three statements are true about tablespaces in a multitenant container database (CDB)?

A. CDBs and PDBs may share the same temporary tablespace that is present in the root container. B. There can be only one temporary tablespace group in a CDB. C. All PDBs and CDBs have their own SYSTEM and SYSAUX tablespaces. D. Each pluggable database (PDB) can have a temporary tablespace or a tablespace group. E. All PDBs and CDBs have their own UNDO tablespaces.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question 11

Which two statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?

A. The granter of system privileges must possess the set container privilege. B. System privileges apply only to the PDB in which they are used. C. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users. D. Local users cannot use local system privileges on the schema of a common user. E. Common users connected to a PDB can exercise privileges across other PDBs.

Discussion 0

Correct Answer: A,C Vote an answer

Question 12

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

A. The CDB must be in the nomount stage. B. Alt existing PDBs must be closed. C. The CDB must be open. D. The CDB must be in the mount stage.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 13

Examine the following parameters for a database instance:

Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)? (Choose three.)

A. LOG_BUFFER B. JAVA_POOL_SIZE C. SORT_AREA_SIZE D. STREAMS_POOL_SIZE E. DB_KEEP_CACHE_SIZE F. DB_16K_CACHE_SZIE

Discussion 0

Correct Answer: A,E,F Vote an answer

Explanation: Only visible for FreeCram members. You can sign-up / login (it's free).

Question 14

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:

Examine the following commands:

Identify two correct sequences of commands to perform a recovery and make the data available.

A. 1,2,10,5,6,9 B. 10,3,4,8,9 C. 1,2,5,6,7,8 D. 1,2,3,4,7,8

Discussion 0

Correct Answer: A,C Vote an answer

Question 15

Which two statements are true concerning Information Lifecycle Management (ILM) policies?

A. Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy. B. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level. C. Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times. D. Segment-level policies override row-level policies. E. ILM policy functions return a Boolean value.

Discussion 0

Correct Answer: B,E Vote an answer