View Count: 0
Duration: 24 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 53 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 16 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 28 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 36 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 21 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 26 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 17 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 34 mins
Accessed date:
Not Yet Viewed
View Count: 0
Duration: 12 mins
Accessed date:
Not Yet Viewed
Post your comment / feedback here
 
 

Be the first one to comment about this video

Question No: 1 of 85
What is a managed provider? 
Options:
  1. Managed Provider provides a simplified data access architecture that often results in improved performance without the loss of functional capabilities.
  2. Managed providers directly expose provider-specific behavior to consumers through methods and properties.
  3. Managed providers work within the boundaries of the Common Language Runtime (CLR).
  4. All the above.
View Answer/Explanation:
d
Explanation:
Managed provider is a media to communicate between application and the database. Managed provider is a .Net component implementing standard set of interfaces provided by Microsoft on the specific type of database (backend example: Sqlserver).

Question No: 2 of 85
What is the Managed provider for Microsoft Sqlserver Database? 
Options:
  1. System.Data.SqlClient
  2. System.Data.OracleClient
  3. System.Data.Oledb
  4. System.Data.Odbc
  5. All the above
View Answer/Explanation:
a c d
Explanation:
System.Data.SqlClient - Managed Provider For MS Sql server. System.Data.OracleClient- Managed Provider For Oracle System.Data.Oledb-Managed provider for any Database which are having Oledb providers System.Data.Odbc-Managed provider for any Database

Question No: 3 of 85
Can we enable or disable the connection pool? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:
By default Connection pool is enabled. If we explicitly want to enable or disable connection pooling we should set Pooling=true/false in your connection string

Question No: 4 of 85
What is the core ADO.Net assembly? 
Options:
  1. System.Data.dll
  2. System.Data.SqlClient.dll
  3. System.Data.Linq.dll
  4. System.Data.Linq.dll
View Answer/Explanation:
a
Explanation:
System.Data.dll is the main part ADO.Net architecture. Each dataset comprises of many DataTable objects, with each DataTable comprising data from an any of the datasource, which can be SQLServer, ODBC and OLEDB

Question No: 5 of 85
What is the namespace for MS SQLServer Compact database? 
Options:
  1. System.Data.SqlClient
  2. System.Data
  3. System.Data.SqlServerCe
  4. System
View Answer/Explanation:
c
Explanation:
This namespace provide access to SQL server databases. By using System.Data.SqlServerCe, you can create and manage SQL Server Compact 4.0 databases from a computer

Question No: 6 of 85
Which of the following is correct about Oledb Managed Provider? 
Options:
  1. Oledb provider is .NET component
  2. Oledb is COM component
  3. Oledb provider provides standard interface for SQL server only.
  4. None
View Answer/Explanation:
b
Explanation:
Oledb is a COM component provides implementation to certain standard interfaces as per COM specification. This can be used to connect to Oracle and other databases. Front end application will make use of ADO objects these object will select appropriate oledb provider depending upon database, for communicating with the database. This is ideally suitable for COM architecture

Question No: 7 of 85
How can we specify port number in Connection String in App.Config file? 
Options:
  1. Connection String ="server=.\sqlexpress,portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".
  2. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword".
  3. Connection String ="server=.\sqlexpress;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port Number=number".
  4. Connection String ="server=.\sqlexpress; portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword;Port=Port Number"
View Answer/Explanation:
a
Explanation:
Port number can be provided with a comma after the server address Connection String ="server=.\sqlexpress,portnumber;Database=dbname;Uid=dbuser; Pwd=dbpassword"

Question No: 8 of 85
@@Identity contains last identity value over given connection 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:
Select @@Identity contains last identity value over given connection. It is different for every SqlConnection.

Question No: 9 of 85
Can we have multiple .config files along with App.Config file? 
Options:
  1. Yes
  2. No
View Answer/Explanation:
a
Explanation:
We can have multiple .config files along with App.config file but they should be placed in different folders, for root folder we should have only one App.config, we can add one more config file in other subfolder.

Question No: 10 of 85
The return type for ExecuteNonQuery() is ______________ 
Options:
  1. void
  2. int
  3. String
  4. char
View Answer/Explanation:
b
Explanation:
The return type for ExecuteNonQuery () is int, ExecuteNonQuery () is used for executing of the statements which returns the number of records affected in database. If rollback occurs it return -1.

  1