Get New 2022 Valid Practice To your 1Z0-060 Exam (Updated 205 Questions)

Oracle Database 1Z0-060 Exam Practice Test Questions Dumps Bundle!

NEW QUESTION 56
Which two statements are true regarding constraints?

• A. A foreign key cannot contain null values.
• B. A column with the unique constraint can contain null values.
• C. A constraint is enforced only for the insert operation on a table.
• D. A constraint can be disabled even if the constraint column contains data.
• E. All constraints can be defined at the column level as well as the table level.

Answer: B,D

 

NEW QUESTION 57
Which three are true about the large pool for an Oracle database instance that supports shared server connections? (Choose three.)

• A. Contains a cursor area for storing runtime information about cursors
• B. Contains a hash area performing hash joins of tables
• C. Allocates memory for RMAN backup and restore operations
• D. Contains stack space
• E. Allocates memory for shared and private SQL areas

Answer: A,C,E

Explanation:
Explanation
The large pool can provide large memory allocations for the following:
/ (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)
/Message buffers used in the parallel execution of statements
/ (A) Buffers for Recovery Manager (RMAN) I/O slaves
Note:
* large pool
Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
* Oracle XA
An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.
* UGA
User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.
* Configuring the Large Pool
Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:
* Shared server
In a shared server architecture, the session memory for each client process is included in the shared pool.
* Parallel query
Parallel query uses shared pool memory to cache parallel execution message buffers.
* Recovery Manager
Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations.
For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.

 

NEW QUESTION 58
Which statement is true about Oracle Net Listener?

• A. Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
• B. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• C. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.
• D. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E. A single listener can service only one database instance and multiple remote client connections.

Answer: A

Explanation:
Supported services, that is, the services to which the listener forwards client
requests, can be configured in the listener.ora file or this information can be dynamically registered
with the listener. This dynamic registration feature is called service registration. The registration is
performed by the PMON process-an instance background process-of each database instance
that has the necessary configuration in the database initialization parameter file. Dynamic service
registration does not require any configuration in the listener.ora file.
Incorrect:
Not B: Service registration reduces the need for the SID_LIST_listener_name parameter setting,
which specifies information about the databases served by the listener, in the listener.ora file.
Note:
*Oracle Net Listener is a separate process that runs on the database server computer. It receives incoming client connection requests and manages the traffic of these requests to the database server.
*A remote listener is a listener residing on one computer that redirects connections to a database instance on another computer. Remote listeners are typically used in an Oracle Real Application Clusters (Oracle RAC) environment. You can configure registration to remote listeners, such as in the case of Oracle RAC, for dedicated server or shared server environments.

 

NEW QUESTION 59
In your multitenant container database (CDB) that contains some pluggable databases (PDBs), you execute the following commands in the root container:

Which two statements are true? (Choose two.)

• A. The C##ROLE1 role is created in the root database and all the PDBs.
• B. The statement for granting the role to the user fails because the CONTAINER clause is not used.
• C. The C##ROLE1 role is created only in the root database because the CONTAINER clause is not used.
• D. Privileges in the role are granted to the C##A_ADMIN user in the root database and all the PDBs.
• E. Privileges in the role are granted to the C##A_ADMIN user only in the root database.

Answer: A,E

Explanation:
Explanation
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause
/ CONTAINER = ALL
Creates a common role.
/ CONTAINER = CURRENT
Creates a local role in the current PDB.

 

NEW QUESTION 60
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = '/dev/flash_device_1' , '/dev/flash_device_2'
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?

• A. One 64G flash cache file will be used.
• B. Two 64G flash cache files will be used.
• C. It results in an error because these parameter settings are invalid.
• D. Two 32G flash cache files will be used.

Answer: A

 

NEW QUESTION 61
A new report process containing a complex query is written, with high impact on the database.
You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.
What should you do to accomplish this task?

• A. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_ MONITOR function to view the report.
• B. Enable SQL trace for the query.
• C. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
• D. Execute the query and view Active Session History (ASH) for information about the query.

Answer: A

Explanation:
The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific SQL statement.
Incorrect:
Not A: Not interested in session statistics, only in statistics for the particular SQL query.
Not B: We are interested in statistics, not tracing.
Not D:SET_SESSION_LONGOPS Procedure
This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to indicate the on-going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup.
Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.

 

NEW QUESTION 62
Examine the structure of the customers table:

CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result?

