Copiar e Editar

EXAMEN PREPARACION OCA 12C

Descrição

WIP
David Jimenez
Quiz por David Jimenez, atualizado more than 1 year ago
David Jimenez
Criado por David Jimenez mais de 7 anos atrás
154
0
0

Resumo de Recurso

Questão 1

Questão
Choose two SGA structures that are required in every Oracle instance
Responda
  • Large pool
  • Shared pool
  • Buffer cache
  • Java pool

Questão 2

Questão
Which statement is true?
Responda
  • A database can have only one control file
  • A database must have at least two control files.
  • A database may have zero or more control files.
  • A database must have at least one control file.

Questão 3

Questão
Which component is configured at database startup and cannot be dynamically managed?
Responda
  • Redo log buffer
  • Streams pool
  • Java pool
  • Shared pool
  • None of the above

Questão 4

Questão
Which component is not part of an Oracle instance?
Responda
  • System global area
  • Process monitor
  • Control file
  • Shared pool
  • None

Questão 5

Questão
Which background process guarantees that committed data is saved even when the changes have not been recorded in data files?
Responda
  • DBWn
  • PMON
  • LGWR
  • CKPT
  • ARCn

Questão 6

Questão
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?
Responda
  • Writes the changed blocks to data files
  • Writes the changed blocks to redo log files
  • Triggers checkpoint and thus LGWR writes the changes to redo log files.
  • Does nothing.

Questão 7

Questão
Which of the following best describes a RAC configuration?
Responda
  • One database, multiple instances
  • One instance, multiple databases
  • Multiple databases plugged in from multiple servers
  • Multiple databases, multiple instances

Questão 8

Questão
Which component of the SGA contains the parsed SQL code?
Responda
  • Database buffer cache
  • Dictionary cache
  • Library cache
  • Parse cache

Questão 9

Questão
Which tasks are accomplished by the SMON process? (Choose all that apply.)
Responda
  • Performs recovery at instance startup
  • Performs cleanup after a user session is terminated
  • Starts any server process that stopped running
  • Coalesces contiguous free space in dictionary-managed tablespaces

Questão 10

Questão
Choose the best statement from the options related to segments.
Responda
  • A contiguous set of blocks constitutes a segment.
  • A nonpartitioned table can have only one segment
  • A segment can belong to more than one tablespace.
  • All of the above are true.

Questão 11

Questão
From the following list, choose two processes that are optional in an Oracle Database 12c database.
Responda
  • MMON
  • MMNL
  • ARCn
  • MMAN

Questão 12

Questão
Which SGA component will you increase or configure so that RMAN tape backups do not use memory from the shared pool?
Responda
  • Java pool
  • Streams pool
  • Recovery pool
  • Large pool

Questão 13

Questão
When a user session is terminated, which processes are responsible for cleaning up and releasing locks? (Choose all that apply.)
Responda
  • DBWn
  • LGWR
  • MMON
  • PMON
  • SMON

Questão 14

Questão
The LRU algorithm is used to manage what part of the Oracle architecture?
Responda
  • Users who log on to the database infrequently and may be candidates for being dropped
  • The data file that stores the least amount of information and will need the least frequent backup
  • The tables that users rarely access so that they can be moved to a less active tablespace
  • The shared pool and database buffer cache portions of the SGA

Questão 15

Questão
Two structures make up an Oracle server: an instance and a database. Which of the following best describes the difference between an Oracle instance and a database?
Responda
  • An instance consists of memory structures and processes, whereas a database is composed of physical files.
  • An instance is used only during database creation; after that, the database is all that is needed.
  • An instance is started whenever the demands on the database are high, but the database is used all the time
  • An instance is configured using a pfile, whereas a database is configured using a spfile.

Questão 16

Questão
Which of the following is the proper order of Oracle’s storage hierarchy, from smallest to largest?
Responda
  • Operating-system block, database block, segment, extent
  • Operating-system block, database block, extent, segment
  • Segment, extent, database block, operating-system block
  • Segment, database block, extent, operating-system block

Questão 17

Questão
The DBA unknowingly terminated the process ID belonging to the PMON process of Oracle Database 12c database using the kill -9 command on Unix. Choose the best answer:
Responda
  • Oracle spawns another PMON process automatically.
  • The database hangs, and the DBA must manually start a PMON process.
  • If the database is in ARCHIVELOG mode, Oracle automatically starts another PMON process and recovers from the database hang.
  • The instance crashes and needs to be restarted.

