Question 1

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

technology programming languages

alter database archivelog;
alter database open resetlogs;
alter database mount exclusive
alter system archive log all

Answer

Correct Option: B

Question 2

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

technology programming languages

PMON
SMON
ARCH
LGWR

Answer

Correct Option: D

Question 3

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

technology programming languages

SGA
SQL Area
Library Cache
PGA
Shared Pool

Answer

Correct Option: D

Question 4

The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREASE=20. If the first 3 extents are filled, what will the size of the FOURTH extent be?

technology programming languages

120
140
144
240
400

Answer

Correct Option: C

Question 5

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?

technology programming languages

audit
quota
limit
profile

Answer

Correct Option: D

Question 6

The DBA is creating a new user. Which of the following is NOT defined at user creation

technology programming languages

default tablespace
profile
idle_time
default role

Answer

Correct Option: C

Question 7

Which command will cause an automatic commit to occur?

technology programming languages

CONNECT
RENAME
SELECT
INSERT
DELETE

Answer

Correct Option: B

Question 8

Which Oracle background process is responsible for coalescing free space?

technology programming languages

PMON
SMON
ARCH
LGWR

Answer

Correct Option: B

Question 9

The DBWR process is NOT responsible for:

technology programming languages

Defers writes for I/O optimization
Uses a LRU algorithm to keep most recently used blocks in memory
Writes to database redo log files as people COMMIT data
Writes all changed (i.e. dirty) buffers to datafiles

Answer

Correct Option: C

Question 10

Which statement about the LGWR is false?

technology programming languages

There is only one redo log writer per instance
A commit confirmation may be issued before a transaction has been recorded in the redo log file
During long transactions Oracle can flush data to the redo logs before it is committed
An Oracle instance cannot survive without a redo log writer

Answer

Correct Option: B

Question 11

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?

technology programming languages

Compile time error
false true
true false
true true

Answer

Correct Option: B

Question 12

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

technology programming languages

true true
true false
false true
Exception

Answer

Correct Option: A

Question 13

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?

technology programming languages

true false
false true
Compile Error
false false

Answer

Correct Option: C

Question 14

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

technology programming languages

false true
false false
true false
true true

Answer

Correct Option: B

Question 15

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

technology programming languages

false true
false false
true true
true false

Answer

Correct Option: C

Question 16

What is default event in ABAP program events?

technology programming languages

Initialization
Start of Selection.
At Selection-screen output
At Selection-screen.

Answer

Correct Option: B

Question 17

Which event will trigger if program finds STOP statement

technology programming languages

Start-of- selection
top-of -page
End-of- Selection.
End- of- page

Answer

Correct Option: C

Question 18

What is system variable to handle the function codes?

technology programming languages

SY-INDEX
SY-UCOMM
SY-FDPOS
SY-STEPL

Answer

Correct Option: B

Question 19

Which is control break statement?

technology programming languages

AT LAST
AT TOP
AT NEW OF
AT END

Answer

Correct Option: A

Question 20

What is output of the this code? REPORT ZTEST. field-symbols: type c. = '10'. write:/ .

technology programming languages

10
Syntax error
Short dump
No Value

Answer

Correct Option: C

Description: programming languages Online Quiz - 181
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: programming languages

programming languages Online Quiz - 181

Find more quizzes from top tags