Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 11:

  You want to distribute a set of structured data to your customers who can integrate this data into their existing databases irrespective of the platform.

  Which method provides the fastest way of achieving this?

  A. using the DBVERIFY utility
  B. using direct-path INSERT SQL statements
  C. using SQL*Loader
  D. using RMAN transportable tablespace operation
  D. using RMAN transportable tablespace operation

• Question 12:

  The DEFERRED_SEGMENT_CREATION parameter is set to TRUE in your database instance. You execute the following command to create a table:

  

  Which two statements are true? (Choose two.)

  A. The table is created without a segment because the storage clause is missing.
  B. A segment is allocated when the first row is inserted in the table.
  C. A segment is allocated when an index is created for any column in the table.
  D. The table is created and extents are immediately allocated as per the default storage defined for its tablespace.
  E. A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.
  B. A segment is allocated when the first row is inserted in the table.
  E. A segment is allocated for the table if the ALTER TABLE... ALLOCATE EXTENT command is issued.

• Question 13:

  Which two statements are true about using SQL*Loader? (Choose two.)

  A. It can load data from external files by using the direct path only.
  B. It can load data into multiple tables using the same load statement.
  C. It can load data into only one table at a time.
  D. It can generate unique sequential key values in specified columns.
  E. It can load data from external files by using the conventional path only.
  A. It can load data from external files by using the direct path only.
  C. It can load data into only one table at a time.

• Question 14:

  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
  D. 3 and 1

• Question 15:

  Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

  A. PMON
  B. SMON
  C. MMNL
  D. MMAN
  E. MMON
  D. MMAN

• Question 16:

  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.
  A. by granting a secure application role to the users

  ---

  You can design your applications to automatically grant a role to the user who is trying to log in, provided the user meets criteria that you specify. To do so, you create a secure application role, which is a role that is associated with a PL/SQL

  procedure (or PL/SQL package that contains multiple procedures). The procedure validates the user: if the user fails the validation, then the user cannot log in. If the user passes the validation, then the procedure grants the user a role so that

  he or she can use the application. The user has this role only as long as he or she is logged in to the application. When the user logs out, the role is revoked.

  Incorrect:

  Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the value of the OS_AUTHENT_PREFIX parameter. Not C, not E: 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. After the specified number of failure attempts, the connection will be automatically dropped by the server process.

  Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.

  Values:

  shared

  One or more databases can use the password file. The password file can contain SYS as well as non-SYS users.

  exclusive

  The password file can be used by only one database. The password file can contain SYS as well as non-SYS users.

  none

  Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system.

  Note:

  The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility only.

• Question 17:

  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? (Choose two.)

  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.
  A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
  C. Data is never redacted for the EMP_V.SAL column.

  ---

  Note:

  *

  DBMS_REDACT.FULL completely redacts the column data.

  *

  DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.

  *

  The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.

  *

  If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.

• Question 18:

  What is the benefit of running the catctl.pl script during an upgrade of a pre-12c database to an Oracle 12c database?

  A. It provides a summary of the upgrade results.
  B. It recompiles all invalid PL/SQL and Java code.
  C. It generates a log file containing the fixes that can be made to the source database.
  D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.
  E. It generates fix-up scripts to be run on the source database before upgrade.
  D. It provides parallel upgrade options to finish the upgrade process with a reduced down time.

  ---

  References: https://docs.oracle.com/database/121/UPGRD/upgrade.htm#UPGRD52860

• Question 19:

  Which four statements are true about database instance behavior? (Choose four.)

  A. An idle instance is created when a STARTUP NOMOUNT is successful
  B. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state
  C. The consistency of redo logs and data files is checked when mounting the database
  D. Redo log files can be renamed in MOUNT state
  E. An SPFILE can be updated when connected to an idle instance
  F. Datafiles can be renamed in MOUNT state
  C. The consistency of redo logs and data files is checked when mounting the database
  D. Redo log files can be renamed in MOUNT state
  E. An SPFILE can be updated when connected to an idle instance
  F. Datafiles can be renamed in MOUNT state

• Question 20:

  In your database, the RESOURCE_LIMIT parameter is set to TRUE. You create the profile: Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)

  

  A. The CPU_PER_CALL is ignored in the user sessions because of the unlimited value of CPU_PER_CALL
  B. These users can never reuse a password
  C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
  D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.
  C. The PASSWORD_LIFE_TIME value is ignored because of the unlimited value of PASSWORD_REUSE_MAX.
  D. In each user session, the limit for LOGICAL_READS_PER_SESSION in the same as defined in the DEFAULT profile.