• databases Online Quiz - 50
Back
0

databases Online Quiz - 50

Description: databases Online Quiz - 50
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

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

  1. 8

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: C

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

technology databases

  1. .NET 2.0

  2. .NET 3.0

  3. .NET 3.5

  4. All of the above

Show answer
Correct Option: D

Which is not a collection type in VB.NET?

technology databases

  1. Hashtable

  2. ArrayList

  3. Stack

  4. Heap

Show answer
Correct Option: D

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

technology databases

  1. OrderedDictionary class

  2. ListDictionary class

  3. HybridDictionary class

  4. Hashtable class

Show answer
Correct Option: C

AI Explanation

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.

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

  1. Me.DataBindings.Add(“chkIsEmployee.Checked”, dsOrg, “Users.IsEmployee”)

  2. chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “IsEmployee”)

  3. chkIsEmployee.Text = “{Users.IsEmployee}” chkIsEmployee.AutoCheck = True

  4. chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “Users.IsEmployee”)

Show answer
Correct Option: D

. User Authentication most suitable in IntrAnet scenario

technology databases

  1. Forms Authentication

  2. Passport Authentication

  3. Windows Authentication

  4. none of the above

Show answer
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?

technology databases

  1. Database Maintenance Plan Wizard

  2. Database Engine Tuning Advisor

  3. SQL Server Configuration Manager

  4. Database Maintenance design surface

Show answer
Correct Option: A

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

  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

Show answer
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?

technology databases

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Show answer
Correct Option: D

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

  1. Read Committed

  2. Read Uncommitted

  3. Repeatable Read

  4. Serializable

Show answer
Correct Option: B

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

  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_optimizer_info dynamic management view

  4. Use the sys.dm_exec_query_stats dynamic management view

Show answer
Correct Option: D

Select the WCF Binding suitable for Ajax Clients

technology databases

  1. basicHttpBinding

  2. wsHttpBindging

  3. webHttpBinding

  4. All of the above

Show answer
Correct Option: C

What is serialization of a object?
technology databases

  1. Writing the object to a Stream

  2. Reading the Object from a Stream

  3. Adding the Object to a collection

  4. All of the above

Show answer
Correct Option: A

Which of the following statement about CICS is not true?

technology databases

  1. It supports Multithreading

  2. It waits until a large number of tasks are collected for a schedule run

  3. It supports Multitasking

  4. It was developed to enable terminal users to access programs to perform online processing

Show answer
Correct Option: C

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

technology databases

  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Program Control Table (PCT)

  4. File Control Table (FCT)

Show answer
Correct Option: C

Relationship between WCF LOB Adapter SDK & WCF Channel Model:

technology databases

  1. WCF LOB Adapter SDK is independent of WCF Channel Model

  2. WCF Channel Model built on top of WCF LOB Adapter SDK

  3. WCF LOB Adapter SDK built on top of WCF Channel Model

  4. WCF LOB Adapter SDK part of WCF Channel Model

Show answer
Correct Option: C

Which of the following table contains information about DB2?
technology databases

  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Resource Control Table (RCT)

  4. File Control Table (FCT)

Show answer
Correct Option: C

Which of the following statement about BMS is not true?

technology databases

  1. It provides format independence

  2. It is used to create screen maps

  3. It provides device independence

  4. It is an assembler program that formats terminal screens.

Show answer
Correct Option: D

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

  1. Set Role Off

  2. Drop Role All

  3. .Revoke Role All

  4. Set Role None

Show answer
Correct Option: B

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

technology databases

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1132 Quizzes
13047 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions