0

databases Online Quiz - 49

Description: databases Online Quiz - 49
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which of the following denote the type of streams used in Java?

  1. character streams

  2. byte streams

  3. Both (A) and (B)

  4. None of the Above


Correct Option: C
  1. service() method

  2. init() method

  3. constructor for HttpServlet()

  4. None of the Above


Correct Option: B
  1. out is a PrintStream object

  2. Java support pointers

  3. AWT components are heavy-weight

  4. An abstract class has to be sub-classed


Correct Option: B
  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST


Correct Option: A
  1. SystemException

  2. ApplicationException

  3. Both (A) and (B)

  4. None of the Above


Correct Option: B

Which is Microsoft’s open source project hosting web site?

  1. CodeSite

  2. CodePlex

  3. A & B

  4. None of the Above


Correct Option: B

What is one of the disadvantages of database mirroring?

  1. You need to have the same hardware.

  2. The database you mirror to will be in an unused standby state.

  3. You cannot have automatic failover.

  4. You need to have at minimum three servers.


Correct Option: B

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

  1. ServletContext

  2. Servlet mapping

  3. Lifecycle

  4. None of the Above


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.

  1. Transaction Management

  2. Batch Processing

  3. Queue Management

  4. Interval Control


Correct Option: B
  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface


Correct Option: C
  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.


Correct Option: B

What was a problem with navigational data access languages?

  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


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?

  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.


Correct Option: C
  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.


Correct Option: C
  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.


Correct Option: B
  1. Servlet Interface

  2. servlet mapping

  3. Servlet Container

  4. None of the Above


Correct Option: A

Where do sync points occur in a Transaction?

  1. At the beginning

  2. At the end

  3. Where they are programmed

  4. After each READ FOR UPDATE command


Correct Option: D
- Hide questions