Question 1

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

technology databases

8
2
3
4

Answer

Correct Option: C

Question 2

. Visual Studio 2010 supports the development of applications using the following frameworks (Select All that apply):

technology databases

.NET 2.0
.NET 3.0
.NET 3.5
All of the above

Answer

Correct Option: D

Question 3

Which is not a collection type in VB.NET?

technology databases

Hashtable
ArrayList
Stack
Heap

Answer

Correct Option: D

Question 4

Which class is optimized for key-based item retrieval for both small and large collections:

technology databases

OrderedDictionary class
ListDictionary class
HybridDictionary class
Hashtable class

AI Explanation

AI 1

To answer this question, you need to understand the characteristics and performance considerations of different classes in .NET for key-based item retrieval.

Option A) OrderedDictionary class - This class maintains the insertion order of its elements. While it allows key-based retrieval, it is not optimized for performance in terms of large collections. The time complexity for key-based retrieval is O(n) because it searches through the collection linearly.

Option B) ListDictionary class - This class is optimized for small collections. It uses a simple list-based approach for storing key-value pairs. While it allows key-based retrieval, it is not efficient for large collections. The time complexity for key-based retrieval is O(n) because it searches through the collection linearly.

Option C) HybridDictionary class - This class is optimized for both small and large collections. It internally uses different data structures based on the size of the collection. For small collections, it uses a ListDictionary, and for large collections, it switches to a Hashtable. The time complexity for key-based retrieval is O(1) for large collections and O(n) for small collections.

Option D) Hashtable class - This class is optimized for key-based retrieval in large collections. It uses a hash table data structure, which provides constant-time (O(1)) performance for key-based retrieval. It is efficient for both small and large collections.

The correct answer is Option C) HybridDictionary class. This class is optimized for key-based item retrieval for both small and large collections. It internally uses different data structures based on the collection size, providing efficient retrieval performance.

Answer

Correct Option: C

Question 5

You have a Dataset object names dsOrg that includes a table named Users. The Users table includes a column names IsEmployee. How to bind this IsEmployee column to the Checked property of a check box named chkIsEmployee

technology databases

Me.DataBindings.Add(“chkIsEmployee.Checked”, dsOrg, “Users.IsEmployee”)
chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “IsEmployee”)
chkIsEmployee.Text = “{Users.IsEmployee}” chkIsEmployee.AutoCheck = True
chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “Users.IsEmployee”)

Answer

Correct Option: D

Question 6

. User Authentication most suitable in IntrAnet scenario

technology databases

Forms Authentication
Passport Authentication
Windows Authentication
none of the above

Answer

Correct Option: C

Question 7

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 Maintenance Plan Wizard
Database Engine Tuning Advisor
SQL Server Configuration Manager
Database Maintenance design surface

Answer

Correct Option: A

Question 8

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 9

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 10

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 11

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_optimizer_info dynamic management view
Use the sys.dm_exec_query_stats dynamic management view

Answer

Correct Option: D

Question 12

Select the WCF Binding suitable for Ajax Clients

technology databases

basicHttpBinding
wsHttpBindging
webHttpBinding
All of the above

Answer

Correct Option: C

Question 13

What is serialization of a object?

technology databases

Writing the object to a Stream
Reading the Object from a Stream
Adding the Object to a collection
All of the above

Answer

Correct Option: A

Question 14

Which of the following statement about CICS is not true?

technology databases

It supports Multithreading
It waits until a large number of tasks are collected for a schedule run
It supports Multitasking
It was developed to enable terminal users to access programs to perform online processing

Answer

Correct Option: C

Question 15

Which of the following tables contains a list of all valid transaction identifiers and their associated Programs for CICS?

technology databases

Temporary Storage Table (TST)
Program Processing Table (PPT)
Program Control Table (PCT)
File Control Table (FCT)

Answer

Correct Option: C

Question 16

Relationship between WCF LOB Adapter SDK & WCF Channel Model:

technology databases

WCF LOB Adapter SDK is independent of WCF Channel Model
WCF Channel Model built on top of WCF LOB Adapter SDK
WCF LOB Adapter SDK built on top of WCF Channel Model
WCF LOB Adapter SDK part of WCF Channel Model

Answer

Correct Option: C

Question 17

Which of the following table contains information about DB2?

technology databases

Temporary Storage Table (TST)
Program Processing Table (PPT)
Resource Control Table (RCT)
File Control Table (FCT)

Answer

Correct Option: C

Question 18

Which of the following statement about BMS is not true?

technology databases

It provides format independence
It is used to create screen maps
It provides device independence
It is an assembler program that formats terminal screens.

Answer

Correct Option: D

Question 19

Which command can be used to disable all the roles including the default roles?

technology databases

Set Role Off
Drop Role All
.Revoke Role All
Set Role None

Answer

Correct Option: B

Question 20

Which of the following views provides all the grants on all the objects in the database?

technology databases

DBA_SYS_PRIVS
DBA_COL_PRIVS
DBA_OBJ_PRIVS
DBA_TAB_PRIVS

Answer

Correct Option: A

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

databases Online Quiz - 50

AI Explanation

Find more quizzes from top tags