• A. Right outer-join with self-join
• B. Subquery
• C. Full outer-join with self-join
• D. Left outer-join with self-join
• E. Self-join

Answer: B,E

 

NEW QUESTION 63
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?

• A. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• B. When a database instance is started by using the SRVCTLutility and listener startup fails, the instance is still started.
• C. When you start an instance on a host with SQL *Plus, dependent listeners and ASM disk groups are automatically started.
• D. When you create a database service by modifying the SERVICE_NAMESinitialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B

Explanation:
Explanation/Reference:
Explanation:
About Startup Dependencies
Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first.
Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.
References: http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710

 

NEW QUESTION 64
The following parameters are set for your Oracle 12c database instance:

You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASKfunction.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASKfunction.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASKfunction.
Identify the correct sequence of steps:

• A. 2, 4, 5
• B. 2, 1, 4, 3, 5
• C. 1, 2, 4, 5
• D. 1, 2, 3, 4, 5

Answer: B

Explanation:
Explanation/Reference:
Explanation:
* Evolving SQL Plan Baselines

2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
This function creates an advisor task to prepare the plan evolution of one or more plans for a specified SQL statement. The input parameters can be a SQL handle, plan name or a list of plan names, time limit, task name, and description.
1. Set the evolve task parameters.
SET_EVOLVE_TASK_PARAMETER
This function updates the value of an evolve task parameter. In this release, the only valid parameter is TIME_LIMIT.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
This function executes an evolution task. The input parameters can be the task name, execution name, and execution description. If not specified, the advisor generates the name, which is returned by the function.
3: IMPLEMENT_EVOLVE_TASK
This function implements all recommendations for an evolve task. Essentially, this function is equivalent to using ACCEPT_SQL_PLAN_BASELINE for all recommended plans. Input parameters include task name, plan name, owner name, and execution name.
5. Report the task outcome by using the DBMS_SPM_EVOLVE_TASK function.
This function displays the results of an evolve task as a CLOB. Input parameters include the task name and section of the report to include.

 

NEW QUESTION 65
Examine the parameter for your database instance:

You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:

Identify the reason why the optimizer chose different execution plans.

• A. The optimizer chose different plan because extended statistics were created for the columns used.
• B. The optimizer used re-optimization cardinality feedback for the query.
• C. The optimizer used a dynamic plan for the query.
• D. The optimizer chose different plans because automatic dynamic sampling was enabled.

Answer: D

Explanation:
Explanation/Reference:
Explanation:
* optimizer_dynamic_sampling
OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.
Range of values0 to 11

 

NEW QUESTION 66
Examine the commands executed to monitor database operations:
$> conn sys oracle/oracle@prod as sysdba
SQL > VAR eid NUMBER
SQL > EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION ('batch_job' , FORCED_TRACKING => 'Y');
Which two statements are true?

• A. Only DML and DDL statements will be monitored for the session.
• B. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
• C. Database operations will be monitored only when they consume a significant amount of resource.
• D. All subsequent statements in the session will be treated as one database operation and will be monitored.
• E. Database operations for all sessions will be monitored.

Answer: B,D

Explanation:
C:Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization
parameter to DIAGNOSTIC+TUNING (default) enables monitoring of database operations.
Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
*The DBMS_SQL_MONITOR package provides information about Real-time SQL
Monitoring and Real-time Database Operation Monitoring.
*(not B)BEGIN_OPERATION Function
starts a composite database operation in the current session.
/(E)FORCE_TRACKING - forces the composite database operation to be tracked when the
operation starts. You can also use the string variable 'Y'.
/ (not A)NO_FORCE_TRACKING - the operation will be tracked only when it has
consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.

 

NEW QUESTION 67
You upgraded yourdatabase frompre-12cto a multitenantcontainer database (CDB) containingpluggable 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?

• A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument 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: B,E

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
Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.

 

NEW QUESTION 68
You created an encrypted tablespace:

You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEEStable in the SECURESPACEtablespace with the SALToption on the EMPLOYEEcolumn.
Which is true about the result?

• A. It creates the table successfully but does not encrypt any inserted data in the EMPNAMEcolumn because the wallet must be opened to encrypt columns with SALT.
• B. It generates an error when creating the table because the wallet is closed.
• C. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
• D. It creates the table successfully, and encrypts any inserted data in the EMPNAMEcolumn because the wallet needs to be open only for tablespace creation.

Answer: B

 

NEW QUESTION 69
Which three statements are true about Oracle Data Pump export and import operations?

