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

Discarding redo logs is done with which of the following statements?

  1. alter database archivelog;

  2. alter database open resetlogs;

  3. alter database mount exclusive

  4. alter system archive log all


Correct Option: B

The CKPT process is optional; which process assumes these duties if CKPT is not active?

  1. PMON

  2. SMON

  3. ARCH

  4. LGWR


Correct Option: D

Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?

  1. SGA

  2. SQL Area

  3. Library Cache

  4. PGA

  5. Shared Pool


Correct Option: D

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

import java.lang.*; class A { public static void main(String[] args) { String s1=new String("TCS"); String s2="TCS"; System.out.println(s1==s2); System.out.println(s1.equals(s2)); } } What is the Result?

  1. Compile time error

  2. false true

  3. true false

  4. true true


Correct Option: B

import java.lang.*; class A { public static void main(String[] args) { StringBuilder s1="TCS"; String s2=new String("TCS"); System.out.println(s1==s2); System.out.println(s1.equals(s2)); } } What is the Result?

  1. true false

  2. false true

  3. Compile Error

  4. false false


Correct Option: C
  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