0

databases Online Quiz - 52

Description: databases Online Quiz - 52
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Choose the best statement that best describes the relationship between JSP and servlets

  1. Servlets are built on JSP semantics and all servlets are compiled to JSP pages for runtime usage.

  2. JSPs are built on servlet semantics and all JSPs are compiled to servlets for runtime usage.

  3. JSP and servlets are unrelated technologies.

  4. None of the Above


Correct Option: B

Which property of Exception class provides the line number of the code that caused exception:

  1. Message

  2. StackTrace

  3. Source

  4. Line number


Correct Option: B

If a Runtime Exception is thrown in the finalize method

  1. The running application crashes`

  2. The exception is simply ignored and the object is garbage collected

  3. The exception is simply ignored, but the object is not garbage collected

  4. If a Runtime Exception is thrown in the finalize method


Correct Option: B

Choose the correct statement from the given choice?

  1. Arrays in Java are essentially objects

  2. It is not possible to assign one array to another. Individual elements of array can however be assigned.

  3. Array elements are indexed from 1 to size of array

  4. If a method tries to access an array element beyond its range, a compile warning is generated.


Correct Option: A

Which of the following command options of aspnet_regiis is used to encryption config sections?

  1. –e

  2. –pe

  3. -enc

  4. All of the Above


Correct Option: B

Which character is used to continue a statement in SQL*Plus?

  1. *

  2. /

  3. -

  4. =


Correct Option: C

Which character function can be used to return a specified portion of a character string?

  1. INSTR

  2. SUBSTRING

  3. SUBSTR

  4. POS


Correct Option: C

The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?

  1. select * from EMP where nvl(EMPNO, '00000') = '59384';

  2. select * from EMP where EMPNO = '59384';

  3. select EMPNO, LASTNAME from EMP where EMPNO = '59384';

  4. select 1 from EMP where EMPNO = '59834';


Correct Option: A

In which one of the following scenairos the IMS status code AM will be issued

  1. The DLI call did specify a segment I/O area

  2. The function code field specified for the DLI call contains an incorrect value

  3. The DLI call attempted to perform an operation which is not authorised by processing option specified in the PCB

  4. The DLI call specifies an invalid SSA.


Correct Option: C

The process to assemble and link edit the macro instructions that specify an application programs view of one or more databases is called.

  1. PCBGEN

  2. PSBGEN

  3. DBDGEN

  4. ACBGEN


Correct Option: B
  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface


Correct Option: C

You have a 1TB SalesDB database running on SQL Server 2003 Enterprise Edition. You have noticed that the nightly DBCC CHECKDB ('SalesDB') job is starting to take too long, and you want to reduce the amount of time that the check will take. What command should you schedule to run nightly instead?

  1. DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)

  2. DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)

  3. DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY

  4. DBCC CHECKDB ('SalesDB') WITH DATA_PURITY


Correct Option: C
  1. Use the sys.dm_exec_requests dynamic management view.

  2. Use the sys.dm_exec_sessions dynamic management view

  3. Use the sys.dm_exec_query_stats dynamic management view

  4. Use the sys.dm_exec_query_optimizer_info dynamic management view


Correct Option: C

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system


Correct Option: C

Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;

  1. 36724

  2. 36717

  3. 36719

  4. 36718


Correct Option: A
  1. Process control Block

  2. Program Control Block

  3. Program Communication Block

  4. Process Communication Block


Correct Option: C

Which one of the following status code indicates a duplicate insertion of a segment in IMS

  1. II

  2. AI

  3. IX

  4. AJ


Correct Option: A
- Hide questions