0

databases Online Quiz - 50

Description: databases Online Quiz - 50
Number of Questions: 20
Created by:
Tags: databases
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?

  1. 8

  2. 2

  3. 3

  4. 4


Correct Option: C
  1. Hashtable

  2. ArrayList

  3. Stack

  4. Heap


Correct Option: D

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

  1. OrderedDictionary class

  2. ListDictionary class

  3. HybridDictionary class

  4. Hashtable class


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

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


Correct Option: D

. User Authentication most suitable in IntrAnet scenario

  1. Forms Authentication

  2. Passport Authentication

  3. Windows Authentication

  4. none of the above


Correct Option: C
  1. Database Maintenance Plan Wizard

  2. Database Engine Tuning Advisor

  3. SQL Server Configuration Manager

  4. Database Maintenance design surface


Correct Option: A

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

  4. Use the sys.dm_exec_query_stats dynamic management view


Correct Option: D

Select the WCF Binding suitable for Ajax Clients

  1. basicHttpBinding

  2. wsHttpBindging

  3. webHttpBinding

  4. All of the above


Correct Option: C

What is serialization of a object?

  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


Correct Option: A
  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


Correct Option: C

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

  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Program Control Table (PCT)

  4. File Control Table (FCT)


Correct Option: C
  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


Correct Option: C
  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Resource Control Table (RCT)

  4. File Control Table (FCT)


Correct Option: C
  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.


Correct Option: D
  1. Set Role Off

  2. Drop Role All

  3. .Revoke Role All

  4. Set Role None


Correct Option: B

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

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS


Correct Option: A
- Hide questions