Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 351:

  A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:

  1.

  The user account must be locked after five unsuccessful login attempts.

  2.

  Data read per session must be limited for the user.

  3.

  The user cannot have more than three simultaneous sessions.

  4.

  The user must have a maximum of 10 minutes session idle time before being logged off automatically. How would you accomplish this?

  A. by granting a secure application role to the user
  B. by implementing Database Resource Manager
  C. by using Oracle Label Security options
  D. by assigning a profile to the user
  D. by assigning a profile to the user

• Question 352:

  You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area? (Choose two.)

  A. backup pieces
  B. copies of all parameter files
  C. trace file generated using BACKUP CONTROLFILE TO TRACE
  D. control file autobackups
  A. backup pieces
  D. control file autobackups

• Question 353:

  In your Oracle 12c database, you invoke SQL *Loader Express Mode command to load data:

  $> sqlldr hr/hr table=employees

  Which two statements are true about this command? (Choose two.)

  A. It succeeds and creates the EMPLOYEES table in the HR schema if the table does not exist.
  B. It fails because the SQL *Loader control file location is not specified.
  C. It fails because the SQL *Loader data file location is not specified.
  D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
  E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.
  D. It succeeds with default settings if the EMPLOYEES table belonging to the HR schema is already defined in the database.
  E. It succeeds even if the HR user does not have the CREATE DIRECTORY privilege.

• Question 354:

  Examine the following command:

  CREATE TABLE (prod_id number(4),

  Prod_name varchar2 (20),

  Category_id number(30),

  Quantity_on_hand number (3) INVISIBLE);

  Which three statements are true about using an invisible column in the PRODUCTS table? (Choose three.)

  A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  C. Referential integrity constraint cannot be set on the invisible column.
  D. The invisible column cannot be made visible and can only be marked as unused.
  E. A primary key constraint can be added on the invisible column.
  A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
  B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
  E. A primary key constraint can be added on the invisible column.

  ---

  AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output:

  *

  SELECT * FROM statements in SQL

  *

  DESCRIBE commands in SQL*Plus

  *

  %ROWTYPE attribute declarations in PL/SQL

  *

  Describes in Oracle Call Interface (OCI)

  Incorrect:

  Not D: You can make invisible columns visible.

  You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.

• Question 355:

  You created an encrypted tablespace:

  

  You then closed the encryption wallet because you were advised that this is secure.

  Later in the day, you attempt to create the EMPLOYEES table in the SECURESPACE tablespace with the SALT option on the EMPLOYEE column. Which is true about the result?

  A. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
  B. It generates an error when creating the table because the wallet is closed.
  C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
  D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
  B. It generates an error when creating the table because the wallet is closed.

• Question 356:

  You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows:

  A. Transportable database
  B. Transportable tablespace
  C. Data Pump full export / import
  D. The DBMS_PDB package
  E. RMAN

  C. Data Pump full export / import

• Question 357:

  Which four actions are possible during an Online Data file Move operation? (Choose four.)

  A. Creating and dropping tables in the data file being moved
  B. Performing file shrink of the data file being moved
  C. Querying tables in the data file being moved
  D. Performing Block Media Recovery for a data block in the data file being moved
  E. Flashing back the database
  F. Executing DML statements on objects stored in the data file being moved
  A. Creating and dropping tables in the data file being moved
  C. Querying tables in the data file being moved
  E. Flashing back the database
  F. Executing DML statements on objects stored in the data file being moved

  ---

  -

  You can now move On line Datafile without hove to stop Monoged Recovery and manually copy and rename Files. This can even be used to move Datafiles from or to ASM.

  -

  New in Oracle Database 12c: FROM METAUNK. Physical Standby Database is in Active Data Guard Mode (opened READ ONLY and Managed Recovery is running):

  It is now possible to online move a Datafile while Managed Recovery is running, ie. the Physical Standby Database is in Active Data Guard Mode. You can use this Command to move the Datafile

  -

  A flashback operation does not relocate a moved data file to its previous location. If you move a data file online from one location to another and later flash back the database to a point in time before the move, then the Data file remains in

  the new location, but the contents of the Data file ore changed to the contents at the time specified in the flashback. Oracle0 Database Administrator's Guide 12c Release 1 (12.1)

• Question 358:

  All of your database instances use SPFILES.

  You executed this command in one of them:

  ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;

  Which statement is true?

  A. The parameter is modified in memory and in the parameter file.
  B. The command returns an error.
  C. The parameter is modified in the parameter file only.
  D. The parameter is modified in memory only.
  C. The parameter is modified in the parameter file only.

  ---

  Reference: https://docs.oracle.com/database/121/ADMIN/memory.htm#ADMIN00207

• Question 359:

  Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.

  The steps to recover the tablespace are as follows:

  1.

  Mount the CDB.

  2.

  Close all the PDBs.

  3.

  Open the database.

  4.

  Apply the archive redo logs.

  5.

  Restore the data file.

  6.

  Take the SYSAUX tablespace offline.

  7.

  Place the SYSAUX tablespace online.

  8.

  Open all the PDBs with RESETLOGS.

  9.

  Open the database with RESETLOGS.

  10.

  Execute the command SHUTDOWN ABORT.

  Which option identifies the correct sequence to recover the SYSAUX tablespace?

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

  ---

  RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;

  RMAN> RESTORE TABLESPACE sysaux;

  RMAN> RECOVER TABLESPACE sysaux;

  RMAN> ALTER TABLESPACE sysaux ONLINE;

  *

  Example:

  While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost".

  Cannot close the pdb as the system datafile was missing...

  So only option to recover was:

  Shutdown cdb (10)

  startup mount; (1)

  restore pluggable database

  recover pluggable database

  alter database open;

  alter pluggable database name open;

  Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.

  *

  Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:

  / Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances)

  / After shutting down the database using SHUTDOWN ABORT

  Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.

  *

  Open the database with the RESETLOGS option after finishing recovery:

  SQL> ALTER DATABASE OPEN RESETLOGS;

• Question 360:

  To implement Automatic Management (AMM), you set the following parameters:

  

  When you try to start the database instance with these parameter settings, you receive the following error message:

  SQL > startup

  ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.

  Identify the reason the instance failed to start.

  A. The PGA_AGGREGATE_TARGET parameter is set to zero.
  B. The STATISTICS_LEVEL parameter is set to BASIC.
  C. Both the SGA_TARGET and MEMORY_TARGET parameters are set.
  D. The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
  B. The STATISTICS_LEVEL parameter is set to BASIC.

  ---

  Example: SQL> startup force ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET