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

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