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

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?

  1. 120

  2. 140

  3. 144

  4. 240

  5. 400


Correct Option: C

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

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

  1. default tablespace

  2. profile

  3. idle_time

  4. default role


Correct Option: C

AI Explanation

To answer this question, we need to understand the different parameters that can be defined when creating a new user in a database.

Option A) default tablespace - This option is defined at user creation. The default tablespace specifies the tablespace where the user's objects will be created by default.

Option B) profile - This option is defined at user creation. A profile is a set of parameters that define the resource limits and password management rules for a user.

Option C) idle_time - This option is NOT defined at user creation. The idle_time parameter is used to specify the maximum number of minutes of inactivity allowed before the user's session is terminated. This parameter is typically set after user creation to define session timeout rules.

Option D) default role - This option is defined at user creation. The default role specifies the roles that are automatically enabled for the user when they log in.

The correct answer is C) idle_time. This option is not defined at user creation.

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

The DBWR process is NOT responsible for:

  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) { String s1=new String("TCS"); String s2=s1; System.out.println(s1==s2); System.out.println(s1.equals(s2)); } } What is the Result?

  1. true true

  2. true false

  3. false true

  4. Exception


Correct Option: A

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

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?

  1. false true

  2. false false

  3. true false

  4. true true


Correct Option: B

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?

  1. false true

  2. false false

  3. true true

  4. true false


Correct Option: C

What is default event in ABAP program events?

  1. Initialization

  2. Start of Selection.

  3. At Selection-screen output

  4. At Selection-screen.


Correct Option: B
  1. Start-of- selection

  2. top-of -page

  3. End-of- Selection.

  4. End- of- page


Correct Option: C

What is system variable to handle the function codes?

  1. SY-INDEX

  2. SY-UCOMM

  3. SY-FDPOS

  4. SY-STEPL


Correct Option: B

Which is control break statement?

  1. AT LAST

  2. AT TOP

  3. AT NEW OF

  4. AT END


Correct Option: A

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

  1. 10

  2. Syntax error

  3. Short dump

  4. No Value


Correct Option: C
- Hide questions