Questão 18

Questão
When an incremental checkpoint happens in a database, which file(s) are updated with the checkpoint position? Choose all options that are correct.
Responda
  • Data files
  • Control files
  • Initialization Parameter Files
  • Redo log files
  • Archive log files

Questão 19

Questão
User Isabella updates a table and commits the change after a few seconds. Which of the following actions are happening in the database? Order them in the correct sequence and ignore the actions that are not relevant.
Responda
  • Oracle reads the blocks from data file to buffer cache and updates the blocks.
  • Changed blocks from the buffer cache are written to data files.
  • The user commits the change
  • LGWR writes the changed blocks to the redo log buffer.
  • The server process writes the change vectors to the redo log buffer.
  • LGWR flushes the redo log buffer to redo log files.
  • A checkpoint occurs

Questão 20

Questão
Querying the V$LOG file shows the following information. Which redo group files are required for instance crash recovery? SQL> select GROUP#, ARCHIVED, STATUS from V$LOG; GROUP# ARC STATUS ---------- --- ---------------- 1 NO CURRENT 2 NO INACTIVE 3 NO INACTIVE 4 NO ACTIVE
Responda
  • Group 1 and 4
  • Group 2 and 3
  • Groups 1 through 4
  • Group 1
  • Group 4

Questão 21

Questão
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
  • UNDO_RETENTION is a static parameter and, therefore, cannot be changed using ALTER SYSTEM.
  • The change will be available to the instance only after a database cycle
  • The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
  • 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 22

Questão
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?
Responda
  • ALERT_LOG_DEST
  • BACKGROUND_DUMP_DEST
  • DIAGNOSTIC_DEST
  • INIT_LOG_DUMP_DEST

Questão 23

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

Questão 24

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

Questão 25

Questão
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
  • /u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace
  • /u01/app/oracle/diag/rdbms/xyz/xyz/trace
  • /u01/app/oracle/diag/rdbms/xyz/xyz/alert
  • /u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace
  • /u01/app/oracle/log/rdbms/xyz/xyz/trace

Questão 26

Questão
You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which statement is true?
Responda
  • A block size of 32KB is not allowed in Oracle Database 12c.
  • You must choose the Data Warehouse template in the DBCA
  • You must choose the Custom template in the DBCA.
  • You must set the environment variable DB_BLOCK_SIZE to 32,768

Questão 27

Questão
All of the following are database-management options within the Database Configuration Assistant except which one?
Responda
  • Change Database Initialization Parameters
  • Create a Database
  • Manage Templates
  • Delete a Database

Questão 28

Questão
The Oracle Universal Installer is started by executing which program?
Responda
  • emctl
  • runInstaller
  • ouistart
  • isqlplusctl

Questão 29

Questão
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
  • Modify the server’s kernel parameters
  • Create a new Unix user to own the Oracle software
  • Create the mount points and directory structure using the OFA model
  • Determine which directory will be used for $ORACLE_HOME.

Questão 30

Questão
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
  • initOCA12C.ora
  • OCA12Cspfile.ora
  • spfile.ora
  • init.ora

Questão 31

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

Questão 32

Questão
Which script creates the database dictionary?
Responda
  • dictionary.sql
  • catdict.sql
  • catproc.sql
  • catalog.sql

Questão 33

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

Questão 34

Questão
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
  • STARTUP AFTER SHUTDOWN
  • STARTUP FORCE
  • SHUTDOWN FORCE
  • SHUTDOWN ABORT and STARTUP

Questão 35

Questão
Which of the following startup options does not perform a database recovery?
Responda
  • STARTUP
  • STARTUP FORCE RESTRICT
  • STARTUP NOMOUNT
  • STARTUP OPEN
  • STARTUP RESTRICT

Questão 36

Questão
Which of the following shutdown statements does not perform a clean shutdown?
Responda
  • SHUTDOWN ABORT
  • SHUTDOWN TRANSACTIONAL
  • SHUTDOWN
  • SHUTDOWN IMMEDIATE
  • All of these are considered clean shutdowns

Questão 37

Questão
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
  • STARTUP NOMOUNT RESTRICT
  • STARTUP RESTRICT
  • STARTUP MOUNT RESTRICT
  • STARTUP MOUNT FORCE RESTRICT

Questão 38

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

Questão 39

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

Questão 40

Questão
Which of the following is true about EM Database Express? (Choose all that apply.)
Responda
  • You can start up and shut down a database using Database Express.
  • You can read the contents of the alert log file.
  • You can modify static initialization parameters.
  • The CREATE DATABASE statement creates the Database Control repository in the database

