Question 1

Which three are the physical structures that constiture the Oracle database ? (Choose Three)

Control file
Extent
Segment
Data file
Log file
Tablespace

Answer

Correct Option: D

Question 2

You plan to take a closed database backup using operating system commands. Which three SHUTDOWN options are appropriate for this type of backup? (Choose three)

technology databases

ABORT
NORMAL
IMMEDIATE
TRANSACTIONAL

Answer

Correct Option: B

Question 3

Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined? (Choose three)

technology databases

TARGET_REDO_BLKS
FAST_START_IO_TARGET
LOG_CHECKPOINT_TIMEOUT
RECOVERY_ESTIMATED_IOS
LOG_FILE_SIZE_REDO_BLKS
LOG_CHECKPOINT_INTERVAL

Answer

Correct Option: B

Question 4

When an oracle Instance is started, background process are started. Background processes perform which two functions ? (Choose two)

technology databases

Perform I/O
Lock rows that are not data dictionary rows
Monitor other Oracle processes
Connect users to the Oracle instance
Execute SQL statments issued through an application

Answer

Correct Option: A

Question 5

Which two roles or privileges must you have to export tables owned by another user? (Choose two)

technology databases

CREATE USER
CREATE SESSION
CREATE ANY TABLE
IMP_FULL_DATABASE
EXP_FULL_DATABASE

Answer

Correct Option: B

Question 6

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

technology databases

Oracle Managed Files used for this instance.
The USER_DATA tablespace in managed using FET$/UET$ tables.
The COMPATIBLE intialization paramter must be 9.0.0 or higer.
Space within segments is the USER_DATA tablespace is managed with freelists.

Answer

Correct Option: A

Question 7

The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)

technology databases

Restore the data file and perform incomplete recovery.
Restore the data file and perform point-in-time recover.
Drop the tablespace and lose all data in the tablespace.
Restore the database and lose all data since the last backup.

Answer

Correct Option: C

Question 8

Which two statments regarding the control file and Recover Manager are true ? (Choose two)

technology databases

The control file can grow in size.
The control file can store RMAN scripts.
CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.
The RMAN catalog can exist solely in the control file of the target database.

Answer

Correct Option: C

Question 9

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)

technology databases

SYNC or ASYNC to identify the network transmission mode.
LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.
AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.
PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

Answer

Correct Option: A

Question 10

Which three features are provided by Oracle Net Services? (Choose three)

technology databases

Data encryption
User authentication
Transparent data conversion
Configuration and administration mechanisms
Support for multiple network transport protocols

Answer

Correct Option: A

Question 11

What file will give you Oracle instance status information?

technology databases

alert.ora
init.ora
tnsname.ora
redolog

Answer

Correct Option: A

Question 12

An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?

technology databases

PMON
SMON
RECO
ARCn
CKPT

Answer

Correct Option: B

Question 13

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

technology databases

Extent
Segement
Oracle block
Operating system block

Answer

Correct Option: A

Question 14

You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are true ?

technology databases

Check
Unique
Not Null
Primary Key
Foreign Key

Answer

Correct Option: D

Question 15

Which statement is ture regarding checkpoints and recovery ?

technology databases

A checkpoint defines the highest system change number (SCN)
All redo entries higher or at the SCN are known to be written to the data files.
Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.

Answer

Correct Option: C

Question 16

What should you look at to compute the number of undo blocks written per second on disk ?

technology databases

V$UNDOSTAT
V$TRANSACTION
V$ROLLSTAT
DBA_UNDO_EXTENTS
DBA_ROLLBACK_SEGS

Answer

Correct Option: A

Question 17

Which background process reads the redo log buffer and writes it to a file ?

technology databases

ARCn
DBWn
CKPT
LGWR
PMON
SMON

Answer

Correct Option: D

Question 18

In user-managed backup and recover procedure, how are data files backed up ?

technology databases

Using SQL commands.
Using SQL*Plus Commands.
Using operating system commands.
Using Recover Manager commands.

Answer

Correct Option: C

Question 19

Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?

technology databases

Backups will never expire.
It removes any retention policy.
The DELETE OBSOLETE command will fail with an error.
It sets the retention policy to the default of REDUNDANCY 1.

Answer

Correct Option: D

Question 20

You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START Starting /mstgelai/oracle/bin/tnslsnr: please wait... System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to... The command completed successfully What is the name of the Listener you started?

technology databases

TNSLSNR
LISTENER
LOCAL_LISTENER
DEFAULT_LSRN

Answer

Correct Option: B

Description: databases Online Quiz - 168
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 168

Find more quizzes from top tags