Question 1

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

technology databases

Servlets are built on JSP semantics and all servlets are compiled to JSP pages for runtime usage.
JSPs are built on servlet semantics and all JSPs are compiled to servlets for runtime usage.
JSP and servlets are unrelated technologies.
None of the Above

Answer

Correct Option: B

Question 2

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

technology databases

Message
StackTrace
Source
Line number

Answer

Correct Option: B

Question 3

If a Runtime Exception is thrown in the finalize method

technology databases

The running application crashes`
The exception is simply ignored and the object is garbage collected
The exception is simply ignored, but the object is not garbage collected
If a Runtime Exception is thrown in the finalize method

Answer

Correct Option: B

Question 4

Choose the correct statement from the given choice?

technology databases

Arrays in Java are essentially objects
It is not possible to assign one array to another. Individual elements of array can however be assigned.
Array elements are indexed from 1 to size of array
If a method tries to access an array element beyond its range, a compile warning is generated.

Answer

Correct Option: A

Question 5

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

technology databases

–e
–pe
-enc
All of the Above

Answer

Correct Option: B

Question 6

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

technology databases

*
/
-
=

Answer

Correct Option: C

Question 7

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

technology databases

INSTR
SUBSTRING
SUBSTR
POS

Answer

Correct Option: C

Question 8

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

technology databases

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

Answer

Correct Option: A

Question 9

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

technology databases

The DLI call did specify a segment I/O area
The function code field specified for the DLI call contains an incorrect value
The DLI call attempted to perform an operation which is not authorised by processing option specified in the PCB
The DLI call specifies an invalid SSA.

Answer

Correct Option: C

Question 10

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

technology databases

PCBGEN
PSBGEN
DBDGEN
ACBGEN

Answer

Correct Option: B

Question 11

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

technology databases

Database Engine Tuning Advisor
SQL Server Configuration Manager
Database Maintenance Plan Wizard
Database Maintenance design surface

Answer

Correct Option: C

Question 12

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?

technology databases

DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)
DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)
DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY
DBCC CHECKDB ('SalesDB') WITH DATA_PURITY

Answer

Correct Option: C

Question 13

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?

technology databases

Transactional replication
Peer-to-peer replication
Merge replication
Snapshot replication

Answer

Correct Option: D

Question 14

You write a SQL Server stored procedure that will return data for a report. The accuracy of the data is not so important; however, you want to avoid dirty reads. Which isolation level should you avoid?

technology databases

Read Committed
Read Uncommitted
Repeatable Read
Serializable

Answer

Correct Option: B

Question 15

You want to identify the top 10 queries in SQL Server that have been recompiled the most times on your server. What can you do?

technology databases

Use the sys.dm_exec_requests dynamic management view.
Use the sys.dm_exec_sessions dynamic management view
Use the sys.dm_exec_query_stats dynamic management view
Use the sys.dm_exec_query_optimizer_info dynamic management view

Answer

Correct Option: C

Question 16

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

technology databases

System tablespace
Users tablespace
Default tablespace for the user
Default tablespace for system

Answer

Correct Option: C

Question 17

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;

technology databases

36724
36717
36719
36718

Answer

Correct Option: A

Question 18

What does PCB stands for in IMS?

technology databases

Process control Block
Program Control Block
Program Communication Block
Process Communication Block

Answer

Correct Option: C

Question 19

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

technology databases

GA
GD
GK
GB

Answer

Correct Option: A

Question 20

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

technology databases

II
AI
IX
AJ

Answer

Correct Option: A

Description: databases Online Quiz - 52
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 52

Find more quizzes from top tags