gs gs116 Data Connectivity - Distributed Queries - Quiz No.1
gs gs116 Microsoft SQL Server Quiz
This quiz belongs to book/course code gs gs116 Microsoft SQL Server of gs organization. We have 100 quizzes available related to the book/course Microsoft SQL Server. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Data Connectivity. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: What is the syntax for using linked server stored procedure in SQL Server?
sp_linkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] [ , [ @provider= ] 'provider_name' ] [ , [ @datasrc= ] 'data_source' ] [ , [ @location= ] 'location' ] [ , [ @provstr= ] 'provider_string' ] [ , [ @catalog= ] 'catalog' ] sp_addlinked [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] [ , [ @provider= ] 'provider_name' ] [ , [ @datasrc= ] 'data_source' ] [ , [ @location= ] 'location' ] [ , [ @provstr= ] 'provider_string' ] [ , [ @catalog= ] 'catalog' ] sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] [ , [ @provider= ] 'provider_name' ] [ , [ @datasrc= ] 'data_source' ] [ , [ @location= ] 'location' ] [ , [ @provstr= ] 'provider_string' ] [ , [ @catalog= ] 'catalog' ] sp_addlinkedser [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] [ , [ @provider= ] 'provider_name' ] [ , [ @datasrc= ] 'data_source' ] [ , [ @location= ] 'location' ] [ , [ @provstr= ] 'provider_string' ] [ , [ @catalog= ] 'catalog' ]
Question 2: Point out the correct statement.
To access a mirrored database, a connection string must contain the database name
When the linked server is defined against an instance of SQL Server, catalog refers to the default database to which the linked server is mapped
[ @location= ] ‘location’ is the location of the database as interpreted by the OLE DB provider in sp_addlinkedserver
All of the mentioned
Question 3: sp_addlinkedserver command creates a distributed server entry called _________ in the following code.
sp_addlinkedserver @server = "Northwinds", @srvproduct = "Access 97", @Provider = "Microsoft.Jet.OLEDB.3.51", @datasrc = "c:\brian\writing\sqlservermag\nov98\nwind.mdb"
Access 97
Microsoft.Jet.OLEDB.3.51
nwind
Northwinds
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
Question 5: Point out the wrong statement.
SQL Server cannot use execution strategies that involve using the procedures of the Table provider to evaluate predicates
For a distributed query, the comparison semantics for all character data is defined by the character se
SQL Server can delegate comparisons and ORDER BY operations on character columns to a provide
None of the mentioned
Question 6: Which of the following function mainly used for bulk load data is referenced in the following code?
SELECT RemoteOrders.* FROM OpenRowset("Microsoft.Jet.OLEDB.3.51", "c:\brian\writing\sqlservermag\nov98\nwind.mdb"; "admin"; , "select * from orders") RemoteOrders left join MasterOrders on RemoteOrders.OrderId = MasterOrders.OrderId WHERE MasterOrders.OrderID = null
OpenRowset
Microsoft.Jet.OLEDB
admin
All of the mentioned
Question 7: Which of the following SQL syntax elements is dictated by the SQL dialect levels?
LIKE support
Parameter marker support
Nested query support
None of the mentioned
Question 8: Which of the following function will be preferred for faster execution in following code?
SELECT RemoteOrders.* FROM ________(Northwinds, "select * from orders") RemoteOrders left join MasterOrders on RemoteOrders.OrderId = MasterOrders.OrderId WHERE MasterOrders.OrderID = null
OpenRow
OpenSQL
OpenQuery
All of the mentioned
Question 9: Which of the following query combines data from more than one SQL Server instance?
USE SCRATCH GO SELECT TOP 1000 * FROM REMOTE.Scratch.dbo.Table1 T1 INNER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID USE SCRATCH GO SELECT * FROM dbo.Table1 T1 INNER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID WHERE T1.GUIDSTR < '001' USE SCRATCH GO SELECT TOP 500 * FROM REMOTE.Scratch.dbo.Table1 T1 OUTER JOIN REMOTE.Scratch.dbo.Table2 T2 ON T1.ID = T2.ID
None of the mentioned
Question 10: The easiest way to start is to create a linked server 'localhost' by using _____________
sp_addlinkedserv 'localhost'
sp_addlinkedsrvlogin 'localhost'
sp_addlinkedserverlogin 'localhost'
sp_addlinkedserver 'localhost'
Online Quizzes of gs116 Microsoft SQL Server
Developing with SQL Server - Error Handling - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Aggregation of Data - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Joins in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
Laying the Foundation - Views in SQL Server - Quiz No.1
gs gs116
Microsoft SQL Server Online Quizzes
