Question 1

Which versions of the .NET Framework support Generics?

technology databases

.NET 2.0 and above
.NET 3.0 and above
.NET 3.5 and above
.NET 4.0

Answer

Correct Option: A

Question 2

Which of the following is not a method of a Connection Object in VB.NET?

technology databases

Open
Begin Transaction
Execute
Commit Transaction

Answer

Correct Option: C

Question 3

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

technology databases

Primary key access
Access via unique index
Table access by ROWID
Full table scan

Answer

Correct Option: C

Question 4

Which of the following denote methods of HttpServlet class?

technology databases

doGet()
doTrace()
doOptions()
All the Above

Answer

Correct Option: D

Question 5

The process of writing the state of an object to a byte stream is called as

technology databases

Deserialization
Serialization
Interface
None of the Above

Answer

Correct Option: B

Question 6

The 16 bit coding scheme employed in Java programming is

technology databases

EDCDIC
UNICODE
ASCII
Hexadecimal

Answer

Correct Option: B

Question 7

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

technology databases

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

Answer

Correct Option: C

Question 8

You write a 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 9

Each occurrence of the IMS root segment plus all the segment occurrences that are subordinate to it, make up a

technology databases

A)Twin Segment
B)Segement type
C)Database record
D)Path

Answer

Correct Option: C

Question 10

What is the maximum no of of levels a DL/I database can have?

technology databases

15
16
255
49

Answer

Correct Option: A

Question 11

What does PCB stands for in IMS?

technology databases

A)Process control Block
B)Program Control Block
C)Program Communication Block
D)Process Communication Block

Answer

Correct Option: C

Question 12

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

technology databases

A)II
B)AI
C)IX
D)AJ

Answer

Correct Option: A

Question 13

Which one of the following describes the physical structure of an IMS database

technology databases

A)PSB
B)DBD
C)ACB
D)DBDGEN

Answer

Correct Option: B

Question 14

How can a blocking process be killed?

technology databases

Find the process in System Monitor and select Kill Process.
Find the process in Activity Monitor and select Kill Process.
Find the process in SQL Profiler and select Kill Process.
Find the process in SSRS and select Kill Process.

Answer

Correct Option: B

Question 15

You are creating a custom dictionary. Which code segment makes sure that the dictionary is type safe

technology databases

Class MyDictionary Implements Dictionary(Of String, String)
Class MyDictionary Inherits HashTable
Class MyDictionary Implements IDictionary
Class MyDictionary End Class Dim t As New Dictionary(Of String, String) Dim dict As MyDictionary = CType(t, MyDictionary)

Answer

Correct Option: A

Question 16

You are developing a Web application that restricts access to the pages based on the Users credentials. Which of the following options enable IIS to supply the user’s Windows credentials to the Web application?

technology databases

A. Enable Anonymous access. Enable Integrated Windows authentication.
B. Enable Anonymous access. Enable Basic authentication
C. Disable Anonymous access. Enable Integrated Windows authentication.
D. Disable Anonymous access. Enable Basic authentication

Answer

Correct Option: C

Question 17

What was a problem with navigational data access languages?

technology databases

The user had to have knowledge of the table and index structures.
Navigational data access was far slower than declarative access.
Navigational access languages required the coder to embed their queries inside a procedural language shell.
Navigational languages were far slower then SQL

Answer

Correct Option: A

Question 18

Which is a major problem with SQL?

technology databases

SQL cannot support object-orientation
The same query can be written in many ways, each with vastly different execution plans.
SQL syntax is too difficult for non-computer professionals to use
SQL creates excessive locks within the database

Answer

Correct Option: B

Question 19

You want to identify the top 10 queries 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 20

In Web Farm scenarios, which Encryption provider is suitable for encrypting data in configuration files:

technology databases

DPAPI
RSA
Both
None of the Above

Answer

Correct Option: B

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

databases Online Quiz - 53

Find more quizzes from top tags