• A. You can detach from a data pump export job and reattach later.
• B. You can detach from a data pump import job and reattach later.
• C. Data pump uses parallel execution server processes to implement parallel import.
• D. The master table is the last object to be exported by the data pump.
• E. Data pump import requires the import file to be in a directory owned by the oracle owner.

Answer: A,C,D

Explanation:
B: Data Pump can employ multiple worker processes, running in parallel, to increase job performance.
D: For export jobs, the master table records the location of database objects within a dump file set.
/ Export builds and maintains the master table for the duration of the job. At the end of an export
job, the content of the master table is written to a file in the dump file set.
/ For import jobs, the master table is loaded from the dump file set and is used to control the
sequence of operations for locating objects that need to be imported into the target database.

 

NEW QUESTION 70
In your multitenant container database (CDB) containing pluggable databases (PDB), users complain about performance degradation.
How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?

• A. It collects data from SGA, analyzes it, and provides a report.
• B. It collects data from SGA and compares it with the latest snapshot.
• C. It collects data from both SGA and PGA, analyzes it, and provides a report.
• D. It collects data from SGA and compares it with a preserved snapshot.

Answer: A

Explanation:
Note: *The multitenant architecture enables an Oracle database to function as a multitenant container database (CDB) that includes zero, one, or many customer-created pluggable databases (PDBs). A PDB is a portable collection of schemas, schema objects, and nonschema objects that appears to an Oracle Net client as a non-CDB. All Oracle databases before Oracle Database 12c were non-CDBs. *The System Global Area (SGA) is a group of shared memory areas that are dedicated to an Oracle "instance" (an instance is your database programs and RAM).
*The PGA (Program or Process Global Area) is a memory area (RAM) that stores data and control information for a single process.

 

NEW QUESTION 71
Which two are true concerning a multitenant container database with three pluggable database?

• A. The pluggable databases increase patching time.
• B. The pluggable databases reduce administration effort.
• C. Pluggable databases are only used for database consolidation.
• D. The pluggable databases are patched together.
• E. All administration tasks must be done to a specific pluggable database.

Answer: B,C

Explanation:
The benefits of Oracle Multitenant are brought by implementing a pure deployment choice. The following list calls out the most compelling examples.
*High consolidation density. (E)
The many pluggable databases in a single multitenant container database share its memory and
background processes, letting you operate many more pluggable databases on a particular
platform than you can single databases that use the old architecture. This is the same benefit that
schema-based consolidation brings.
*Rapid provisioning and cloning using SQL.
*New paradigms for rapid patching and upgrades. (D, not B)
The investment of time and effort to patch one multitenant container database results in patching
all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug
to a multitenant container database at a different Oracle Database software version.
*(C, not A) Manage many databases as one.
By consolidating existing databases as pluggable databases, administrators can manage many databases as one. For example, tasks like backup and disaster recovery are performed at the multitenant container database level.
*Dynamic between pluggable database resource management. In Oracle Database 12c,
Resource Manager is extended with specific functionality to control the competition for resources
between the pluggable databases within a multitenant container database.
Note:
*Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps
customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is
supported by a new architecture that allows a multitenant container database to hold many
pluggable databases. And it fully complements other options, including Oracle Real Application
Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no
change, as a pluggable database; and no changes are needed in the other tiers of the application.
Reference: 12c Oracle Multitenant

 

NEW QUESTION 72
In your Database, theTBS PERCENT USEDparameter 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 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
• B. Setting the target tablespace to read-only
• C. 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
• D. Setting the target tablespace offline
• E. 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

Answer: C,D

Explanation:
C: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 ofTBS_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.
D:Offline Archive (optional)
The offline archive storage tier is an optional tier because it is only used when there is a requirement to remove data from the database and store it in some other format, such as XML on tape.

 

NEW QUESTION 73
The tnsnames.ora file has an entry for the service alias ORCL as follows: The TNS ping command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:

SQL > CONNECT scott/tiger@orcl
What could be the reason for this?

• A. The listener is running on a different port.
• B. The TNS_ADMIN environment variable is set to the wrong value.
• C. The orcl.oracle.com database service is not registered with the listener.
• D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
• E. The listener is not running on the database node.

Answer: C

Explanation:
Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.

 

NEW QUESTION 74
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 75
......

Fully Updated Dumps PDF - Latest 1Z0-060 Exam Questions and Answers: https://prepaway.dumptorrent.com/1Z0-060-braindumps-torrent.html