Test
EXAMEN PREPARACION OCA 12C
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (67)
1Choose two SGA structures that are required in every Oracle instance
- ALarge pool
- BShared pool
- CBuffer cache
- DJava pool
2Which statement is true?
- AA database can have only one control file
- BA database must have at least two control files.
- CA database may have zero or more control files.
- DA database must have at least one control file.
3Which component is configured at database startup and cannot be dynamically
managed?- ARedo log buffer
- BStreams pool
- CJava pool
- DShared pool
- ENone of the above
4Which component is not part of an Oracle instance?
- ASystem global area
- BProcess monitor
- CControl file
- DShared pool
- ENone
5Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?- ADBWn
- BPMON
- CLGWR
- DCKPT
- EARCn
6User 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?- AWrites the changed blocks to data files
- BWrites the changed blocks to redo log files
- CTriggers checkpoint and thus LGWR writes the changes to redo log files.
- DDoes nothing.
7Which of the following best describes a RAC configuration?
- AOne database, multiple instances
- BOne instance, multiple databases
- CMultiple databases plugged in from multiple servers
- DMultiple databases, multiple instances
8Which component of the SGA contains the parsed SQL code?
- ADatabase buffer cache
- BDictionary cache
- CLibrary cache
- DParse cache
9Which tasks are accomplished by the SMON process? (Choose all that apply.)
- APerforms recovery at instance startup
- BPerforms cleanup after a user session is terminated
- CStarts any server process that stopped running
- DCoalesces contiguous free space in dictionary-managed tablespaces
10Choose the best statement from the options related to segments.
- AA contiguous set of blocks constitutes a segment.
- BA nonpartitioned table can have only one segment
- CA segment can belong to more than one tablespace.
- DAll of the above are true.
11From the following list, choose two processes that are optional in an Oracle Database
12c database.- AMMON
- BMMNL
- CARCn
- DMMAN
12Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?- AJava pool
- BStreams pool
- CRecovery pool
- DLarge pool
13When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)- ADBWn
- BLGWR
- CMMON
- DPMON
- ESMON
14The LRU algorithm is used to manage what part of the Oracle architecture?
- AUsers who log on to the database infrequently and may be candidates for being
dropped - BThe data file that stores the least amount of information and will need the least
frequent backup - CThe tables that users rarely access so that they can be moved to a less active
tablespace - DThe shared pool and database buffer cache portions of the SGA
- AUsers who log on to the database infrequently and may be candidates for being
15Two 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?- AAn instance consists of memory structures and processes, whereas a database is
composed of physical files. - BAn instance is used only during database creation; after that, the database is all
that is needed. - CAn instance is started whenever the demands on the database are high, but the
database is used all the time - DAn instance is configured using a pfile, whereas a database is configured using
a spfile.
- AAn instance consists of memory structures and processes, whereas a database is
16Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?- AOperating-system block, database block, segment, extent
- BOperating-system block, database block, extent, segment
- CSegment, extent, database block, operating-system block
- DSegment, database block, extent, operating-system block
17The 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:- AOracle spawns another PMON process automatically.
- BThe database hangs, and the DBA must manually start a PMON process.
- CIf the database is in ARCHIVELOG mode, Oracle automatically starts another
PMON process and recovers from the database hang. - DThe instance crashes and needs to be restarted.
18When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.- AData files
- BControl files
- CInitialization Parameter Files
- DRedo log files
- EArchive log files
19User 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.- AOracle reads the blocks from data file to buffer cache and updates the blocks.
- BChanged blocks from the buffer cache are written to data files.
- CThe user commits the change
- DLGWR writes the changed blocks to the redo log buffer.
- EThe server process writes the change vectors to the redo log buffer.
- FLGWR flushes the redo log buffer to redo log files.
- GA checkpoint occurs
20Querying 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- AGroup 1 and 4
- BGroup 2 and 3
- CGroups 1 through 4
- DGroup 1
- EGroup 4
21You 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?- AUNDO_RETENTION is a static parameter and, therefore, cannot be changed using
ALTER SYSTEM. - BThe change will be available to the instance only after a database cycle
- CThe value is changed in memory, and when the database restarts the next time, the
new value will be preserved when using the spfile. - DThe value is changed only in memory, and the server parameter file needs to be
updated for the change to persist across database shutdowns.
- AUNDO_RETENTION is a static parameter and, therefore, cannot be changed using
22You 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?- AALERT_LOG_DEST
- BBACKGROUND_DUMP_DEST
- CDIAGNOSTIC_DEST
- DINIT_LOG_DUMP_DEST
23Which data dictionary view is used to view the current values of parameters?
- AV$DATABASE
- BV$SPPARAMETER
- CV$PARAMETER
- DV$SYSPARAMETER
24Which startup options must be used to start the instance when you create a new database?
- ASTARTUP FORCE
- BSTARTUP MOUNT
- CSTARTUP RESTRICT
- DSTARTUP NOMOUNT
25The 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
- E/u01/app/oracle/log/rdbms/xyz/xyz/trace
26You want to create a database using the DBCA with DB_BLOCK_SIZE as 32KB. Which
statement is true?- AA block size of 32KB is not allowed in Oracle Database 12c.
- BYou must choose the Data Warehouse template in the DBCA
- CYou must choose the Custom template in the DBCA.
- DYou must set the environment variable DB_BLOCK_SIZE to 32,768
27All of the following are database-management options within the Database Configuration
Assistant except which one?- AChange Database Initialization Parameters
- BCreate a Database
- CManage Templates
- DDelete a Database
28The Oracle Universal Installer is started by executing which program?
- Aemctl
- BrunInstaller
- Couistart
- Disqlplusctl
29You’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?- AModify the server’s kernel parameters
- BCreate a new Unix user to own the Oracle software
- CCreate the mount points and directory structure using the OFA model
- DDetermine which directory will be used for $ORACLE_HOME.
30Your 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?- AinitOCA12C.ora
- BOCA12Cspfile.ora
- Cspfile.ora
- Dinit.ora
31Which initialization parameter cannot be changed after the database is created?
- ADB_BLOCK_SIZE
- BDB_NAME
- CCONTROL_FILES
- DNone. All parameters can be changed as and when required.
32Which script creates the database dictionary?
- Adictionary.sql
- Bcatdict.sql
- Ccatproc.sql
- Dcatalog.sql
33If your database name is PROD and your instance name is PROD1, what would be the
name of the text-alert log file?- AalertPROD.log
- Balert_PROD1.log
- CPROD1alert.log
- DPROD_alert.log
34Your 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?- ASTARTUP AFTER SHUTDOWN
- BSTARTUP FORCE
- CSHUTDOWN FORCE
- DSHUTDOWN ABORT and STARTUP
35Which of the following startup options does not perform a database recovery?
- ASTARTUP
- BSTARTUP FORCE RESTRICT
- CSTARTUP NOMOUNT
- DSTARTUP OPEN
- ESTARTUP RESTRICT
36Which of the following shutdown statements does not perform a clean shutdown?
- ASHUTDOWN ABORT
- BSHUTDOWN TRANSACTIONAL
- CSHUTDOWN
- DSHUTDOWN IMMEDIATE
- EAll of these are considered clean shutdowns
37You 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?- ASTARTUP NOMOUNT RESTRICT
- BSTARTUP RESTRICT
- CSTARTUP MOUNT RESTRICT
- DSTARTUP MOUNT FORCE RESTRICT
38You want to start up the database using a binary initialization file. What is another
name for this file?- AConfigfile
- BPfile
- CSpfile
- Dinit_pfile.ora
39Under normal circumstances, which of the following actions or events is not found in
the Oracle alert log?- ADatabase startup and shutdown information
- BNondefault initialization parameters
- CORA-00600 errors
- DNew columns added to a user table
40Which of the following is true about EM Database Express? (Choose all that apply.)
- AYou can start up and shut down a database using Database Express.
- BYou can read the contents of the alert log file.
- CYou can modify static initialization parameters.
- DThe CREATE DATABASE statement creates the Database Control repository in the
database
41Which of the following statements about tablespaces is true?
- AA tablespace is the physical implementation of a logical structure called a
namespace. - BA tablespace can hold the objects of only one schema.
- CA bigfile tablespace can have only one data file.
- DThe SYSAUX tablespace is an optional tablespace created only if you install certain
database options.
- AA tablespace is the physical implementation of a logical structure called a
42Automatic segment space management on the tablespace causes which of the following
table attributes in that tablespace to be ignored?- AThe whole storage clause
- BNEXT and PCTINCREASE
- CBUFFERPOOL and FREEPOOL
- DPCTFREE and PCTUSED
43Which is not a type of segment that is stored in a tablespace?
- AUndo
- BRedo
- CPermanent
- DTemporary
44Which allocation unit is the smallest?
- AData file
- BExtent
- CData block
- DSegment
45You 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;- AALTER TABLE CUST_INFO DROP COLUMN xx;
- BTRUNCATE TABLE CUST_INFO;
- CINSERT INTO CUST_INFO VALUES (…);
- DDROP TABLE CUST_INFO;
- ERENAME CUST_INFO TO CUSTOMER_INFO;
46If the tablespace is offline, which statements should be executed to make the USERS
tablespace read-only? (Choose all that apply.)- AALTER TABLESPACE USERS READ ONLY
- BALTER DATABASE MAKE TABLESPACE USERS READ ONLY
- CALTER TABLESPACE USERS ONLINE
- DALTER TABLESPACE USERS TEMPORARY
47How would you add more space to a tablespace? (Choose all that apply.)
- AALTER TABLESPACE <TABLESPACE NAME> ADD DATAFILE SIZE <N>
- BALTER DATABASE DATAFILE <FILENAME> RESIZE <N>
- CALTER DATAFILE <FILENAME> RESIZE <N>
- DALTER TABLESPACE <TABLESPACE NAME> DATAFILE <FILENAME>
RESIZE <N>
48The 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?- ADB_8K_CACHE_SIZE
- BDB_16K_CACHE_SIZE
- CDB_CACHE_SIZE
- DNone of the above
49Which data dictionary view can be queried to obtain information about the files that belong to locally managed temporary tablespaces?
- ADBA_DATA_FILES
- BDBA_TABLESPACES
- CDBA_TEMP_FILES
- DDBA_LOCAL_FILES
50How would you drop a tablespace if the tablespace were not empty?
- ARename all the objects in the tablespace, and then drop the tablespace.
- BRemove the data files belonging to the tablespace from the disk.
- CUse ALTER DATABASE DROP <TABLESPACE NAME> CASCADE
- DUse DROP TABLESPACE <TABLESPACE NAME> INCLUDING CONTENTS.
51Which command is used to enable the autoextensible feature for a file if the file is already part of a tablespace?
- AALTER DATABASE
- BALTER TABLESPACE.
- CALTER DATA FILE
- DYou cannot change the autoextensible feature once the data file is created.
52Which statement is true regarding the SYSTEM tablespace?
- AIt can be made read-only.
- BIt can be offline.
- CData files can be renamed.
- DData files cannot be resized.
53The 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?- AUse Oracle Enterprise Manager Database Express.
- BUse Oracle Enterprise Manager Cloud Control.
- CUse DBMS_SERVER_ALERT package.
- DUse DBMS_SPACE package.
54Choose the statements that are resumable. (Choose three.)
- AALTER TABLE … SPLIT PARTITION
- BSELECT
- CINSERT INTO … SELECT
- DCREATE TABLESPACE
- EALTER TABLE … SHRINK SPACE
55How do you ensure you are notified when a resumable session is suspended?
(Choose two.)- AYou’ll be notified by email at the address registered in database properties.
- BWrite a custom script to look for “statement in resumable session * was suspended”
in the alert log and notify the DBA. - CCreate an AFTER SUSPEND trigger and a code notification
- DA suspended session displays a message on the screen.
56Which statement regarding reclaiming wasted space is true?
- ASegment shrink is accomplished using the ALTER TABLE … MOVE and ALTER INDEX
… REBUILD statements. - BSegment shrink and reorganize are similar operations.
- CWhen a table segment shrink operation is completed, the dependent indexes are in
invalid state and need to be rebuilt. - DA segment shrink operation is applicable only on tablespaces with automatic
segment space management.
- ASegment shrink is accomplished using the ALTER TABLE … MOVE and ALTER INDEX
57Which compression option should be specified to compress blocks of tables that are
used by the OLTP application?- ACOMPRESS
- BNOCOMPRESS
- CCOMPRESS FOR OLTP
- DCOMPRESS FOR ONLINE DML
58Choose the best option regarding extents.
- AAn extent is a grouping of Oracle blocks.
- BAn extent is a grouping of OS blocks
- CAn extent is a grouping of segments.
- DAn extent is allocated when a table is created
59You issue the statement CREATE TABLESPACE X;. Which of the following is the
best option?- AThe statement fails because mandatory properties are not defined.
- BThe 100MB tablespace is created.
- CThe mandatory DATAFILE clause is missing
- DThe tablespace name should be at least three characters long.
60Choose the information that is not part of a ROWID.
- AData object number
- BRelative file number
- CSegment ID where the block belongs
- DBlock number in the file
61Changes made with an UPDATE statement in a transaction are permanent in the database
and visible to other users after what occurs?- ADBWR flushes the changes to disk.
- BYou issue a SAVEPOINT statement.
- CYou issue a COMMIT statement.
- DA checkpoint occurs.
62Which of the following commands returns an error if the transaction starts with SET
TRANSACTION READ ONLY?- AALTER SYSTEM
- BSET ROLE
- CALTER USER
- DNone of the above
63Guaranteed undo retention can be specified for which of the following objects?
- AA tablespace
- BA table
- CThe database
- DA transaction
- EThe instance
64Which of the following lock modes permits concurrent queries on a table but prohibits
updates to the locked table?- AROW SHARE
- BROW EXCLUSIVE
- CSHARE ROW EXCLUSIVE
- DAll of the above
65Select the statement that is not true regarding undo tablespaces
- AUndo tablespaces will not be created if they are not specified in the CREATE
DATABASE command. - BTwo undo tablespaces can be active if a new undo tablespace was specified and the
old one contains pending transactions - CYou can switch from one undo tablespace to another while the database is online
- DUNDO_MANAGEMENT cannot be changed dynamically while the instance is running.
- AUndo tablespaces will not be created if they are not specified in the CREATE
66To resolve a lock conflict, which of the following methods can you use? Choose all
that apply.- AOracle automatically resolves the lock after a short but predefined time period by
killing the session that is holding the lock. - BThe DBA can kill the session holding the lock.
- CThe user can either roll back or commit the transaction that is holding the lock.
- DOracle automatically resolves the lock after a short but predefined period by killing
the session that is requesting the lock.
- AOracle automatically resolves the lock after a short but predefined time period by
67Two transactions occur at the wall clock times in the following table. What happens
at 10:05?
- ASession 2 will wait for session 1 to commit or roll back.
- BSession 1 will wait for session 2 to commit or roll back
- CA deadlock will occur, and both sessions will hang unless one of the users cancels
their statement or the DBA kills one of the sessions. - DA deadlock will occur, and Oracle will cancel one of the statements.
- ENeither session is updating the same column, so no waiting or deadlock will occur
Información
- Descripción
- WIP
- Autor
- David Jimenez
- Idioma
- Español
- Visitas
- 167
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test