Tag: databases

Questions Related to databases

What best describes the relationship between indexes and SQL performance?

technology databases

  1. Indexes are only used in special cases

  2. Indexes are used to make table storage more efficient

  3. Indexes rarely make a difference in SQL performance

  4. Indexes exist solely to improve query speed.

Show answer
Correct Option: D

To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?

technology databases

  1. 8

  2. 2

  3. 3

  4. 4

Show answer
Correct Option: C

. Visual Studio 2010 supports the development of applications using the following frameworks (Select All that apply):

technology databases

  1. .NET 2.0

  2. .NET 3.0

  3. .NET 3.5

  4. All of the above

Show answer
Correct Option: D

Which is not a collection type in VB.NET?

technology databases

  1. Hashtable

  2. ArrayList

  3. Stack

  4. Heap

Show answer
Correct Option: D

Which class is optimized for key-based item retrieval for both small and large collections:
technology databases

  1. OrderedDictionary class

  2. ListDictionary class

  3. HybridDictionary class

  4. Hashtable class

Show answer
Correct Option: C

You have a Dataset object names dsOrg that includes a table named Users. The Users table includes a column names IsEmployee. How to bind this IsEmployee column to the Checked property of a check box named chkIsEmployee
technology databases

  1. Me.DataBindings.Add(“chkIsEmployee.Checked”, dsOrg, “Users.IsEmployee”)

  2. chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “IsEmployee”)

  3. chkIsEmployee.Text = “{Users.IsEmployee}” chkIsEmployee.AutoCheck = True

  4. chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “Users.IsEmployee”)

Show answer
Correct Option: D

. User Authentication most suitable in IntrAnet scenario

technology databases

  1. Forms Authentication

  2. Passport Authentication

  3. Windows Authentication

  4. none of the above

Show answer
Correct Option: C

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

  1. Database Maintenance Plan Wizard

  2. Database Engine Tuning Advisor

  3. SQL Server Configuration Manager

  4. Database Maintenance design surface

Show answer
Correct Option: A

You have a 1TB SalesDB database running on SQL Server 2003 Enterprise Edition. You have noticed that the nightly DBCC CHECKDB ('SalesDB') job is starting to take too long, and you want to reduce the amount of time that the check will take. What command should you schedule to run nightly instead?
technology databases

  1. DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)

  2. DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)

  3. DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY

  4. DBCC CHECKDB ('SalesDB') WITH DATA_PURITY

Show answer
Correct Option: C

You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use in SQL Server?

technology databases

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Show answer
Correct Option: D