Tag: databases

Questions Related to databases

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