Question 1

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

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,C,F

Question 2

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,C

Question 3

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

technology databases

Control file
Extent
Segment
Data file
Log file
Tablespace

Answer

Correct Option: A,D,E

Question 4

What file will give you Oracle instance status information?

technology databases

alert.ora
init.ora
tnsname.ora
redolog

Answer

Correct Option: A

Question 5

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: C,D,E

Question 6

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,C,D

Question 7

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,E

Question 8

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,C

Question 9

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,D

Question 10

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,D

Question 11

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,B,C

Question 12

what is true regarding the role Oracle Net provides in a client server connection with no middle tier? (Choose two)

technology databases

Oracle Net is layered on top of the network protocol.
Oracle Net must reside on both the client and the server for peer-to-peer communication to occur.
On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests.
On the server side, Oracle Net is responsible for several connectivity issues such as : the location of the server, whatever one or more protocol is involved in the connection, and how to handle exception and interrupts.

Answer

Correct Option: A,B

Question 13

Which of the following data type is newly added in DB2 version 9?

technology databases

BLOB
GRAPHIC
XML
ROWID

Answer

Correct Option: C

Question 14

Which type of index is used to control the physical sequence of data in table?

technology databases

Partitioning Index
Clustering Index
Unique Index
Non-partitioning Secondary Index

Answer

Correct Option: B

Question 15

What type of database object does the following DDL statement creates CREATE TEST VOLUMES(ABCD1,ABCD2,ABCD3) VCAT dsn1

technology databases

Tablespace
Storage group
Index
View

Answer

Correct Option: B

Question 16

Pick the odd one out

technology databases

PLAN_TABLE
EMPLOYEE_MASTER
DSN_STATEMNT_TABLE
SYSTABLES

Answer

Correct Option: D

Question 17

Maximum size of buffer pool page size

technology databases

32K
16K
64K
8K

Answer

Correct Option: A

Question 18

Which of the following statement is used for executing dynamic SQL

technology databases

EXEC SQL
EXECUTE IMMEDIATE
DECLARE CURSOR
OPEN

Answer

Correct Option: B

Question 19

XQuery is used to retrieve what type of data?

technology databases

LOB
XML
Image
Video

Answer

Correct Option: B

Question 20

Which of the following utility is recommended after REORG is performed on tablespaces?

technology databases

Recover
Repair
Rebuild
Runstats

Answer

Correct Option: D

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

databases Online Quiz - 136

Find more quizzes from top tags