-
web.groovymark@gmail.com
- December 5, 2024
Question 21
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?
A) ALERT_LOG_DEST
B) BACKGROUND_DUMP_DEST
C) DIAGNOSTIC_DEST
D) INIT_LOG_DUMP_DEST
Correct Answer: C) DIAGNOSTIC_DEST
Explanation: DIAGNOSTIC_DEST is the initialization parameter that determines where the Automatic Diagnostic Repository home is located. The alert log file would be in the <diagnostic_dest>/diag/rdbms/<dbname>/<instancename>/alert directory.
Question 22
Which data dictionary view is used to view the current values of parameters?
A) V$DATABASE
B) V$SPPARAMETER
C) V$PARAMETER
D) V$SYSPARAMETER
Correct Answer: C) V$PARAMETER
Explanation: V$PARAMETER shows information about the parameters and their current values in the database. V$SPPARAMETER shows the information as read from the spfile.
Question 23
Which startup options must be used to start the instance when you create a new database?
A) STARTUP FORCE
B) STARTUP MOUNT
C) STARTUP RESTRICT
D) STARTUP NOMOUNT
Correct Answer: D) STARTUP NOMOUNT
Explanation: When creating a new database or creating a control file, the database should be in the NOMOUNT state.
Question 24
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?
A) /u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace
B) /u01/app/oracle/diag/rdbms/xyz/xyz/trace
C) /u01/app/oracle/diag/rdbms/xyz/xyz/alert
D) /u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace
Correct Answer: B) /u01/app/oracle/diag/rdbms/xyz/xyz/trace
Explanation: The alert log file in Oracle Database 12c is saved in the $ORACLE_BASE/diag/rdbms/<dbname>/<instancename>/trace directory.
Question 25
You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?
A) A block size of 32KB is not allowed in Oracle Database 12c.
B) You must choose the Data Warehouse template in the DBCA.
C) You must choose the Custom template in the DBCA.
D) You must set the environment variable DB_BLOCK_SIZE to 32,768.
Correct Answer: C) You must choose the Custom template in the DBCA.
Explanation: The Custom template lets you choose the database block size in the DBCA. If the template includes data files, the block size of the template cannot be changed. The predefined templates that come with data files have the block size at 8KB.
Question 26
All of the following are database-management options within the Database Configuration Assistant except which one?
A) Change Database Initialization Parameters
B) Create a Database
C) Manage Templates
D) Delete a Database
Correct Answer: A) Change Database Initialization Parameters
Explanation: The Database Configuration Assistant lets you create databases, manage templates, add database options, and delete databases. Although you can change initialization parameters when you are defining a database, this is not one of the management options available.
Question 27
The Oracle Universal Installer is started by executing which program?
A) emctl
B) runInstaller
C) ouistart
D) isqlplusctl
Correct Answer: B) runInstaller
Explanation: The runInstaller executable performs a preinstall check of the operating system and hardware resources before starting the OUI graphical tool.
Question 28
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?
A) Modify the server’s kernel parameters.
B) Create a new Unix user to own the Oracle software.
C) Create the mount points and directory structure using the OFA model.
D) Determine which directory will be used for $ORACLE_HOME.
Correct Answer: D) Determine which directory will be used for $ORACLE_HOME.
Explanation: While the Unix system administrator is responsible for creating volume groups and mount points, the DBA generally decides where the Oracle binaries will be installed—the location derived from $ORACLE_BASE or designated by the $ORACLE_HOME environment variable.
Question 29
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?
A) initOCA12C.ora
B) OCA12Cspfile.ora
C) spfile.ora
D) init.ora
Correct Answer: C) spfile.ora
Explanation: When starting the instance, Oracle looks for spfileOCA12C.ora file. If it cannot find that file, it looks for spfile.ora. If that file is not found, Oracle looks for the initOCA12C.ora file.
Question 30
Which initialization parameter cannot be changed after the database is created?
A) DB_BLOCK_SIZE
B) DB_NAME
C) CONTROL_FILES
D) None. All parameters can be changed as and when required.
Correct Answer: A) DB_BLOCK_SIZE
Explanation: The block size of the database cannot be changed after database creation. The database name can be changed after the control file is re-created with a new name, and the CONTROL_FILES parameter can be changed after the control files are copied to the new location.
Question 31
Which script creates the database dictionary?
A) dictionary.sql
B) catdict.sql
C) catproc.sql
D) catalog.sql
Correct Answer: D) catalog.sql
Explanation: The catalog.sql script creates the data dictionary views, dynamic performance views, and synonyms.
Question 32
If your database name is PROD and your instance name is PROD1, what would be the name of the text-alert log file?
A) alertPROD.log
B) alert_PROD1.log
C) PROD1alert.log
D) PROD_alert.log
Correct Answer: B) alert_PROD1.log
Explanation: The text-alert log file has the name alert_<instance_name>.log. For most non-RAC databases, the instance name and database name would be the same.
Question 33
Your database is not responding and is in a hung state. You want to shut down and start the database to release all resources. Which statements would you use?
A) STARTUP AFTER SHUTDOWN
B) STARTUP FORCE
C) SHUTDOWN FORCE
D) SHUTDOWN ABORT and STARTUP
Correct Answer: B, D) STARTUP FORCE; SHUTDOWN ABORT and STARTUP.
Explanation: STARTUP FORCE will perform a SHUTDOWN ABORT and STARTUP of the database. SHUTDOWN ABORT will terminate all sessions and processes and will shut down the instance.
Question 34
Which of the following startup options does not perform a database recovery?
A) STARTUP
B) STARTUP FORCE RESTRICT
C) STARTUP NOMOUNT
D) STARTUP OPEN
E) STARTUP RESTRICT
Correct Answer: C) STARTUP NOMOUNT
Explanation: The recovery of a database occurs when the database moves from the MOUNT mode to the OPEN mode. All these options attempt to start up and open the database except for option C, which only puts the database in NOMOUNT mode.
Question 35
Which of the following shutdown statements does not perform a clean shutdown?
A) SHUTDOWN ABORT
B) SHUTDOWN TRANSACTIONAL
C) SHUTDOWN
D) SHUTDOWN IMMEDIATE
E) All of these are considered clean shutdowns.
Correct Answer: A) SHUTDOWN ABORT
Explanation: When you perform a SHUTDOWN ABORT, Oracle never performs a clean shutdown. All other types of shutdowns are considered clean shutdowns because Oracle will not have to perform a recovery on a subsequent database startup.
Question 36
You would like to perform maintenance on the system and limit access to only the DBA staff during the maintenance window. Which of the following startup options should you use?
A) STARTUP NOMOUNT RESTRICT
B) STARTUP RESTRICT
C) STARTUP MOUNT RESTRICT
D) STARTUP MOUNT FORCE RESTRICT
Correct Answer: B) STARTUP RESTRICT
Explanation: The STARTUP RESTRICT choice opens the database and allows only users with RESTRICTED database access to connect and use it.
Question 37
You want to start up the database using a binary initialization file. What is another name for this file?
A) Configfile
B) Pfile
C) Spfile
D) init_pfile.ora
Correct Answer: C) Spfile
Explanation: An spfile is another term for a server-side binary file that Oracle reads when a database startup is performed. This binary file contains all the nondefault initialization parameters used at startup.
Question 38
Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
A) Database startup and shutdown information
B) Nondefault initialization parameters
C) ORA-00600 errors
D) New columns added to a user table
Correct Answer: D) New columns added to a user table
Explanation: The Oracle alert log contains a chronological history of administrative events and actions and certain types of database errors that occur within the database. Adding a column to a user table is not an administrative action and is not recorded in the alert log. Adding a column will be written to the alert log if the parameter enable_ddl_logging is set to TRUE; the default is FALSE.
Question 39
Which of the following is true about EM Database Express? (Choose all that apply.)
A) You can start up and shut down a database using Database Express.
B) You can read the contents of the alert log file.
C) You can modify static initialization parameters.
D) The CREATE DATABASE statement creates the Database Control repository in the database.
Correct Answer: B, C) You can read the contents of the alert log file; You can modify static initialization parameters.
Explanation: A database cannot be started or stopped using OEM Database Express. The Database Control repository is not created when the CREATE DATABASE statement is executed. DBCA creates the Database Control repository and configures Database Control for you.
Question 40
Which of the following statements about tablespaces is true?
A) A tablespace is the physical implementation of a logical structure called a namespace.
B) A tablespace can hold the objects of only one schema.
C) A bigfile tablespace can have only one data file.
D) The SYSAUX tablespace is an optional tablespace created only if you install certain database options.
Correct Answer: C) A bigfile tablespace can have only one data file.
Explanation: Bigfile tablespaces can have only a single data file. The traditional or smallfile tablespace can have many data files (the limit is OS-dependent, mostly 1022).
