Question 61 : Which of the following is enumeration for ADO.net with SQL Server ?
1. SqlInfo
2. SqlBulkCopyOptions
3. SqlNotification
4. All of the mentioned
View Answer   Discuss with Members

Question 62 : Point out the wrong statement :
1. The goal of dotConnect for SQL Server is to enable developers to maintain database applications.
2. dotConnect for SQL Server combines connected and disconnected data access models in single SqlDataTable component
3. dotConnect for SQL Server supports new ADO.NET features and technologies as soon as they are released
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 63 : Code snippet for having a named instance of SQL Server would be :
1. “Server=localhost\sqlexpress”
2. “Server=local\sqlexpress”
3. “Server=host\sqlexpress”
4. “Ser=localhost\sqlexpress”
View Answer   Discuss with Members

Question 64 : Point out the correct statement :
1. Using the System.Data.SqlClient , you can fill a memory-resident DataSet that you can use to query and update the database
2. System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server
3. SqlBulkCopyColumnMapping lets you efficiently bulk load a SQL Server table with data from another source
4. None of the mentioned
5.
View Answer   Discuss with Members

Question 65 : To use the .NET Framework Data Provider for SQL Server, an application must reference the _____________ namespace.
1. System.Data.Client
2. System.Data.SqlClient
3. System.Data.Sql
4. None of the mentioned
View Answer   Discuss with Members

Question 66 : Which of the following SQL syntax elements is dictated by the SQL dialect levels ?
1. LIKE support
2. Parameter marker support
3. Nested query support
4. None of the mentioned
View Answer   Discuss with Members

Question 67 : Point out the wrong statement :
1. SQL Server cannot use execution strategies that involve using the procedures of the Table provider to evaluate predicates
2. For a distributed query, the comparison semantics for all character data is defined by the character se
3. SQL Server can delegate comparisons and ORDER BY operations on character columns to a provide
4. None of the mentioned
View Answer   Discuss with Members

Question 68 : Which is default field terminator for bulk insert in SQL Server ?
1. Comma
2. Full stop
3. Parenthesis
4. Brackets
View Answer   Discuss with Members

Question 69 : ________ parameter specifies the number of rows in a batch in bulk insert script.
1. KEEPNULLS
2. KEEPIDENTITY
3. FIRE_TRIGGERS
4. None of the mentioned
View Answer   Discuss with Members

Question 70 : Which of the following performance considerations are regarding bulk operations ?
1. Column locking
2. Batch switches
3. Constraint checking of NULL constraints
4. All of the mentioned
View Answer   Discuss with Members