OCA Oracle 12C Administration (1Z0-062) Practice Test Set 2

Choose the best statement from the options related to segments.


Options are :

  • A contiguous set of blocks constitutes a segment.
  • A nonpartitioned table can have only one segment (Correct)
  • A segment can belong to more than one tablespace
  • All of the above are true.

Answer : A nonpartitioned table can have only one segment

Which tasks are accomplished by the SMON process?


Options are :

  • Starts any server process that stopped running
  • Performs recovery at instance startup (Correct)
  • None
  • Performs cleanup after a user session is terminated

Answer : Performs recovery at instance startup

OCA Oracle 12C Administration (1Z0-062) Practice Test Set 3

All of the following are database-management options within the Database Configuration Assistant except which one?


Options are :

  • Create a Database
  • Delete a Database
  • Manage Templates
  • Change Database Initialization Parameters (Correct)

Answer : Change Database Initialization Parameters

Which startup options must be used to start the instance when you create a new database?


Options are :

  • STARTUP RESTRICT
  • STARTUP FORCE
  • STARTUP NOMOUNT (Correct)
  • STARTUP MOUNT

Answer : STARTUP NOMOUNT

Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?


Options are :

  • DBWn
  • CKPT
  • ARCn
  • LGWR (Correct)
  • PMON

Answer : LGWR

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 1

Which allocation unit is the smallest?


Options are :

  • Data block (Correct)
  • Data file
  • Extent
  • Segment

Answer : Data block

Which of the following best describes a RAC configuration?


Options are :

  • Multiple databases plugged in from multiple servers
  • Multiple databases, multiple instances
  • One database, multiple instances (Correct)
  • One instance, multiple databases

Answer : One database, multiple instances

Your database name is OCA12C. The options show the files that are available in the $ORACLE_HOME/dbs directory. Which file is used to start up the database instance when you issue the STARTUP command?


Options are :

  • init.ora
  • spfile.ora (Correct)
  • OCA12Cspfile.ora
  • initOCA12C.ora

Answer : spfile.ora

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 2

Which of the following statements about tablespaces is true?


Options are :

  • A tablespace is the physical implementation of a logical structure called a namespace (Correct)
  • The SYSAUX tablespace is an optional tablespace created only if you install certain database options
  • A tablespace is the physical implementation of a logical structure called a namespace
  • A tablespace is the physical implementation of a logical structure called a namespace

Answer : A tablespace is the physical implementation of a logical structure called a namespace

You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?


Options are :

  • You must choose the Custom template in the DBCA. (Correct)
  • You must set the environment variable DB_BLOCK_SIZE to 32,768.
  • You must choose the Data Warehouse template in the DBCA
  • A block size of 32KB is not allowed in Oracle Database 12c.

Answer : You must choose the Custom template in the DBCA.

Which data dictionary view is used to view the current values of parameters?


Options are :

  • V$SPPARAMETER
  • V$DATABASE
  • V$PARAMETER (Correct)
  • V$SYSPARAMETER

Answer : V$PARAMETER

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 3

You performed the following statement in the database. What actions can you perform on the CUST_INFO table in the CUST_DATA tablespace. (Choose all that apply.)
ALTER TABLESPACE CUST_DATA READ ONLY;


Options are :

  • RENAME CUST_INFO TO CUSTOMER_INFO;
  • DROP TABLE CUST_INFO; (Correct)
  • TRUNCATE TABLE CUST_INFO;
  • ALTER TABLE CUST_INFO DROP COLUMN xx;
  • INSERT INTO CUST_INFO VALUES (…);

Answer : DROP TABLE CUST_INFO;

Which is not a type of segment that is stored in a tablespace?


Options are :

  • Permanent
  • Undo
  • Redo (Correct)
  • Temporary

Answer : Redo

You need to find the directory where the Oracle alert log is being written. Which initialization parameter can be best used to list the full directory path of the alert log location?


Options are :

  • BACKGROUND_DUMP_DEST (Correct)
  • NONE
  • ALERT_LOG_DEST
  • DIAGNOSTIC_DEST
  • INIT_LOG_DUMP_DEST

Answer : BACKGROUND_DUMP_DEST

OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 4

The Oracle Universal Installer is started by executing which program?


Options are :

  • runInstaller (Correct)
  • emctl
  • isqlplusctl
  • ouistart

Answer : runInstaller

Which component of the SGA contains the parsed SQL code?


Options are :

  • Library cache (Correct)
  • Dictionary cache
  • Parse cache
  • Database buffer cache

Answer : Library cache

Which statement is true?


Options are :

  • A database may have zero or more control files
  • A database can have only one control file.
  • A database must have at least two control files.
  • A database must have at least one control file. (Correct)

Answer : A database must have at least one control file.

OCA Oracle Database 11g Administrator Certified Associate Set 1

You’ve been asked to install Oracle Database 12c on a new Linux server. You’re likely to ask the Unix system administrator to do all but which one of the following for you in order to get the new server ready for Oracle?


Options are :

  • Create a new Unix user to own the Oracle software.
  • Create the mount points and directory structure using the OFA model
  • Modify the server’s kernel parameters.
  • Determine which directory will be used for $ORACLE_HOME. (Correct)

Answer : Determine which directory will be used for $ORACLE_HOME.

The DIAGNOSTIC_DEST parameter is not set up in the initialization-parameter file. The value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0, and the value of ORACLE_BASE is /u01/app/oracle. The database and instance name is xyz. What is the location of the text-alert log file for the xyz database?


Options are :

  • /u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace
  • /u01/app/oracle/diag/rdbms/xyz/xyz/alert
  • /u01/app/oracle/log/rdbms/xyz/xyz/trace
  • /u01/app/oracle/diag/rdbms/xyz/xyz/trace (Correct)
  • /u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace

Answer : /u01/app/oracle/diag/rdbms/xyz/xyz/trace

User John has updated several rows in a table and issued a commit. What does the DBWn (database writer) process do at this time in response to the commit event?


Options are :

  • Does nothing (Correct)
  • Writes the changed blocks to redo log files.
  • Triggers checkpoint and thus LGWR writes the changes to redo log files
  • Writes the changed blocks to data files.

Answer : Does nothing

OCA Oracle Database 11g Administrator Certified Associate Set 2

Which of the following options for the pfile/spfile’s STATISTICS_LEVEL parameter turns off AWR statistics gathering and ADDM advisory services?


Options are :

  • OFF
  • BASIC (Correct)
  • ALL
  • TYPICAL

Answer : BASIC

OCA Oracle Database 11g Administrator Certified Associate Set 3

Which parameter is used to enable Automatic Memory Management?


Options are :

  • . AUTOMATIC_MEMORY
  • MEMORY_TARGET (Correct)
  • AMM_TARGET
  • SGA_TARGET

Answer : MEMORY_TARGET

Suppose you have used EM Database Control to drill down into ADDM findings and have found that a single SQL statement is causing the majority of the I/O on your system. Which of the following advisors is best suited to troubleshoot this SQL statement?


Options are :

  • SQL Tuning Advisor
  • SQL Access Advisor
  • Both A and B (Correct)
  • Neither A nor B

Answer : Both A and B

When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?


Options are :

  • The last commit (Correct)
  • The last incremental backup using RMAN
  • The last checkpoint position
  • The last redo log file switch

Answer : The last commit

OCA Oracle Database 11g Administrator Certified Associate Set 4

Which of the following system privileges should be granted judiciously because they can allow the grantee to masquerade as another user?


Options are :

  • All of the above (Correct)
  • CREATE ANY JOB
  • CREATE ANY PROCEDURE
  • ALTER USER

Answer : All of the above

User system granted the SELECT ANY TABLE privilege to user ian using WITH ADMIN OPTION . Ian then granted SELECT ANY TABLE to user stuart . Ian has left the company, and his account has been dropped. What happens to Stuart’s privileges?


Options are :

  • Stuart loses his privileges if Ian was dropped with the CASCADE REVOKE option.
  • Stuart retains his privileges. (Correct)
  • Stuart retains his privileges if Ian was dropped with the NOCASCADE REVOKE option.
  • Stuart loses his privileges.

Answer : Stuart retains his privileges.

Which initialization parameter can disable memory advisors and Automatic Shared Memory Management? (Choose the best answer.)


Options are :

  • STATISTICS_LEVEL (Correct)
  • CONTROL_MANAGEMENT_PACK_ACCESS
  • MEMORY_TARGET
  • Memory advisors cannot be disabled.

Answer : STATISTICS_LEVEL

OCP Oracle 12C Advanced Administration(1Z0-063) Set 1

Examine the CREATE USER statement and choose which of the following options best applies.

CREATE USER JOHN IDENTIFIED BY JOHNNY
DEFAULT TABLESPACE INDEX01
PASSWORD EXPIRE
QUOTA UNLIMITED ON DATA01
QUOTA UNLIMITED ON INDEX01;
GRANT CONNECT TO JOHN;


Options are :

  • Specifying unlimited space quota on INDEX01 is a redundant step because INDEX01 is JOHN ’s default tablespace.
  • JOHN is authenticated by the database. (Correct)
  • When tables are being created, if JOHN did not specify the TABLESPACE clause, the table will be created on the DATA01 tablespace.
  • JOHN will not be able to log in to the database using SQL*Plus until the DBA changes his password.

Answer : JOHN is authenticated by the database.

Which of the following components of the Oracle architecture stores the statistics gathered by the MMON process?


Options are :

  • AWR (Correct)
  • ASMM
  • ADR
  • ADDM

Answer : AWR

Which two parameters configure automatic PGA memory management?


Options are :

  • PGA_AGGREGATE_LIMIT
  • PGA_AGGREGATE_TARGET (Correct)
  • NOne
  • SGA_TARGET

Answer : PGA_AGGREGATE_TARGET

OCP Oracle 12C Advanced Administration(1Z0-063) Set 2

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions