Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 251:

  Examine these parameter settings:

  

  You execute this:

  CREATE UNDO TABLESPACE UNDOTBS2 SEGMENT SPACE MANAGEMENT AUTO;

  Which is true?

  A. It fails because there is already an active UNDO TABLESPACE for the database instance.
  B. It executes successfully and space in the UNDOTBS2 tablespace will be bitmap managed.
  C. It fails because Automatic Segment Space Management (ASSM) is not supported for an UNDO TABLESPACE.
  D. It fails because size and data file clause are missing.
  E. It executes successfully and space in the UNDOTBS2 tablespace will be freelist managed.
  B. It executes successfully and space in the UNDOTBS2 tablespace will be bitmap managed.

  ---

  Reference: http://www.shannura.com/archives/2226261108_undo_01.html

• Question 252:

  A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance.

  You plan to use the ALTER SYSTEM command.

  Which two methods can be used? (Choose two.)

  A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.
  B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.
  C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.
  D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
  E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.
  F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
  C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command.
  F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command.

• Question 253:

  You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

  In which three ways can you re-create the lost disk group and restore the data? (Choose three.)

  A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
  B. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
  C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
  D. Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
  E. Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
  F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
  A. Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
  C. Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
  F. Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

  ---

  AC (not E):

  The md_restore command allows you to restore a disk group from the metadata created by the md_backup command.

  md_restore can't restore data, only metadata.

• Question 254:

  Examine these steps:

  CONNECT / AS SYSDBA

  CREATE DIRECTORY dumpdir AS '/u01/app/';

  Directory created.

  GRANT READ, WRITE ON DIRECTORY dumpdir TO PUBLIC;

  Grant succeeded.

  CREATE USER TEST IDENTIFIED BY test;

  User created.

  GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE TO test;

  Grant succeeded.

  CONN test/test

  Connected.

  CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER(7)); Table

  created.

  SQL> CREATE SYNONYM emp FOR test_employees;

  Synonym created.

  Now examine this command:

  $ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp

  CONTENT=data_only query='EMP:"WHERE salary=12000"'

  What is true about the execution of this command?

  A. It throws an error as the QUERY parameter is not supported on an empty table.
  B. It throws an error as the table test_employees is empty and CONTENT=data_only is specified.
  C. It performs the export successfully.
  D. It throws an error as Data Pump cannot find a table called TEST.EMP.
  C. It performs the export successfully.

• Question 255:

  You want to create a database and you have the following:

  -Oracle Grid Infrastructure is installed and configured.

  -

  Oracle Database Vault is installed in ORACLE_HOME to be used for this database.

  -

  Oracle Enterprise Manager Cloud Control is available and an agent is deployed on the database server.

  Examine the requirements:

  1.

  configuring the database instance to support shared server mode

  2.

  using Automatic Storage Management (ASM) for storing database files.

  3.

  configuring a naming method to help a remote user connect to a database instance

  4.

  configuring the Fast Recovery Area

  5.

  configuring Database Vault

  6.

  configuring Enterprise Manager (EM) Database Express

  7.

  registering with EM Cloud Control

  8.

  configuring remote log archive destinations

  9.

  enabling daily incremental backups

  10.

  configuring a nondefault block size for nondefault block size tablespaces

  Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

  A. 1, 2, 4, 5, 7, 8, 9 and 10
  B. 1, 2, 4, 5, 6 and 7
  C. 1, 2, 3, 8, 9 and 10
  D. 1, 2, 3, 4, 6, 8, 9 and 10
  E. 1, 2, 4, 5, 6, 7 and 8
  D. 1, 2, 3, 4, 6, 8, 9 and 10

• Question 256:

  Examine the memory-related parameters set in the SPFILE of an Oracle database:

  

  Which statement is true?

  A. Only SGA components are sized automatically.
  B. Memory is dynamically re-allocated between the SGA and PGA as needed.
  C. The size of the PGA cannot grow automatically beyond 500 MB.
  D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.
  B. Memory is dynamically re-allocated between the SGA and PGA as needed.

• Question 257:

  Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

  A. It can be used to create a database template from an existing database.
  B. It can be used to add a new tablespace.
  C. It can generate SQL database creation scripts.
  D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
  E. It can configure Automatic Storage Management (ASM) diskgroups.
  A. It can be used to create a database template from an existing database.
  C. It can generate SQL database creation scripts.

  ---

  References: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm#CJACEDCD

• Question 258:

  Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

  A. The ability of users to audit their own schema objects is not available in the post-migrated database.
  B. Operating system audit trail is available in the post-migrated database.
  C. Network auditing is available in the post-migrated database.
  D. Mandatory auditing of audit administrative actions is available in the post-migrated database.
  A. The ability of users to audit their own schema objects is not available in the post-migrated database.
  D. Mandatory auditing of audit administrative actions is available in the post-migrated database.

  ---

  References: https://docs.oracle.com/database/121/DBSEG/audit_changes.htm#DBSEG341

• Question 259:

  You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).

  Examine the query and its output:

  

  Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file? (Choose two.)

  A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
  B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
  D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
  E. Re-create the password file in the Oracle Database 12c format.
  B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
  D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

  ---

  * orapwd

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

  The syntax of the ORAPWD command is as follows:

  orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]

  [DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]

  [SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]

  force - whether to overwrite existing file (optional),

  * v$PWFILE_users

  / 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.

  / 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.

  ColumnDatatypeDescription USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges

  Incorrect:

  not E: The format of the v$PWFILE_users file is already in 12c format.

• Question 260:

  Your database is configured in ARCHIVELOG mode.

  Examine the RMAN configuration parameters:

  

  Examine the command:

  RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

  What is the outcome?

  A. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
  B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.
  C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.
  D. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.
  B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.

  ---

  References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm