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

AI Explanation

To answer this question, you need to understand the concept of servlet mapping.

Option A) ServletContext - This option is incorrect because ServletContext refers to the interface that represents the servlet's view of the web application. It provides information about the web application and allows the servlet to interact with its environment.

Option B) Servlet mapping - This option is correct because the association between a URL pattern and a servlet is called servlet mapping. Servlet mapping is defined in the web.xml file or using annotations in the servlet class. It specifies which servlet should handle requests with specific URL patterns.

Option C) Lifecycle - This option is incorrect because the lifecycle of a servlet refers to the series of steps that a servlet goes through from its instantiation to its destruction. It includes methods like init(), service(), and destroy().

Option D) None of the Above - This option is incorrect because option B, servlet mapping, is the correct answer.

The correct answer is B) Servlet mapping. This option is correct because it accurately describes the association between a URL pattern and a servlet.

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