Tag: databases

Questions Related to databases

What types of indexes are supported by SQL Server 2005?

technology databases

  1. Clustered and non clustered

  2. Unique

  3. XML index

  4. All the Above

Show answer
Correct Option: D

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

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