• databases Online Quiz - 49
Back
0

databases Online Quiz - 49

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

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

technology databases

  1. character streams

  2. byte streams

  3. Both (A) and (B)

  4. None of the Above

Show answer
Correct Option: C

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

technology databases

  1. service() method

  2. init() method

  3. constructor for HttpServlet()

  4. None of the Above

Show answer
Correct Option: B

Which of the following statement is False?

technology databases

  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

Show answer
Correct Option: B

Which of the following are valid table-partitioning methods

technology databases

  1. Key based

  2. Freelist

  3. Hash

  4. Index

Show answer
Correct Option: C

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

technology databases

  1. DB_CREATE_FILE_DEST

  2. DB_CREATE_ONLINE_LOG_n

  3. USER_DUMP_DEST

  4. LOG_ARCHIVE_DEST

Show answer
Correct Option: A

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

technology databases

  1. SystemException

  2. ApplicationException

  3. Both (A) and (B)

  4. None of the Above

Show answer
Correct Option: B

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

technology databases

  1. CodeSite

  2. CodePlex

  3. A & B

  4. None of the Above

Show answer
Correct Option: B

What is one of the disadvantages of database mirroring?

technology databases

  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.

Show answer
Correct Option: B

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

technology databases

  1. float

  2. int

  3. byte

  4. double

Show answer
Correct Option: A

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

Where do sync points occur in a Transaction?

technology databases

  1. At the beginning

  2. At the end

  3. Where they are programmed

  4. After each READ FOR UPDATE command

Show answer
Correct Option: D
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions