Oracle 1Z0-060 Free Practice Questions 2021

NEW QUESTION 1
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.

Answer: ACE

NEW QUESTION 2
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 1
• B. Only 2
• C. Only 3
• D. 3 and 1
• E. 1 and 2

Answer: D

NEW QUESTION 3
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?

• A. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
• B. Increase the database buffer cache size.
• C. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
• D. Configure Automata Shared Memory Management.
• E. Configure Automatic Memory Management-

Answer: A

NEW QUESTION 4
What are three purposes of the RMAN “FROM” clause?

• A. to support PUSH-based active database duplication
• B. to support synchronization of a standby database with the primary database in a Data environment
• C. To support PULL-based active database duplication
• D. To support file restores over the network in a Data Guard environment
• E. To support file recovery over the network in a Data Guard environment

Answer: BDE

NEW QUESTION 5
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’,
‘false’);
Which three statements are true about the effect of this command?

• A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathere
• B. Statistics collection is not done for the CUSTOMERS table when database stats are gathere
• C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
• D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
• E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

Answer: CDE

NEW QUESTION 6
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database Instance by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

NEW QUESTION 7
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.SAL column only if the SCOTT session does not have 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_V.SAL column only if the SCOTT session has 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.

Answer: AC

NEW QUESTION 8
Which three statements are true concerning the multitenant architecture?

• A. Each pluggable database (PDB) has its own set of background processes.
• B. A PDB can have a private temp tablespace.
• C. PDBs can share the sysaux tablespace.
• D. Log switches occur only at the multitenant container database (CDB) level.
• E. Different PDBs can have different default block sizes.
• F. PDBs share a common system tablespace.
• G. Instance recovery is always performed at the CDB level.

Answer: BDG

NEW QUESTION 9
On your Oracle Database, you issue the following commands to create indexes:
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id);
Which two statements are true?

• A. Only the ORD_CUSTOMER_IX1 index create
• B. Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.
• C. Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.
• D. The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.
• E. Both the indexes are created and used by the optimizer for queries on the ORDERS table.
• F. Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.

Answer: BF

NEW QUESTION 10
Which three statements are true concerning unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dose
• C. The unplugged PDB becomes a non-CD
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CD
• F. The PDB data files are automatically removed from disk.

Answer: ADE

NEW QUESTION 11
Identify three valid methods of opening, pluggable databases (PDBs).

• A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
• C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D. ALTER DATABASE PDB OPEN issued from the root
• E. ALTER DATABASE OPEN issued from that PDB
• F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
• G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Answer: AEG

NEW QUESTION 12
You are administering a database and you receive a requirement to apply the following restrictions:
1.A connection must be terminated after four unsuccessful login attempts by user.
2.A user should not be able to create more than four simultaneous sessions.
3.User session must be terminated after 15 minutes of inactivity.
4.Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

• A. by granting a secure application role to the users
• B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
• C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
• E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Answer: C

NEW QUESTION 13
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 ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: ABEG

NEW QUESTION 14
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:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

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

Answer: B

NEW QUESTION 15
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapseD.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?

• A. Increase the value of the ASM_POWER_LIMIT parameter.
• B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
• C. Specify the statement that adds the disk back to the disk group.
• D. Increase the number of ASMB processes.
• E. Increase the number of DBWR_IO_SLAVES in the ASM instance.

Answer: AC

NEW QUESTION 16
In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

• A. Decreasing PCTUSED
• B. Decreasing PCTFREE
• C. Increasing the number of DBWN process
• D. Using Automatic Segment Space Management (ASSM)
• E. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

Answer: D

NEW QUESTION 17
What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE” statement?

• A. It will create a multitenant container database (CDB) with only the root opene
• B. It will create a CDB with root opened and seed read only.
• C. It will create a CDB with root and seed opened and one PDB mounte
• D. It will create a CDB that must be plugged into an existing CD
• E. It will create a CDB with root opened and seed mounte

Answer: B

NEW QUESTION 18
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.

• A. Missing or stale histogram statistics
• B. Undersized shared pool
• C. High clustering factor for the indexes
• D. High value for the DB_FILE_MULTIBLOCK_READ_COUNT parameter
• E. Oversized buffer cache

Answer: ACD

NEW QUESTION 19
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 not running on the database node.
• 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 running on a different port.

Answer: C

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

• A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B. A single listener can service only one database instance and multiple remote client connections.
• C. Service registration with the listener is performed by the process monitor (LREG) process of each database instance.
• 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. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Answer: C