Tag: databases

Questions Related to databases

What is the maximum no of of levels a DL/I database can have?
technology databases

  1. 15

  2. 16

  3. 255

  4. 49

Show answer
Correct Option: A

What does PCB stands for in IMS?
technology databases

  1. A)Process control Block

  2. B)Program Control Block

  3. C)Program Communication Block

  4. D)Process Communication Block

Show answer
Correct Option: C

Which one of the following status code indicates a duplicate insertion of a segment in IMS
technology databases

  1. A)II

  2. B)AI

  3. C)IX

  4. D)AJ

Show answer
Correct Option: A

Which one of the following describes the physical structure of an IMS database

technology databases

  1. A)PSB

  2. B)DBD

  3. C)ACB

  4. D)DBDGEN

Show answer
Correct Option: B

How can a blocking process be killed?
technology databases

  1. Find the process in System Monitor and select Kill Process.

  2. Find the process in Activity Monitor and select Kill Process.

  3. Find the process in SQL Profiler and select Kill Process.

  4. Find the process in SSRS and select Kill Process.

Show answer
Correct Option: B

You are creating a custom dictionary. Which code segment makes sure that the dictionary is type safe
technology databases

  1. Class MyDictionary Implements Dictionary(Of String, String)

  2. Class MyDictionary Inherits HashTable

  3. Class MyDictionary Implements IDictionary

  4. Class MyDictionary End Class Dim t As New Dictionary(Of String, String) Dim dict As MyDictionary = CType(t, MyDictionary)

Show answer
Correct Option: A

You are developing a Web application that restricts access to the pages based on the Users credentials. Which of the following options enable IIS to supply the user’s Windows credentials to the Web application?
technology databases

  1. A. Enable Anonymous access. Enable Integrated Windows authentication.

  2. B. Enable Anonymous access. Enable Basic authentication

  3. C. Disable Anonymous access. Enable Integrated Windows authentication.

  4. D. Disable Anonymous access. Enable Basic authentication

Show answer
Correct Option: C

What was a problem with navigational data access languages?

technology databases

  1. The user had to have knowledge of the table and index structures.

  2. Navigational data access was far slower than declarative access.

  3. Navigational access languages required the coder to embed their queries inside a procedural language shell.

  4. Navigational languages were far slower then SQL

Show answer
Correct Option: A

Which is a major problem with SQL?
technology databases

  1. SQL cannot support object-orientation

  2. The same query can be written in many ways, each with vastly different execution plans.

  3. SQL syntax is too difficult for non-computer professionals to use

  4. SQL creates excessive locks within the database

Show answer
Correct Option: B

You want to identify the top 10 queries 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_stats dynamic management view.

  4. Use the sys.dm_exec_query_optimizer_info dynamic management view.

Show answer
Correct Option: C