Questão 41

Questão
Which of the following statements about tablespaces is true?
Responda
  • A tablespace is the physical implementation of a logical structure called a namespace.
  • A tablespace can hold the objects of only one schema.
  • A bigfile tablespace can have only one data file.
  • The SYSAUX tablespace is an optional tablespace created only if you install certain database options.

Questão 42

Questão
Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?
Responda
  • The whole storage clause
  • NEXT and PCTINCREASE
  • BUFFERPOOL and FREEPOOL
  • PCTFREE and PCTUSED

Questão 43

Questão
Which is not a type of segment that is stored in a tablespace?
Responda
  • Undo
  • Redo
  • Permanent
  • Temporary

Questão 44

Questão
Which allocation unit is the smallest?
Responda
  • Data file
  • Extent
  • Data block
  • Segment

Questão 45

Questão
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;
Responda
  • ALTER TABLE CUST_INFO DROP COLUMN xx;
  • TRUNCATE TABLE CUST_INFO;
  • INSERT INTO CUST_INFO VALUES (…);
  • DROP TABLE CUST_INFO;
  • RENAME CUST_INFO TO CUSTOMER_INFO;

Questão 46

Questão
If the tablespace is offline, which statements should be executed to make the USERS tablespace read-only? (Choose all that apply.)
Responda
  • ALTER TABLESPACE USERS READ ONLY
  • ALTER DATABASE MAKE TABLESPACE USERS READ ONLY
  • ALTER TABLESPACE USERS ONLINE
  • ALTER TABLESPACE USERS TEMPORARY

Questão 47

Questão
How would you add more space to a tablespace? (Choose all that apply.)
Responda
  • ALTER TABLESPACE <TABLESPACE NAME> ADD DATAFILE SIZE <N>
  • ALTER DATABASE DATAFILE <FILENAME> RESIZE <N>
  • ALTER DATAFILE <FILENAME> RESIZE <N>
  • ALTER TABLESPACE <TABLESPACE NAME> DATAFILE <FILENAME> RESIZE <N>

Questão 48

Questão
The database is using automatic memory management. The standard block size for the database is 8KB. You need to create a tablespace with a block size of 16KB. Which initialization parameter should be set?
Responda
  • DB_8K_CACHE_SIZE
  • DB_16K_CACHE_SIZE
  • DB_CACHE_SIZE
  • None of the above

Questão 49

Questão
Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?
Responda
  • DBA_DATA_FILES
  • DBA_TABLESPACES
  • DBA_TEMP_FILES
  • DBA_LOCAL_FILES

Questão 50

Questão
How would you drop a tablespace if the tablespace were not empty?
Responda
  • Rename all the objects in the tablespace, and then drop the tablespace.
  • Remove the data files belonging to the tablespace from the disk.
  • Use ALTER DATABASE DROP <TABLESPACE NAME> CASCADE
  • Use DROP TABLESPACE <TABLESPACE NAME> INCLUDING CONTENTS.

Questão 51

Questão
Which command is used to enable the autoextensible feature for a file if the file is already part of a tablespace?
Responda
  • ALTER DATABASE
  • ALTER TABLESPACE.
  • ALTER DATA FILE
  • You cannot change the autoextensible feature once the data file is created.

Questão 52

Questão
Which statement is true regarding the SYSTEM tablespace?
Responda
  • It can be made read-only.
  • It can be offline.
  • Data files can be renamed.
  • Data files cannot be resized.

Questão 53

Questão
The default critical threshold for a tablespace is set at 97 percent, and you think that is too low. Which two options can you use to change the threshold value to 90 percent for tablespace APPS_DATA?
Responda
  • Use Oracle Enterprise Manager Database Express.
  • Use Oracle Enterprise Manager Cloud Control.
  • Use DBMS_SERVER_ALERT package.
  • Use DBMS_SPACE package.

Questão 54

Questão
Choose the statements that are resumable. (Choose three.)
Responda
  • ALTER TABLE … SPLIT PARTITION
  • SELECT
  • INSERT INTO … SELECT
  • CREATE TABLESPACE
  • ALTER TABLE … SHRINK SPACE

Questão 55

Questão
How do you ensure you are notified when a resumable session is suspended? (Choose two.)
Responda
  • You’ll be notified by email at the address registered in database properties.
  • Write a custom script to look for “statement in resumable session * was suspended” in the alert log and notify the DBA.
  • Create an AFTER SUSPEND trigger and a code notification
  • A suspended session displays a message on the screen.

