Copiar e Editar

OCA-9-Creating and Operating Oracle Database 12c

Descrição

OCA OCA Quiz sobre OCA-9-Creating and Operating Oracle Database 12c, criado por Jamonero Blanco em 29-01-2017.
Jamonero Blanco
Quiz por Jamonero Blanco, atualizado more than 1 year ago
Jamonero Blanco
Criado por Jamonero Blanco quase 8 anos atrás
223
2
0

Resumo de Recurso

Questão 1

Questão
1. You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too low for some of your transactions. The database was created using DBCA. You issue the following statement: ALTER SYSTEM SET UNDO_RETENTION=4800; Which option is true?
Responda
  • A. UNDO_RETENTION is a static parameter and, therefore, cannot be changed using ALTER SYSTEM .
  • B. The change will be available to the instance only after a database cycle.
  • C. The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
  • D. The value is changed only in memory, and the server parameter file needs to be updated for the change to persist across database shutdowns.

Questão 2

Questão
2. You need to find the directory where the Oracle alert log is being written. Which initial- ization parameter can be best used to list the full directory path of the alert log location?
Responda
  • A. ALERT_LOG_DEST
  • B. BACKGROUND_DUMP_DEST
  • C. DIAGNOSTIC_DEST
  • D. INIT_LOG_DUMP_DEST

Questão 3

Questão
3. Which data dictionary view is used to view the current values of parameters?
Responda
  • A. V$DATABASE
  • B. V$SPPARAMETER
  • C. V$PARAMETER
  • D. V$SYSPARAMETER

Questão 4

Questão
4. Which startup options must be used to start the instance when you create a new database?
Responda
  • A. STARTUP FORCE
  • B. STARTUP MOUNT
  • C. STARTUP RESTRICT
  • D. STARTUP NOMOUNT

Questão 5

Questão
5. 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?
Responda
  • 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
  • E. /u01/app/oracle/log/rdbms/xyz/xyz/trace

Questão 6

Questão
6. You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?
Responda
  • 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.

Questão 7

Questão
7. All of the following are database-management options within the Database Configura- tion Assistant except which one?
Responda
  • A. Change Database Initialization Parameters
  • B. Create a Database
  • C. Manage Templates
  • D. Delete a Database

Questão 8

Questão
8. The Oracle Universal Installer is started by executing which program?
Responda
  • A. emctl
  • B. runInstaller
  • C. ouistart
  • D. isqlplusctl

Questão 9

Questão
9. 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?
Responda
  • 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 .

Questão 10

Questão
10. 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?
Responda
  • A. initOCA12C.ora
  • B. OCA12Cspfile.ora
  • C. spfile.ora
  • D. init.ora

Questão 11

Questão
Which initialization parameter cannot be changed after the database is created?
Responda
  • A. DB_BLOCK_SIZE
  • B. DB_NAME
  • C. CONTROL_FILES
  • D. None. All parameters can be changed as and when required.

Questão 12

Questão
12. Which script creates the database dictionary?
Responda
  • A. dictionary.sql
  • B. catdict.sql
  • C. catproc.sql
  • D. catalog.sql

Questão 13

Questão
13. If your database name is PROD and your instance name is PROD1 , what would be the name of the text-alert log file?
Responda
  • A. alertPROD.log
  • B. alert_PROD1.log
  • C. PROD1alert.log
  • D. PROD_alert.log

Questão 14

Questão
14. 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?
Responda
  • A. STARTUP AFTER SHUTDOWN
  • B. STARTUP FORCE
  • C. SHUTDOWN FORCE
  • D. SHUTDOWN ABORT and STARTUP

Questão 15

Questão
15. Which of the following startup options does not perform a database recovery?
Responda
  • A. STARTUP
  • B. STARTUP FORCE RESTRICT
  • C. STARTUP NOMOUNT
  • D. STARTUP OPEN
  • E. STARTUP RESTRICT

Questão 16

Questão
16. Which of the following shutdown statements does not perform a clean shutdown?
Responda
  • A. SHUTDOWN ABORT
  • B. SHUTDOWN TRANSACTIONAL
  • C. SHUTDOWN
  • D. SHUTDOWN IMMEDIATE
  • E. All of these are considered clean shutdowns.

Questão 17

Questão
17. 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?
Responda
  • A. STARTUP NOMOUNT RESTRICT
  • B. STARTUP RESTRICT
  • C. STARTUP MOUNT RESTRICT
  • D. STARTUP MOUNT FORCE RESTRICT

Questão 18

Questão
18. You want to start up the database using a binary initialization file. What is another name for this file?
Responda
  • A. Configfile
  • B. Pfile
  • C. Spfile
  • D. init_pfile.ora

Questão 19

Questão
19. Under normal circumstances, which of the following actions or events is not found in the Oracle alert log?
Responda
  • A. Database startup and shutdown information
  • B. Nondefault initialization parameters
  • C. ORA-00600 errors
  • D. New columns added to a user table

Questão 20

Questão
20. Which of the following is true about EM Database Express? (Choose all that apply.)
Responda
  • 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.

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
Informática de A a Z
fabianomotta
História da Arte - Barroco
Bruno Torrezan
Direito Constitucional Esquematizado - Pedro Lenza - Capítulo 2 - Exercícios
Anaximandro Martins Leão
Atualidades Vestibular Enem 2
GoConqr suporte .
Passe Cursinho - Pré-Vestibular 2016
Passe Cursinho
Contextualização da Aula 1- Gestão - Administração da Carreira Profissional
Fabrícia Assunção
Citações para Redação - ENEM
Jayne Torres
Y2 - Week 1
Natalia André
Explore a Biblioteca