Oracle Oracle Certifications 1Z0-060 Questions & Answers

• Question 131:

  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

  Correct Answer: AEG

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

  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.

  Correct Answer: AC

  ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.

  Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations. References: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10070

• Question 133:

  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.

  Correct Answer: C

  SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication attempts that can be made by a client on a connection to the server process. These login attempts can be for multiple user accounts in the same connection. After the specified number of failure attempts, the connection will be automatically dropped by the server process.

  References: https://docs.oracle.com/database/121/REFRN/GUID-DEC2A3B2-F49B-499E-A3CFD097F3A5BA83.htm#REFRN10274

• Question 134:

  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. It results in an error because these parameter settings are invalid.

  B. One 64G flash cache file will be used.

  C. Two 64G flash cache files will be used.

  D. Two 32G flash cache files will be used.

  Correct Answer: A

• Question 135:

  You executed this command to create a password file:

  $ orapwd file = orapworcl entries = 10 ignorecase = N

  Which two statements are true about the password file?

  A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.

  B. It contains username and passwords of database users who are members of the OSOPER operating system group.

  C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.

  D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

  E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

  Correct Answer: AD

  *

  You can create a password file using the password file creation utility, ORAPWD.

  *

  Adding Users to a Password File

  When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.

  A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.

  *

  The syntax of the ORAPWD command is as follows:

  ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]

  *

  IGNORECASE If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.

• Question 136:

  You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.

  All databases of all versions use Automatic Storage Management (ASM).

  Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?

  A. The ASM compatibility attribute controls the format of the disk group metadata.

  B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.

  C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.

  D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.

  E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

  Correct Answer: ABD

  A, D: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.

  B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS. For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between

  10.1 and 11.1 inclusively.

  Incorrect Answers:

  E: /The value for the disk group COMPATIBLE.ADVM attribute determines whether the disk group can contain Oracle ASM volumes. The value must be set to 11.2 or higher. Before setting this attribute, the COMPATIBLE.ASM value must be 11.2 or higher. Also, the Oracle ADVM volume drivers must be loaded in the supported environment.

  / You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an Oracle ACFS file system.

  The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the disk group.

  Note:

  * The disk group attributes that determine compatibility are COMPATIBLE.ASM, COMPATIBLE.RDBMS. and COMPATIBLE.ADVM. The COMPATIBLE.ASM and COMPATIBLE.RDBMS attribute settings determine the minimum Oracle Database software version numbers that a system can use for Oracle ASM and the database instance types respectively. For example, if the Oracle ASM compatibility setting is 11.2, and RDBMS compatibility is set to 11.1, then the Oracle ASM software version must be at least 11.2, and the Oracle Database client software version must be at least 11.1. The COMPATIBLE.ADVM attribute determines whether the Oracle ASM Dynamic Volume Manager feature can create a volume in a disk group.

• Question 137:

  You execute the following PL/SQL:

  

  Which two statements are true?

  A. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

  B. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

  C. FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.

  D. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

  Correct Answer: AD

  DBMS_FGA.ADD_POLICY(object_schema => `hr',object_name => `emp',policy_name =>

  `chk_hr_emp',audit_condition => `dept = "SALES" `,audit_column => `salary'statement_types =>

  `insert,update,delete,select'); Default value for statement_types is SELECT

  Setting audit_trail to DBMS_FGA.DB sends the audit trail to the SYS.FGA_LOG$ table in the database

  and omits SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.DB+EXTENDED sends the audit trail to the SYS.FGA_LOG$ table in the

  database and includes SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.XML writes the audit trail in XML files sent to the operating system and

  omits SQL Text and SQL Bind.

  Setting audit_trail to DBMS_FGA.XML+EXTENDED writes the audit trail in XML files sent to the operating

  system and includes SQL Text and SQL Bind.

  Default value fo audit_trail parameter in DBMS_FGA.ADD_POLICY is DB+EXTENDED

• Question 138:

  You execute the following commands to audit database activities:

  

  Which statement is true about the audit record that generated when auditing after instance restarts?

  A. One audit record is created for every successful execution of a SELECT, INSERT or DELETE command on a table, and contains the SQL text for the SQL Statements.

  B. One audit record is created for every successful execution of a SELECT, INSERT or DELETE command, and contains the execution plan for the SQL statements.

  C. One audit record is created for the whole session if JOHN successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

  D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

  E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.

  Correct Answer: A

• Question 139:

  Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER by issuing the following command:

  lsnrctl > STOP

  What happens to the sessions that are presently connected to the database Instance?

  A. They are able to perform only queries.

  B. They are not affected and continue to function normally.

  C. They are terminated and the active transactions are rolled back.

  D. They are not allowed to perform any operations until the listener LISTENER is started.

  Correct Answer: B

  The listener is used when the connection is established. The immediate impact of stopping the listener will be that no new session can be established from a remote host. Existing sessions are not compromised.

• Question 140:

  Which three statements are true about using flashback database in a multitenant container database (CDB)?

  A. The root container can be flashed back without flashing back the pluggable databases (PDBs).

  B. To enable flashback database, the CDB must be mounted.

  C. Individual PDBs can be flashed back without flashing back the entire CDB.

  D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.

  E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

  Correct Answer: BDE