Questão 56

Questão
Which statement regarding reclaiming wasted space is true?
Responda
  • Segment shrink is accomplished using the ALTER TABLE … MOVE and ALTER INDEX … REBUILD statements.
  • Segment shrink and reorganize are similar operations.
  • When a table segment shrink operation is completed, the dependent indexes are in invalid state and need to be rebuilt.
  • A segment shrink operation is applicable only on tablespaces with automatic segment space management.

Questão 57

Questão
Which compression option should be specified to compress blocks of tables that are used by the OLTP application?
Responda
  • COMPRESS
  • NOCOMPRESS
  • COMPRESS FOR OLTP
  • COMPRESS FOR ONLINE DML

Questão 58

Questão
Choose the best option regarding extents.
Responda
  • An extent is a grouping of Oracle blocks.
  • An extent is a grouping of OS blocks
  • An extent is a grouping of segments.
  • An extent is allocated when a table is created

Questão 59

Questão
You issue the statement CREATE TABLESPACE X;. Which of the following is the best option?
Responda
  • The statement fails because mandatory properties are not defined.
  • The 100MB tablespace is created.
  • The mandatory DATAFILE clause is missing
  • The tablespace name should be at least three characters long.

Questão 60

Questão
Choose the information that is not part of a ROWID.
Responda
  • Data object number
  • Relative file number
  • Segment ID where the block belongs
  • Block number in the file

Questão 61

Questão
Changes made with an UPDATE statement in a transaction are permanent in the database and visible to other users after what occurs?
Responda
  • DBWR flushes the changes to disk.
  • You issue a SAVEPOINT statement.
  • You issue a COMMIT statement.
  • A checkpoint occurs.

Questão 62

Questão
Which of the following commands returns an error if the transaction starts with SET TRANSACTION READ ONLY?
Responda
  • ALTER SYSTEM
  • SET ROLE
  • ALTER USER
  • None of the above

Questão 63

Questão
Guaranteed undo retention can be specified for which of the following objects?
Responda
  • A tablespace
  • A table
  • The database
  • A transaction
  • The instance

Questão 64

Questão
Which of the following lock modes permits concurrent queries on a table but prohibits updates to the locked table?
Responda
  • ROW SHARE
  • ROW EXCLUSIVE
  • SHARE ROW EXCLUSIVE
  • All of the above

Questão 65

Questão
Select the statement that is not true regarding undo tablespaces
Responda
  • Undo tablespaces will not be created if they are not specified in the CREATE DATABASE command.
  • Two undo tablespaces can be active if a new undo tablespace was specified and the old one contains pending transactions
  • You can switch from one undo tablespace to another while the database is online
  • UNDO_MANAGEMENT cannot be changed dynamically while the instance is running.

Questão 66

Questão
To resolve a lock conflict, which of the following methods can you use? Choose all that apply.
Responda
  • Oracle automatically resolves the lock after a short but predefined time period by killing the session that is holding the lock.
  • The DBA can kill the session holding the lock.
  • The user can either roll back or commit the transaction that is holding the lock.
  • Oracle automatically resolves the lock after a short but predefined period by killing the session that is requesting the lock.

Questão 67

Questão
Two transactions occur at the wall clock times in the following table. What happens at 10:05?
Image:
9d3218cd-95c7-496c-b2c7-6beccde52470 (image/png)
Responda
  • Session 2 will wait for session 1 to commit or roll back.
  • Session 1 will wait for session 2 to commit or roll back
  • A deadlock will occur, and both sessions will hang unless one of the users cancels their statement or the DBA kills one of the sessions.
  • A deadlock will occur, and Oracle will cancel one of the statements.
  • Neither session is updating the same column, so no waiting or deadlock will occur

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

Semelhante

Vocabulário Inglês Básico_1
Alessandra S.
Funções administrativas
brunocmt
Era Napoleônica
Camila Teixeira
Expressões em inglês #3
Eduardo .
TEORIA SEXUAL FREUD
eleuterapara
Flashcards de Inglês - Vocabulário Intermédio
ARLEY MARINHO
Reino Monera
nathaliaires
Números e Operações (Fundamental)
Andre Gonçalves
Técnica Feynman
vivi sousa
Citações para Redação - ENEM
Jayne Torres
Reinos Biológicos
Hudson Breno
Explore a Biblioteca