Oracle 1Z0-060 Online Practice Questions and Exam Preparation

Oracle 1Z0-060 Online Questions & Answers

• Question 81:

  You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

  Which statement is true?

  A. The ORACLE_BASE base parameter is not set.
  B. The installation is being performed by the root user.
  C. The operating system group that is specified should have the root user as its member.
  D. The operating system group that is specified must have permission to write to the inventory directory.
  D. The operating system group that is specified must have permission to write to the inventory directory.

  ---

  Note:

  Providing a UNIX Group Name

  If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.

  You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.

  Only users who belong to this group are able to install or deinstall software on this machine.

• Question 82:

  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 # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
  C. The C # # A_ADMIN user can perform wallet operations.
  D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
  E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
  B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
  D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
  E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

  ---

  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 Answers:

  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.

• Question 83:

  Which two statements are true concerning Information Lifecycle Management (ILM) policies?

  A. Multiple ILM policies may exist for the same segment and any compression levels may be specified for any policy.
  B. Segment-level policies override row-level policies.
  C. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.
  D. Multiple ILM policies may exist for the same segment but greater compression levels must be specified at greater elapsed times.
  E. ILM policy functions return a Boolean value.
  C. Multiple ILM policies may exist for the same table, if the action is compression and the scope is at the row level.
  E. ILM policy functions return a Boolean value.

• Question 84:

  You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.

  Which method or feature should you use?

  A. Compare Period ADDM report
  B. AWR Compare Period report
  C. Active Session History (ASH) report
  D. Taking a new snapshot and comparing it with a preserved snapshot
  A. Compare Period ADDM report

• Question 85:

  In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:

  SQL > REVOKE create table FROM C # # A_ADMIN;

  What is the result?

  A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
  B. It fails and reports an error because the CONTAINER=ALL clause is not used.
  C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
  D. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
  E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
  B. It fails and reports an error because the CONTAINER=ALL clause is not used.

  ---

  SQL> create user c##admin identified by stipsi container=all;

  User created.

  SQL> grant create table to c##admin container=all;

  Grant succeeded.

  SQL> revoke create table from c##admin;

  revoke create table from c##admin

  *

  ERROR at line 1:

  ORA-65092: system privilege granted with a different scope to 'C##ADMIN'

• Question 86:

  An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

  

  You want to balance the memory between the System Global Area (SGA) components depending on the workload. Which option would solve this problem?

  A. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M
  B. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
  C. setting the SGA_TARGET parameter to 300M
  D. setting the SGA_MAX_SIZE parameter to 400M
  C. setting the SGA_TARGET parameter to 300M

• Question 87:

  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.
  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.

  ---

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

• Question 88:

  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
  A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
  E. ALTER DATABASE OPEN issued from that PDB
  G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

  ---

  E: You can perform all ALTER PLUGGABLE DATABASE tasks by connecting to a PDB and running the corresponding ALTER DATABASE statement. This functionality is provided to maintain backward compatibility for applications that have been migrated to a CDB environment.

  A, G: When you issue an ALTER PLUGGABLE DATABASE OPEN statement, READ WRITE is the default unless a PDB being opened belongs to a CDB that is used as a physical standby database, in which case READ ONLY is the default.

  You can specify which PDBs to modify in the following ways:

  List one or more PDBs.

  Specify ALL to modify all of the PDBs.

  Specify ALL EXCEPT to modify all of the PDBs, except for the PDBs listed.

• Question 89:

  The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup. (Choose four.)

  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;
  A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
  B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
  E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
  G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

• Question 90:

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

  ---

  Reference: https://docs.oracle.com/cd/B12037_01/server.101/b10825/dp_api.htm