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

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

  1. Read Committed

  2. Read Uncommitted

  3. Repeatable Read

  4. Serializable


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

Which of the following statement about CICS is not true?

  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
  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Program Control Table (PCT)

  4. File Control Table (FCT)


Correct Option: C

Relationship between WCF LOB Adapter SDK & WCF Channel Model:

  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

Which of the following table contains information about DB2?

  1. Temporary Storage Table (TST)

  2. Program Processing Table (PPT)

  3. Resource Control Table (RCT)

  4. File Control Table (FCT)


Correct Option: C

Which of the following statement about BMS is not true?

  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

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

  1. Set Role Off

  2. Drop Role All

  3. .Revoke Role All

  4. Set Role None


Correct Option: B
- Hide questions