0

programming languages Online Quiz - 181

Description: programming languages Online Quiz - 181
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. alter database archivelog;

  2. alter database open resetlogs;

  3. alter database mount exclusive

  4. alter system archive log all


Correct Option: B

Assume the database administrator wanted to limit the amount of idle time that any one user could have during a given session. Which of the following would be used to enforce such a limit?

  1. audit

  2. quota

  3. limit

  4. profile


Correct Option: D

Which command will cause an automatic commit to occur?

  1. CONNECT

  2. RENAME

  3. SELECT

  4. INSERT

  5. DELETE


Correct Option: B

Which Oracle background process is responsible for coalescing free space?

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR


Correct Option: B
  1. Defers writes for I/O optimization

  2. Uses a LRU algorithm to keep most recently used blocks in memory

  3. Writes to database redo log files as people COMMIT data

  4. Writes all changed (i.e. dirty) buffers to datafiles


Correct Option: C

Which statement about the LGWR is false?

  1. There is only one redo log writer per instance

  2. A commit confirmation may be issued before a transaction has been recorded in the redo log file

  3. During long transactions Oracle can flush data to the redo logs before it is committed

  4. An Oracle instance cannot survive without a redo log writer


Correct Option: B
  1. Initialization

  2. Start of Selection.

  3. At Selection-screen output

  4. At Selection-screen.


Correct Option: B

Which event will trigger if program finds STOP statement

  1. Start-of- selection

  2. top-of -page

  3. End-of- Selection.

  4. End- of- page


Correct Option: C
  1. AT LAST

  2. AT TOP

  3. AT NEW OF

  4. AT END


Correct Option: A
- Hide questions