Questions and answers for exam Preparation

MCQs

Total Questions : 10

Question 1. Code snippet for having a named instance of SQL Server would be :

Server=localhost\sqlexpress"
Server=local\sqlexpress"
Server=host\sqlexpress"
Ser=localhost\sqlexpress"

Discuss Question

Answer: Option B. -> Server=local\sqlexpress"

An instance of the SqlConnection class in .NET Framework is supported the Data Provider for SQL Server Database.

Question 2. Which is the most serious issue after migration of access database to SQL Server ?

Auto-increment columns are not updated until the record is updated
Slow performance with linked tables
New records are not available
You cannot modify a linked table schema with Access

Discuss Question

Answer: Option B. -> Slow performance with linked tables

Some queries might be slow after upsizing

Question 3. Under the _______ recovery model, all bulk operations are fully logged

Simple
Partial
Full
All of the mentioned

Discuss Question

Answer: Option C. -> Full

Question 4. Which of the following command tells that all local users are logged in as "sa in the following code ?EXEC sp_addlinkedsrvlogin@rmtsrvname = "Northwinds",@useself = "false",@locallogin = "sa",@rmtuser = "Admin",@rmtpassword = NULL

sp_addlinkedsrv
sp_addlinkedserver
sp_addlinkedsrvlogin
None of the mentioned

Discuss Question

Answer: Option C. -> sp_addlinkedsrvlogin

sp_addlinkedsrvlogin creates or updates a mapping between a login on the local instance of SQL Server and a security account on a remote server.

Question 5. When you execute SQL statements within Integration Services, the following optimization can be made ?

If Integration Services and SQL Server run on the different server, use the SQL Server destination instead of the OLE DB destination to improve performance
In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache
If you cannot use commit size 1, use the highest possible value of commit size to reduce the overhead of multiple-batch writing
All of the mentioned

Discuss Question

Answer: Option B. -> In SQL Server 2008 Integration Services, there is a new feature of the shared lookup cache

When using parallel pipelines (see points #8 and #10 below), it provides a high-speed, shared cache.

Question 6. Which of the following is the best practice related to SSIS ?

Plan for capacity by understanding resource utilization.
SSIS is an in-memory pipeline, so ensure that all transformations occur in memory
Baseline source system extract speed
All of the mentioned

Discuss Question

Answer: Option A. -> Plan for capacity by understanding resource utilization.

SQL Server Integration Services is designed to process large amounts of data row by row in memory with high speed. Because of this, it is important to understand resource utilization, i.e., the CPU, memory, I/O, and network utilization of your packages.

Question 7. Point out the correct statement :

LINQ supports flat outer joins
LINQ's parameterization is inline, typesafe, and highly readable
LINQ queries are composable
All of the mentioned

Discuss Question

Answer: Option D. -> All of the mentioned

We can add predicates conditionally in LINQ.

Question 8. Which of the following stored prcoedure provide replication support for AlwaysOn ?

sp_validate_replica_publishers
sp_validate_hosts_as_publishers
sp_validate_replica_hosts_as_publishers
All of the mentioned

Discuss Question

Answer: Option C. -> sp_validate_replica_hosts_as_publishers

Four new stored procedures provide replication support for AlwaysOn.

Question 9. The ______ pre-compiler translates embedded SQL into calls to the Oracle runtime library.

Pro*C
ORM
ApexSQL
None of the mentioned

Discuss Question

Answer: Option A. -> Pro*C

Oracle Pro*C is a set of APIs supplied by Oracle to query, insert, update, or delete records in an Oracle database from C applications.

Question 10. Point out the wrong statement :

The developers can design applications from independent components known as services"
The maintenance of Service Broker is difficult
Maintenance of Service Broker it is a part of the routine database
None of the mentioned

Discuss Question

Answer: Option B. -> The maintenance of Service Broker is difficult

The maintenance of Service Broker is easy because it forms a part of the Database Engine.