Tag: databases

Questions Related to databases

A user is running a long update batch file. Many tables are updated and all the statements are in one transaction. Before the process is finished, the user machine lost power. When the user calls you, what should you do as DBA?
technology databases

  1. Do nothing, the PMON process handles everything.

  2. Shut down the database and restore all the tables the user was updating.

  3. Log in as DBA, clean up the partial updates in those tables, and do another manual backup.

  4. Use LogMiner to find out which records are changed based on the user’s ID, then roll back all those changes.

Show answer
Correct Option: A

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

  1. Check

  2. Unique

  3. Not Null

  4. Primary Key

  5. Foreign Key

Show answer
Correct Option: D

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

  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

Show answer
Correct Option: B,C,F

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

  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

Show answer
Correct Option: A,C

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

  1. Control file

  2. Extent

  3. Segment

  4. Data file

  5. Log file

  6. Tablespace

Show answer
Correct Option: A,D,E

What file will give you Oracle instance status information?

technology databases

  1. alert.ora

  2. init.ora

  3. tnsname.ora

  4. redolog

Show answer
Correct Option: A

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

technology databases

  1. Data encryption

  2. User authentication

  3. Transparent data conversion

  4. Configuration and administration mechanisms

  5. Support for multiple network transport protocols

Show answer
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)
technology databases

  1. ABORT

  2. NORMAL

  3. IMMEDIATE

  4. TRANSACTIONAL

Show answer
Correct Option: B,C,D

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

  1. CREATE USER

  2. CREATE SESSION

  3. CREATE ANY TABLE

  4. IMP_FULL_DATABASE

  5. EXP_FULL_DATABASE

Show answer
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)

technology databases

  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.

Show answer
Correct Option: A,C