Tag: databases

Questions Related to databases

The association between a URL pattern and a servlet is called as
technology databases

  1. ServletContext

  2. Servlet mapping

  3. Lifecycle

  4. None of the Above

Show answer
Correct Option: B

Which of the following is not a online facilities provided by CICS?
technology databases

  1. Transaction Management

  2. Batch Processing

  3. Queue Management

  4. Interval Control

Show answer
Correct Option: B

What tool should you recommend for a junior DBA to use to create a simple backup strategy for a database?

technology databases

  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface

Show answer
Correct Option: C

You write a 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

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

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

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

A data warehouse is which of the following?
technology databases

  1. Can be updated by end users.

  2. Contains numerous naming conventions and formats.

  3. Organized around important subject areas.

  4. Contains only current data.

Show answer
Correct Option: C

An operational system is which of the following?

technology databases

  1. A system that is used to run the business in real time and is based on historical data.

  2. A system that is used to run the business in real time and is based on current data.

  3. A system that is used to support decision making and is based on current data.

  4. A system that is used to support decision making and is based on historical data.

Show answer
Correct Option: B

What must be implemented by all Servlets?

technology databases

  1. Servlet Interface

  2. servlet mapping

  3. Servlet Container

  4. None of the Above

Show answer
Correct Option: A