best preparation method to pass the Oracle 1Z0-060 exam, latest Oracle 1Z0-060 exam dumps
Examdemoprogram shares the latest Oracle Database 1Z0-060 exam dumps for free exam practice tests and online downloads! “Upgrade to Oracle Database 12c” 1Z0-060 exam. Ready to pass the 1Z0-060 exam please click https://www.pass4itsure.com/1z0-060.html (full exam dump)
Oracle Database 1Z0-060 Exam pdf
[Apr PDF] Free Oracle 1Z0-060 pdf dumps download from Google Drive: https://drive.google.com/open?id=1SvcOK5rpXb0776fgdN0qMoX7cKK5U-3-
[Oct PDF] Free Oracle 1Z0-060 pdf dumps download from Google Drive: https://drive.google.com/open?id=1_si1L0rzMOb60veb31fiEoVaVt319GuD
Upgrade to Oracle Database 12c | Oracle University: https://education.oracle.com/upgrade-to-oracle-database-12c/pexam_1Z0-060
Oracle Database 1Z0-060 Online Exam Practice Questions
QUESTION 1
You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements:
RANDOM redaction on the SAL and COMM columns PARTIAL redaction on the HIREDATE column FULL redaction on
the MGR column
What would you define to implement this?
A. several redaction policies, with one redaction policy for each data type defined for the table that must be redacted
B. several redaction policies, with each redaction policy specifying the redaction for table columns of that redaction type
C. one redaction policy on the table, which specifies the redaction types for all table columns that must be redacted
D. several redaction policies, with one redaction policy for each table column that must be redacted
Correct Answer: C
You can redact columns of different data types, using different redaction types, for one table or view.
QUESTION 2
Which two statements are true about variable extent size support for large ASM files?
A. The metadata used to track extents in SGA is reduced.
B. Rebalance operations are completed faster than with a fixed extent size
C. An ASM Instance automatically allocates an appropriate extent size.
D. Resync operations are completed faster when a disk comes online after being taken offline.
E. Performance improves in a stretch cluster configuration by reading from a local copy of an extent.
Correct Answer: AC
A: Variable size extents enable support for larger ASM datafiles, reduce SGA memory requirements for very large
databases (A), and improve performance for file create and open operations.
C: You don\\’t have to worry about the sizes; the ASM instance automatically allocates the appropriate extent size.
Note:
*
The contents of ASM files are stored in a disk group as a set, or collection, of data extents that are stored on individual
disks within disk groups. Each extent resides on an individual disk. Extents consist of one or more allocation units (AU).
To accommodate increasingly larger files, ASM uses variable size extents.
*
The size of the extent map that defines a file can be smaller by a factor of 8 and 64 depending on the file size. The
initial extent size is equal to the allocation unit size and it increases by a factor of 8 and 64 at predefined thresholds.
This feature is automatic for newly created and resized datafiles when the disk group compatibility attributes are set to
Oracle Release 11 or higher.
QUESTION 3
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3. Which two
RMAN commands may be; used to back up only the PDB1 pluggable database?
A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the root container
B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
C. BACKUP DATABASE while connected to the PDB1 container
D. BACKUP DATABASE while connected to the boot container
E. BACKUP PLUGGABLE database PDB1 while connected to PDB2
Correct Answer: AC
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
*
(A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For
example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
*
(C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a
non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command. Reference: Oracle
Database Backup and Recovery User\\’s Guide 12c, About Backup and Recovery of CDBs
QUESTION 4
You plan to migrate your database from a file system to Automatic Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task? (Choose two.)
A. RMAN CONVERT command
B. Data Pump Export and Import
C. Conventional Export and Import
D. The BACKUP AS COPY DATABASE … command of RMAN
E. DBMS_FILE_TRANSFER with transportable tablespace
Correct Answer: AD
A:
1. Get the list of all datafiles. Note: RMAN Backup of ASM Storage There is often a need to move the files from the file
system to the ASM storage and vice versa. This may come in handy when one of the file systems is corrupted by some
means and then the file may need to be moved to the other file
system.
D: Migrating a Database into ASM
*
To take advantage of Automatic Storage Management with an existing database you must migrate that database into
ASM. This migration is performed using Recovery Manager (RMAN) even if you are not using RMAN for your primary
backup and recovery strategy.
*
Example:
Back up your database files as copies to the ASM disk group.
BACKUP AS COPY INCREMENTAL LEVEL 0 DATABASE
FORMAT \\’+DISK\\’ TAG \\’ORA_ASM_MIGRATION\\’;
QUESTION 5
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set:
THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened
in read only mode?
A. You can conned as a common user by using the connect statement.
B. You can connect as a local user by using the connect statement.
C. You can connect by using easy connect.
D. You can connect by using OS authentication.
E. You can connect by using a Net Service name.
F. You can connect as a local user by using the SET CONTAINER statement.
Correct Answer: CDEF
*
The choice of threading model is dictated by the THREADED_EXECUTION initialization parameter.
THREADED_EXECUTION=FALSE : The default value causes Oracle to run using the multiprocess model.
THREADED_EXECUTION=TRUE : Oracle runs with the multithreaded model.
*
OS Authentication is not supported with the multithreaded model.
*
THREADED_EXECUTION
When this initialization parameter is set to TRUE, which enables the multithreaded Oracle model, operating system
authentication is not supported. Attempts to connect to the database using operating system authentication (for
example,
CONNECT / AS SYSDBA or CONNECT / ) when this initialization parameter is set to TRUE receive an
ORA-01031″insufficient privileges” error.
F: The new SET CONTAINER statement within a call back function:
The advantage of SET CONTAINER is that the pool does not have to create a new connection to a PDB, if there is an
exisitng connection to a different PDB. The pool can use the existing connection, and through SET CONTAINER, can
connect to the desired PDB. This can be done using:
ALTER SESSION SET CONTAINER=
This avoids the need to create a new connection from scratch.
QUESTION 6
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is
enabled? (Choose two.)
A. reduced CPU utilization
B. reduced physical I/O
C. improved Serial Execution performance
D. reduced logical I/O
E. reduced virtual memory utilization
Correct Answer: AE
QUESTION 7
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the
following command:
lsnrctl > STOP
What happens to the sessions that are presently connected to the database Instance?
A. They are able to perform only queries.
B. They are not affected and continue to function normally.
C. They are terminated and the active transactions are rolled back.
D. They are not allowed to perform any operations until the listener LISTENER is started.
Correct Answer: B
The listener is used when the connection is established. The immediate impact of stopping the listener will be that no
new session can be established from a remote host. Existing sessions are not compromised.
QUESTION 8
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.
A. SYS, SYSTEM
B. SCOTT
C. Only for successful executions
D. Only for failed executions
E. Both successful and failed executions
Correct Answer: AE
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default,
this policy is not enabled.
QUESTION 9
Examine these two statements:
Which three are true about the MRKT tablespace? (Choose three.)
A. The MRKT tablespace is created as a smallfile tablespace, because the file size is less than the minimum required
for bigfile files.
B. The MRKT tablespace may be dropped if it has no contents.
C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT
tablespace.
D. No more data files can be added to the tablespace.
E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT
tablespace.
Correct Answer: CDE
QUESTION 10
Which three statements are true about the use of the query result cache? (Choose three.)
A. Results obtained from a query rewrite to a materialized view may be stored in the query result cache.
B. Stale results may still be obtained from the query result cache, if the query session\\’s query_rewrite_integrity
parameter is set to stale_tolerated.
C. Results obtained from a join between a table and a view may be stored in the query result cache.
D. Results from distributed queries are never stored in the query result cache.
E. Results may not be obtained from the query result cache, when the query_rewrite_enabled parameter is set to false.
F. Results from remote queries may sometimes be stored in the query result cache.
Correct Answer: ABE
QUESTION 11
A senior DBA asked you to execute the following command to improve performance:
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What
could be a reason for this recommendation?
A. The keep pool is not configured.
B. Automatic Workarea Management is not configured.
C. Automatic Shared Memory Management is not enabled.
D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
Correct Answer: D
The most of the rows in SUBSCRIBE_LOG table are accessed once a week.
QUESTION 12
Which two statements are true about Oracle Direct Network File System (NFS)? (Choose two.)
A. Direct NFS can use only the oranfstab configuration file located in $ORACLE_HOME/dbs/.
B. It utilizes the operating system file system cache.
C. Oracle Database requires mount points to be mounted by the kernel NFS system even when served through the
Direct NFS client.
D. 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.
E. Direct NFS performs load balancing across all specified paths. If a specified path fails, Direct NFS reissues I/O
commands over any remaining paths.
Correct Answer: CE
QUESTION 13
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two
statements are true about the password file?
A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B. It contains username and passwords of database users who are members of the OSOPER operating system group.
C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
Correct Answer: AD
*
You can create a password file using the password file creation utility, ORAPWD.
*
Adding Users to a Password File When you grant SYSDBA or SYSOPER privileges to a user, that user\\’s name and
privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if
the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing),
Oracle Database issues an error if you attempt to grant these privileges.
A user\\’s name remains in the password file only as long as that user has at least one of these two privileges. If you
revoke both of these privileges, Oracle Database removes the user from the password file.
*
The syntax of the ORAPWD command is as follows:
ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]
*
IGNORECASE
If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that
the user supplies during login with the password in the password file.
Share Pass4itsure discount codes for free
About Pass4itsure!
Pass4itsure offers the latest exam practice questions and answers free of charge! Update all exam questions throughout the year, with a number of professional exam experts! To make sure it works! Maximum pass rate, best value for money! It helps you pass the exam easily on your first attempt.
Summarize:
How do I pass the Oracle Database 1Z0-060 exam? You need to be prepared for it!
You need the latest and most effective learning materials and proper practices to pass the 1Z0-060 exam.
“Oracle Database 12c Administrator Certified Professional – upgrade from 7.3, 8, 8i, 9i, 10g, 11g DBA OCP Certification”. Pass4itsure offers you the latest exam materials! You can use the materials to prepare to help you achieve excellent results!
This maybe you’re interested
https://www.examdemoprogram.com/real-Oracle-200-155-dumps-dcict-exam/