2021 Verified 1Z0-060 dumps Q&As on your Oracle Database Exam Questions Certain Success!
1Z0-060 Exam Dumps - 100% Marks In 1Z0-060 Exam!
The Oracle 1Z0-060 exam validates your expertise when it comes to Oracle Database.
As you are getting ready for the Oracle 1Z0-060 certification exam, it is vital that you understand all that is entailed in this test. It is important to mention this is an exam that requires you to have more practical knowledge than theoretical concepts. The majority of those who have failed it focused their attention on cramming rather than gaining the actual skills. You should take a different perspective – be more practical.
Your journey towards earning the Oracle Certified Professional (OCP) certification begins with receiving the Oracle Certified Associate (OCA) credential. With the OCA certificate, you tell the world that you are equipped with vital skills needed to provide support for Oracle products. OCP is the benchmark of your professional career and shows that you have what it takes to implement enterprise-wide databases. Earning it begins with the single step of passing your Oracle 1Z0-060 exam. The test includes 80 questions. There will be 120 minutes to complete all of them. You have to pay 245$ for the 1Z0-060 exam.
NEW QUESTION 119
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,3,4,7,8
- B. 10,3,4,8,9
- C. 1,2,5,6,7,8
- D. 1,2,10,5,6,9
Answer: C,D
NEW QUESTION 120
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?
- A. Flush the shared pool.
- B. Re-create redaction policies that use FULL data redaction.
- C. Re-enable redaction policies that use FULL data redaction.
- D. Re-connect the sessions that access objects with redaction policies defined on them.
- E. Restart the database instance.
Answer: E
Explanation:
Explanation
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value. The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.
NEW QUESTION 121
Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.
- A. Change in the Oracle Database version
- B. Change in your network infrastructure
- C. Database and operating system upgrade
- D. Migration of database storage from non-ASM to ASM storage
- E. Change in the hardware configuration of the database server
Answer: A,C,E
Explanation:
Oracle 11g/12cmakes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change.
The database change can be as major or minor as you like, such as:
* (E)Database, operating system, or hardware upgrades.
* (A,C)Database, operating system, or hardware configuration changes.
*Database initialization parameter changes.
*Schema changes, such as adding indexes or materialized views.
*Refreshing optimizer statistics.
*Creating or changing SQL profiles.
NEW QUESTION 122
Your multitenant container database (CDB) contains several pluggable databases (PDBs).
A common user C##A_ADMIN, is created with connect privileges.
You execute this command from the root container:
SQL> GRANT create tablespace to C##A_ADMIN;
Which statement is true?
- A. The command fails because the CONTAINER=ALLclause is not used.
- B. The command executes successfully, enabling the C##A_ADMINuser to create a tablespace only in the root container.
- C. The command executes successfully, enabling the C##A_ADMINuser to create tablespaces in the root container as well as in the PDBs.
- D. The command fails because the CONTAINER=CURRENTclause is not used.
Answer: C
NEW QUESTION 123
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
- A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
- B. The C # # A_ADMIN user can perform wallet operations.
- C. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
- D. The C# # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- E. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
Answer: C,D,E
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database Incorrect:
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
NEW QUESTION 124
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=TRUE;
Which statement is true?
- A. Only DDL commands that resulted in the creation of new segments are logged.
- B. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
- C. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
- D. All DDL commands are logged in the alert log file.
- E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Answer: B
Explanation:
Explanation
The log files are created only in $ADR_HOME/log
in alert log only alter system is catched.Sun Mar 30 23:30:04 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:32:41 2014ALTER SYSTEM SET enable_ddl_logging=TRUE SCOPE=BOTH;Sun Mar 30 23:39:35 2014ALTER SYSTEM SET enable_ddl_logging=FALSE SCOPE=BOTH;[oracle@ovs trace]$ only in diag/rdbms/.../../log/ two files are capturing this. The xml file is capturing full details and text file having only the commands.
[oracle@ovs log]$ pwd/oraclebase/diag/rdbms/ora12c1/ora12c1/log[oracle@ovs log]$ cat ddl/* create table testing2(a number) create table testing3( aa number)
[oracle@ovs log]$ cat ddl_ora12c1.logSun Mar 30 23:33:26 2014diag_adl:create table testing2(a number)diag_adl:create table testing3( aa number) References:
NEW QUESTION 125
Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose three.)
- A. Reduced CPU utilization
- B. Reduced physical I/O
- C. Reduced virtual memory utilization
- D. Improved Serial Execution performance
- E. Reduced logical I/O
- F. Improved parallel Execution performance
Answer: A,C,F
Explanation:
Explanation
* Multiprocess and Multithreaded Oracle Database Systems
Multiprocess Oracle Database (also called multiuser Oracle Database) uses several processes to run different parts of the Oracle Database code and additional Oracle processes for the users-either one process for each connected user or one or more processes shared by multiple users. Most databases are multiuser because a primary advantage of a database is managing data needed by multiple users simultaneously.
Each process in a database instance performs a specific job. By dividing the work of the database and applications into several processes, multiple users and applications can connect to an instance simultaneously while the system gives good performance.
* In previous releases, Oracle processes did not run as threads on UNIX and Linux systems. Starting in Oracle Database 12c, the multithreaded Oracle Database model enables Oracle processes to execute as operating system threads in separate address spaces.
NEW QUESTION 126
Which two statements are true when row archival management is enabled?
- A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- B. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
- C. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- D. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
- E. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
Answer: A,D
Explanation:
A: Below we see a case where we set the row archival visibility parameter to "all"
thereby allowing us to see all of the rows that have been logically deleted:
alter session set row archival visibility = all;
We can then turn-on row invisibility back on by changing row archival visibility = "active":
alter session set row archival visibility = all;
B: To use ora_archive_state as an alternative to deleting rows, you need the following settings and parameters:
1.Create the table with the row archival clause
2.Now that the table is marked as row archival, you have two methods for removing rows, a permanent solution with the standard delete DML, plus the new syntax where you set ora_archive_state to a non-zero value:
update mytab set ora_archive_state=2 where col2='FRED';
3.To make "invisible rows" visible again, you simply set the rows ora_archive_state to zero:
create table mytab (col1 number, col2 char(200)) row archival; update mytab set ora_archive_state=0 where col2='FRED';
Note:
* Starting in Oracle 12c, Oracle provides a new feature that allow you to "logically delete" a row in a table without physically removing the row. This effectively makes deleted rows "invisible" to all SQL and DML, but they can be revealed at any time, providing a sort of "instant" rollback method.
To use ora_archive_state as an alternative to deleting rows.
NEW QUESTION 127
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
- A. Database replay
- B. SQL Tuning Advisor
- C. Automatic Workload Repository compare reports
- D. SQL Access Advisor
- E. SQL Performance Analyzer
Answer: E
Explanation:
You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include:
Database upgrades
Configuration changes to the operating system, hardware, or database
Database initialization parameter changes
Schema changes, such as adding new indexes or materialized views
Gathering optimizer statistics
SQL tuning actions, such as creating SQL profiles
http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT961
NEW QUESTION 128
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 SYSKM privilege to the password file? (Choose two.)
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
- B. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
- C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
- D. Re-create the password file in the Oracle Database 12c format.
- E. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
Answer: C,E
Explanation:
Explanation
* orapwd
/ You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges
NEW QUESTION 129
Which two statements are true concerning the Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?
- A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
- B. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
- C. If a PDB plan is enabled for a pluggable database, then resources are allocated toconsumergroups across all PDBs in the CDB.
- D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
- E. In a PDB plan, subplans may be used with up to eight consumer groups.
Answer: A,B,D
Explanation:
A:Setting a PDB resource plan is optional. If not specified, allsessions within the PDB are treated equally.
* In a non-CDB database, workloads within a databaseare managed with resource plans. In a PDB, workloads are also managed with resourceplans, also called PDB resource plans. The functionality is similar except for the followingdifferences: /Non-CDBDatabase Multi-level resource plans Up to 32 consumer groups Subplans /PDBDatabase Single-level resource plansonly Up to 8 consumer groups (not B)No subplans
IncorrectNot C
NEW QUESTION 130
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
- A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- B. Setting the target tablespace to read-only
- C. Setting the target tablespace offline
- D. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- E. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Answer: B,E
Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
NEW QUESTION 131
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONALstatement?
- A. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
- B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
- C. The statement results in an error because there are open PDBs.
- D. The shutdown proceeds immediately. The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
* SHUTDOWN [ABORT | IMMEDIATE | NORMAL | TRANSACTIONAL [LOCAL]]
Shuts down a currently running Oracle Database instance, optionally closing and dismounting a database.
If the current database is a pluggable database, only the pluggable database is closed. The consolidated instance continues to run.
Shutdown commands that wait for current calls to complete or users to disconnect such as SHUTDOWN NORMAL and SHUTDOWN TRANSACTIONAL have a time limit that the SHUTDOWN command will wait.
If all events blocking the shutdown have not occurred within the time limit, the shutdown command cancels with the following message:
ORA-01013: user requested cancel of current operation
* If logged into a CDB, shutdown closes the CDB instance.
To shutdown a CDB or non CDB, you must be connected to the CDB or non CDB instance that you want to close, and then enter
SHUTDOWN
Database closed.
Database dismounted.
Oracle instance shut down.
To shutdown a PDB, you must log into the PDB to issue the SHUTDOWN command.
SHUTDOWN
Pluggable Database closed.
Note:
* Prerequisites for PDB Shutdown
When the current container is a pluggable database (PDB), the SHUTDOWN command can only be used if:
The current user has SYSDBA, SYSOPER, SYSBACKUP, or SYSDG system privilege.
The privilege is either commonly granted or locally granted in the PDB.
The current user exercises the privilege using AS SYSDBA, AS SYSOPER, AS SYSBACKUP, or AS SYSDG at connect time.
To close a PDB, the PDB must be open.
NEW QUESTION 132
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE (`08/20/12' , `MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
- A. Only 3
- B. 1 and 2
- C. Only 2
- D. 3 and 1
- E. Only 1
Answer: D
Explanation:
http://www.oracle-base.com/articles/12c/multitentant-flashback-of-container-database-12cr1.php
NEW QUESTION 133
Which two are prerequisites for performing a flashback transaction?
- A. Flashback Database must be enabled.
- B. Recycle bin must be enabled for the database.
- C. Block change tracking must be enabled tor the database.
- D. Supplemental logging must be enabled.
- E. Undo retention guarantee for the database must be configured.
- F. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.
Answer: D,F
Explanation:
Configuring Your Database for Flashback Transaction
http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_flashback.htm#BJFHBGGE
NEW QUESTION 134
In which two scenarios do you use SQL* Loader to load data?
- A. Use transparent parallel processing without having to split the external data first.
- B. Transform the data while it is being loaded into the database.
- C. Generate unique sequential key values in specified columns.
- D. Load data into multiple tables during the same load statement.
Answer: B,C
Explanation:
You can use SQL*Loader to do the following:
/ (A) Manipulate the data before loading it, using SQL functions.
/ (D) Generate unique sequential key values in specified columns.
etc:
/ Load data into multiple tables during the same load session.
/ Load data across a network. This means that you can run the SQL*Loader client on a different
system from the one that is running the SQL*Loader server.
/ Load data from multiple datafiles during the same load session.
/Specify the character set of the data.
/ Selectively load data (you can load records based on the records' values).
/Use the operating system's file system to access the datafiles.
/ Load data from disk, tape, or named pipe.
/ Generate sophisticated error reports, which greatly aid troubleshooting.
/ Load arbitrarily complex object-relational data.
/ Use secondary datafiles for loading LOBs and collections.
/ Use either conventional or direct path loading. While conventional path loading is very flexible,
direct path loading provides superior loading performance.
Note:
* SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
NEW QUESTION 135
......
Pass Your 1Z0-060 Exam Easily With 100% Exam Passing Guarantee: https://www.vce4plus.com/Oracle/1Z0-060-valid-vce-dumps.html