- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
16.
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.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
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. |
17.
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
- Answer & Explanation
- Report
Answer : [A]
Explanation :
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. |
18.
The Oracle Universal Installer is started by executing which program?
- A.emctl
- B.runInstaller
- C.ouistart
- D.isqlplusctl
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The runInstaller executable performs a preinstall check of the operating system and hardware resources before starting the OUI graphical tool. |
19.
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.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
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. |
20.
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
- Answer & Explanation
- Report
Answer : [C]
Explanation :
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. |
|
|
||||||||||||||||||||||||||||
