databases Online Quiz - 52

Description: databases Online Quiz - 52
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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

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

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
  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

What tool should you recommend for a junior DBA to use to create a simple backup strategy for a SQL Server database?

  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface

Correct Option: C

You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use in SQL Server?

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Correct Option: D
  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
  1. Process control Block

  2. Program Control Block

  3. Program Communication Block

  4. Process Communication Block

Correct Option: C

If any higher-level segements is retrieved during IMS seqential retrieval it is indicated by which one of the following status code

  1. GA

  2. GD

  3. GK

  4. GB

Correct Option: A

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