Oracle Oracle Database 1Z0-060 Questions & Answers

• Question 31:

  Examine the memory-related parameters of an Oracle database instance: Which statement is true?

  

  A. The value of the memory_target parameter cannot be changed dynamically.

  B. PGA size can grow automatically beyond 500 MB.

  C. Only the components of SGA are managed automatically.

  D. Memory is dynamically re-allocated between SGA and PGA as needed.

  Correct Answer: B

• Question 32:

  What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

  A. It is the only way to have "automatic restart in place" after instance failure.

  B. The Oracle database will be easier to upgrade in the future.

  C. The Oracle database can be created using Oracle Managed Files.

  D. The Oracle database can be created using storage managed by ASM.

  E. The Oracle database will be automatically registered as a resource in Oracle Restart.

  Correct Answer: DE

  Reference: https://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/install/gridinstss/ gridinstss.htm

• Question 33:

  Which three can be performed on a Data Pump type external table? (Choose three.)

  A. creating a public synonym for the table

  B. creating a view on the table

  C. partitioning the table

  D. performing a CREATE TABLE AS SELECT (CTAS) to populate the table

  E. creating an invisible index on the table

  F. updating the table using an UPDATE statement

  Correct Answer: DEF

• Question 34:

  DBS_IND_PARTITIONS.ORPHANED_ENTRIES contains YES for several index partitions. This is due to the use of deferred index maintenance.

  Which three methods will remove the orphaned keys? (Choose three.)

  A. using ALTER INDEX REBUILD PARTITION once for each affected local index partition

  B. using DBMS_PART.CLEANUP_GIDX once to clean up orphaned keys in all local indexes.

  C. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected global index partition

  D. using DBMS_PART.CLEANUP_CIDX once to clean up any orphaned keys in all global indexes on partitioned tables.

  E. using ALTER INDEX COALESCE PARTITION CLEANUP once for each affected local index partition

  F. using ALTER INDEX REBUILD PARTITION once for each affected global index partition

  Correct Answer: ABC

• Question 35:

  Your multitenant container database (CDB) contains two pluggable databases (PDBs).

  Which three tools can be used to add a new PDB to the CDB? (Choose three.)

  A. Enterprise Manager Cloud Control

  B. SQL Developer

  C. Database Upgrade Assistant (DBUA)

  D. Database Configuration Assistant (DBCA)

  E. Oracle Universal Installer (OUI)

  Correct Answer: ABD

• Question 36:

  Your multitenant container database (CDB) contains several pluggable databases (PDBs).

  Users C##A_ADMIN and B_ADMIN have only connect privileges.

  You create a common role C##_ROLE1 with common privileges CREATE TABLE and SELECT ANY

  TABLE.

  You then execute these commands to grant the role to users in the root container:

  SQL > GRANT C##_role1 TO c##_a_admin CONTAINER=ALL;

  Then,

  SQL> CONN sys/oracle@HR_PDB as sysdba

  SQL> GRANT c##_role1 TO b_admin CONTAINER=CURRENT;

  Which two statements are true?

  A. C##_A_ADMIN can create and select any table in the root container as well as in all current PDBs.

  B. C##_A_ADMIN can create and select any table in the root container as well as in all current and future PDBs.

  C. C##_A_ADMIN can create and select any table, and grant the C##_ROLE1 role to users in the root container.

  D. B_ADMIN can create and select any table, and grant the C##_ROLE1 role to users in HR_PDB.

  E. B_ADMIN can create and select any table in HR_PDB

  Correct Answer: CE

• Question 37:

  Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges: Which statement is true about the common user created by the command?

  

  A. The user cannot connect any database because the CONTAINER clause is missing.

  B. The user can connect only to the root database.

  C. The user can connect to the root and all PDBs.

  D. The user cannot connect to any database because the CREATE ANY SESSION privilege must be granted.

  Correct Answer: C

• Question 38:

  Which three statements are true about adaptive SQL plan management?

  A. It adds new; bettor plans automatically as fixed plans to the baseline.

  B. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.

  C. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

  D. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

  Correct Answer: BCD

• Question 39:

  You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle

  Linux with little endianness.

  You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database 10g

  database that is running on a SPARC-based Oracle Solaris system with big endianness.

  The data warehouse database has the following parameters set:

  

  The following parameters are not explicitly set:

  

  What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?

  A. Do nothing, because Automatic Memory Management will size DB_16K_CACHE_SIZE automatically

  B. Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;

  C. Do nothing, because you cannot transport a tablespace between databases with different endian formats.

  D. Do nothing, because Automatic Shared Memory Management will size DB_16K_CACHE_SIZE automatically.

  E. Set ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M and leave other parameters set to their current settings.

  Correct Answer: B

• Question 40:

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

  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