[2022] Use Valid New 1Z0-060 Test Notes & 1Z0-060 Valid Exam Guide [Q52-Q66]

4.5/5 - (2 votes)

[2022] Use Valid New 1Z0-060 Test Notes & 1Z0-060 Valid Exam Guide

1Z0-060 Actual Questions Answers PDF 100% Cover Real Exam Questions

More Info

For more info visit: Oracle 12c Official 1Z0-060 Exam Reference

NO.52 In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
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 procedure from inserting values into tables on which they do not have any privileges?

Create the CREATE_TEST procedure with definer’s rights.

Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

Create the CREATE_TEST procedure with invoker’s rights.

Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

NO.53 You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data?

Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.

Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.

Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.

Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.

Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

NO.54 Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)? (Choose three.)

A DBA can check specific tables with the DMU

The database to be migrated must be opened read-only.

The release of the database to be converted can be any release since 9.2.0.8.

The DMU can report columns that are too long in the converted characterset.

The DMU can report columns that are not represented in the converted characterset.

NO.55 You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

Execute FLASHBACK TABLE OCEXAM_RESULTS TO BEFORE DROP RENAME TO OCP.EXAM_RESULTS; connected as SYSTEM.

Recover the table using traditional Tablespace Point In Time Recovery.

Recover the table using Automated Tablespace Point In Time Recovery.

Recovery the table sing Database Point In Time Recovery.

Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO EXAM_RESULTS; connected as the OCP user.

NO.56 Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

Place the root container in ARHCHIVELOG mode.

Take the user data tablespace offline.

Place the root container in the nomount stage.

Ensure that HR_PDB is open.

NO.57 Which two statements are true about Oracle Direct Network File System (NFS)?

Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.

It utilizes the operating system file system cache.

Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the Direct NFS client.

The Oracle database files available on the NFS server that are served by the Direct NFS Client cannot be accessed through the operating system kernel NFS.

Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O commands over any remaining paths.

NO.58 In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

The partitions can be moved online to new tablespaces.

Global indexes must be rebuilt manually after moving the partitions.

The partitions can be compressed in the same tablespaces.

The partitions can be compressed in the new tablespaces.

Local indexes must be rebuilt manually after moving the partitions.

NO.59 You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the parameter:
DB_FLASH_CACHE_FILE=’/dev/flash_device_1′,’/dev/flash_device_2′
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?

Set DB_FLASH_CACHE_SIZE = 64G.

Set DB_FLASH_CACHE_SIZE = 64G,64G

Set DB_FLASH_CACHE_SIZE = 128G.

DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.

NO.60 Which two statements are true when row-archival management is enabled? (Choose two.)

The ORA_ARCHIVE_STATEcolumn may only be queried by users with the DBArole set.

Visibility of the ORA_ARCHIVE_STATEcolumn may only be updated by users with the DBArole set.

The ROW ARCHIVAL VISIBILITYsession parameter defaults to active rows.

The ORA_ARCHIVE_STATEcolumn is only displayed if it is referenced in the column select list of a query.

The ORA_ARCHIVE_STATEcolumn is updated in an overnight maintenance job based on activity tracking.

NO.61 You created a new database using the “create database” statement without specifying the “ENABLE PLUGGABLE” clause.
What are two effects of not using the “ENABLE PLUGGABLE database” clause?

The database is created as a non-CDB and can never contain a PDB.

The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

The database is created as a non-CDB and can never be plugged into a CDB.

The database is created as a non-CDB but can be plugged into an existing CDB.

The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

NO.62 You experience performance degradation in your Oracle 12c database. To investigate, you use Active Session History (ASH) and hang analysis. You do not find any blocking sessions, but the response time is still slow.
Which method or feature would you use to diagnose the root cause and provide a quick solution?

Automatic Database Diagnostic Monitor (ADDM) in diagnostic mode

real-time ADDM

AWR Compare Period report

Memory Access Mode

NO.63 Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?

Place the root container in ARHCHIVELOG mode.

Take the user data tablespace offline.

Place the root container in the nomount stage.

Ensure that HR_PDB is open.

NO.64 In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename
VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
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 procedure from inserting values into tables on which they do not have any privileges?

Create the CREATE_TEST procedure with definer’s rights.

Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.

Create the CREATE_TEST procedure with invoker’s rights.

Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.

NO.65 Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:

What does this imply?

When you start an instance on a host with SQL*Plus, the dependent listeners and ASM disk groups are automatically started.

When a database instance is started by using the SRVCTL utility and the listener startup fails, the instance is still started.

When a database is created by using SQL*Plus, it is automatically added to the Oracle Restart configuration.

When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

NO.66 You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?

Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

Grant SYSBACKUP, SYSDG, and SYSKMprivileges to the intended users.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege and the FORCEargument set to No.

Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege, and FORCEarguments set to Yes.

Re-create the password file in the Oracle Database 12c format.

Oracle 1Z0-060 Exam Syllabus Topics:

Topic	Details
Topic 1	Detect and repair data failures with Data Recovery Advisor Perform tracking and automated data placement
Topic 2	Use Resource Manager to manage resources Change instance parameters for a CDB PDB
Topic 3	Develop and implement a security policy Use OUI, DBCA for installation and configuration
Topic 4	Implement column and tablespace encryption Basics of Multitenant Container Database (CDB)
Topic 5	Design the database layout for optimal performance Identify the benefits of the multitenant container database
Topic 6	Managing Tablespaces, Common and Local Users, Privileges and Roles Configuring and Creating CDBs and PDBs