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
  1. character streams

  2. byte streams

  3. Both (A) and (B)

  4. None of the Above


Correct Option: C

In order to initialize a servlet the initialization code is placed in

  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

Which of the following are valid table-partitioning methods

  1. Key based

  2. Freelist

  3. Hash

  4. Index


Correct Option: C

Which two parameters can be set to tell the Oracle to use OMF (Oracle Managed Files)?

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST


Correct Option: A

User-defined application exception classes are derived from which class?

  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
  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

When you add a float, int and byte the result will be

  1. float

  2. int

  3. byte

  4. double


Correct Option: A

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.

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

  1. Transaction Management

  2. Batch Processing

  3. Queue Management

  4. Interval Control


Correct Option: B

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

  1. Database Engine Tuning Advisor

  2. SQL Server Configuration Manager

  3. Database Maintenance Plan Wizard

  4. Database Maintenance design surface


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?

  1. Read Committed

  2. Read Uncommitted

  3. Repeatable Read

  4. Serializable


Correct Option: B

How can a blocking process be killed?

  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

A data warehouse is which of the following?

  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

An operational system is which of the following?

  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

What must be implemented by all Servlets?

  1. Servlet Interface

  2. servlet mapping

  3. Servlet Container

  4. None of the Above


Correct Option: A
  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