Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

What best describes the relationship between indexes and SQL performance?

Indexes are only used in special cases
Indexes are used to make table storage more efficient
Indexes rarely make a difference in SQL performance
Indexes exist solely to improve query speed.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

.NET 2.0
.NET 3.0
.NET 3.5
All of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which is not a collection type in VB.NET?

Hashtable
ArrayList
Stack
Heap

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

OrderedDictionary class
ListDictionary class
HybridDictionary class
Hashtable class

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Me.DataBindings.Add(“chkIsEmployee.Checked”, dsOrg, “Users.IsEmployee”)
chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “IsEmployee”)
chkIsEmployee.Text = “{Users.IsEmployee}” chkIsEmployee.AutoCheck = True
chkIsEmployee.DataBindings.Add(“Checked”, dsOrg, “Users.IsEmployee”)

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

. User Authentication most suitable in IntrAnet scenario

Forms Authentication
Passport Authentication
Windows Authentication
none of the above

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

Database Maintenance Plan Wizard
Database Engine Tuning Advisor
SQL Server Configuration Manager
Database Maintenance design surface

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

DBCC CHECKDB ('SalesDB', REPAIR_ALLOW_DATA_LOSS)
DBCC CHECKDB ('SalesDB', REPAIR_REBUILD)
DBCC CHECKDB ('SalesDB') WITH PHYSICAL_ONLY
DBCC CHECKDB ('SalesDB') WITH DATA_PURITY

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

Transactional replication
Peer-to-peer replication
Merge replication
Snapshot replication

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases