• databases Online Quiz - 53
Back
0

databases Online Quiz - 53

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

Which versions of the .NET Framework support Generics?

technology databases

  1. .NET 2.0 and above

  2. .NET 3.0 and above

  3. .NET 3.5 and above

  4. .NET 4.0

Show answer
Correct Option: A

Which of the following is not a method of a Connection Object in VB.NET?

technology databases

  1. Open

  2. Begin Transaction

  3. Execute

  4. Commit Transaction

Show answer
Correct Option: C

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

technology databases

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Show answer
Correct Option: C

Which of the following denote methods of HttpServlet class?

technology databases

  1. doGet()

  2. doTrace()

  3. doOptions()

  4. All the Above

Show answer
Correct Option: D

The process of writing the state of an object to a byte stream is called as

technology databases

  1. Deserialization

  2. Serialization

  3. Interface

  4. None of the Above

Show answer
Correct Option: B

The 16 bit coding scheme employed in Java programming is

technology databases

  1. EDCDIC

  2. UNICODE

  3. ASCII

  4. Hexadecimal

Show answer
Correct Option: B

AI Explanation

To answer this question, you need to understand the 16-bit coding schemes used in Java programming.

Option A) EDCDIC - This option is incorrect because EBCDIC (Extended Binary Coded Decimal Interchange Code) is not a 16-bit coding scheme used in Java programming. EBCDIC is an 8-bit coding scheme used mainly on IBM mainframe computers.

Option B) UNICODE - This option is correct because Unicode is a 16-bit coding scheme used in Java programming. Unicode is a character encoding standard that assigns a unique code point to every character in various scripts and languages.

Option C) ASCII - This option is incorrect because ASCII (American Standard Code for Information Interchange) is a 7-bit coding scheme, not 16-bit. ASCII is widely used in early computer systems and programming languages, but it cannot represent all characters in various scripts and languages.

Option D) Hexadecimal - This option is incorrect because hexadecimal is a numbering system that uses base 16, not a coding scheme. Hexadecimal is commonly used in computer programming to represent binary values in a more human-readable form.

The correct answer is B) UNICODE. This option is correct because Unicode is the 16-bit coding scheme employed in Java programming.

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

Each occurrence of the IMS root segment plus all the segment occurrences that are subordinate to it, make up a

technology databases

  1. A)Twin Segment

  2. B)Segement type

  3. C)Database record

  4. D)Path

Show answer
Correct Option: C

What is the maximum no of of levels a DL/I database can have?

technology databases

  1. 15

  2. 16

  3. 255

  4. 49

Show answer
Correct Option: A

What does PCB stands for in IMS?

technology databases

  1. A)Process control Block

  2. B)Program Control Block

  3. C)Program Communication Block

  4. D)Process Communication Block

Show answer
Correct Option: C

Which one of the following status code indicates a duplicate insertion of a segment in IMS

technology databases

  1. A)II

  2. B)AI

  3. C)IX

  4. D)AJ

Show answer
Correct Option: A

Which one of the following describes the physical structure of an IMS database

technology databases

  1. A)PSB

  2. B)DBD

  3. C)ACB

  4. D)DBDGEN

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

You are creating a custom dictionary. Which code segment makes sure that the dictionary is type safe

technology databases

  1. Class MyDictionary Implements Dictionary(Of String, String)

  2. Class MyDictionary Inherits HashTable

  3. Class MyDictionary Implements IDictionary

  4. Class MyDictionary End Class Dim t As New Dictionary(Of String, String) Dim dict As MyDictionary = CType(t, MyDictionary)

Show answer
Correct Option: A

You are developing a Web application that restricts access to the pages based on the Users credentials. Which of the following options enable IIS to supply the user’s Windows credentials to the Web application?

technology databases

  1. A. Enable Anonymous access. Enable Integrated Windows authentication.

  2. B. Enable Anonymous access. Enable Basic authentication

  3. C. Disable Anonymous access. Enable Integrated Windows authentication.

  4. D. Disable Anonymous access. Enable Basic authentication

Show answer
Correct Option: C

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

Which is a major problem with SQL?

technology databases

  1. SQL cannot support object-orientation

  2. The same query can be written in many ways, each with vastly different execution plans.

  3. SQL syntax is too difficult for non-computer professionals to use

  4. SQL creates excessive locks within the database

Show answer
Correct Option: B

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

In Web Farm scenarios, which Encryption provider is suitable for encrypting data in configuration files:

technology databases

  1. DPAPI

  2. RSA

  3. Both

  4. None of the Above

Show answer
Correct Option: B
- 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