0

databases Online Quiz - 136

Description: databases Online Quiz - 136
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

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

  1. TARGET_REDO_BLKS

  2. FAST_START_IO_TARGET

  3. LOG_CHECKPOINT_TIMEOUT

  4. RECOVERY_ESTIMATED_IOS

  5. LOG_FILE_SIZE_REDO_BLKS

  6. LOG_CHECKPOINT_INTERVAL


Correct Option: B,C,F

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

  1. Perform I/O

  2. Lock rows that are not data dictionary rows

  3. Monitor other Oracle processes

  4. Connect users to the Oracle instance

  5. Execute SQL statments issued through an application


Correct Option: A,C
  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace


Correct Option: A,D,E

What file will give you Oracle instance status information?

  1. alert.ora

  2. init.ora

  3. tnsname.ora

  4. redolog


Correct Option: A
  1. Data encryption

  2. User authentication

  3. Transparent data conversion

  4. Configuration and administration mechanisms

  5. Support for multiple network transport protocols


Correct Option: C,D,E

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)

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL


Correct Option: B,C,D
  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE


Correct Option: B,E

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)

  1. Oracle Managed Files used for this instance.

  2. The USER_DATA tablespace in managed using FET$/UET$ tables.

  3. The COMPATIBLE intialization paramter must be 9.0.0 or higer.

  4. Space within segments is the USER_DATA tablespace is managed with freelists.


Correct Option: A,C
  1. The control file can grow in size.

  2. The control file can store RMAN scripts.

  3. CONTROL_FILE_RECORD_KEEP_TIME determine retention time for RMAN records.

  4. The RMAN catalog can exist solely in the control file of the target database.


Correct Option: C,D

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

  1. Restore the data file and perform incomplete recovery.

  2. Restore the data file and perform point-in-time recover.

  3. Drop the tablespace and lose all data in the tablespace.

  4. Restore the database and lose all data since the last backup.


Correct Option: C,D

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

  1. SYNC or ASYNC to identify the network transmission mode.

  2. LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby.

  3. AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously.

  4. PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.


Correct Option: A,B,C

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

  1. Oracle Net is layered on top of the network protocol.

  2. Oracle Net must reside on both the client and the server for peer-to-peer communication to occur.

  3. On the client side, Oracle Net is responsible for working with the listener to receive incoming connection requests.

  4. 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.


Correct Option: A,B

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

  1. BLOB

  2. GRAPHIC

  3. XML

  4. ROWID


Correct Option: C

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

  1. Partitioning Index

  2. Clustering Index

  3. Unique Index

  4. Non-partitioning Secondary Index


Correct Option: B

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

  1. Tablespace

  2. Storage group

  3. Index

  4. View


Correct Option: B

Pick the odd one out

  1. PLAN_TABLE

  2. EMPLOYEE_MASTER

  3. DSN_STATEMNT_TABLE

  4. SYSTABLES


Correct Option: D

Maximum size of buffer pool page size

  1. 32K

  2. 16K

  3. 64K

  4. 8K


Correct Option: A

Which of the following statement is used for executing dynamic SQL

  1. EXEC SQL

  2. EXECUTE IMMEDIATE

  3. DECLARE CURSOR

  4. OPEN


Correct Option: B

XQuery is used to retrieve what type of data?

  1. LOB

  2. XML

  3. Image

  4. Video


Correct Option: B

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

  1. Recover

  2. Repair

  3. Rebuild

  4. Runstats


Correct Option: D
- Hide questions