Which Is True About Using Data From An Existing Database?

Ado.cyberspace Multiple choice questions and answer

Jul 12, 2020 Ado.net, ado.net mcqs, mcqs, ADO.NET multiple choice question and answers, 205458 Views

In this article, we will go through the Ado.net multiple pick question and answers. Information technology will help united states brush up our knowledge about Ado.net .

Are y'all preparing for the next chore interviews in Microsoft ASP.Net MVC? If yes, trust me this post will help you besides we'll advise you bank check out a large collection for Programming Total Forms that may help you in your interview:

List of Programming Full Forms

ADO.Net MCQs (Multiple selection questions and answer)

i) To perform asynchronous data access, what must be added to the connexion cord?

1. BeginExecute=true
2. MultiThreaded=true
3. MultipleActiveResultSets=true
4. Asynchronous=true

Answer : iv

ii) Can you use a DataView to filter rows in a DataTable

1. Yeah, by setting the Filter holding of the DataView
2. Yeah, past setting the RowFilter property of the DataView
3. Yes, by using the SetFilter(. method of the DataView
4. No, a DataView cannot exist used to filter rows in a DataTable

Answer: 2

3) Which is a property of the DataGrid command?

1. DataMember
2. DataSource
3. DataQuery
4. All of the above.

Answer: 4

iv) In a connection string _____________ represents name of the database

1. Data Source
2. Initial Catalog
3. Catalog Initial
4. Database

Respond: 2

5)   What are the Control Object Methods?

1. ExecuteNonQuery
2. ExecuteReader
3. ExecuteScalar
4. All of the above.

Answer: 4

6) When yous create a relationship betwixt tables in ADO.Internet DataSet

1. A UniqueConstraint is added to the parent table
2. A ForeignKeyConstraint is added to the child tabular array by default
3. Both a and b
4. None

Respond : 3

7) The starting time tape in a dataset has a position property of:

1. zero
2. one
3. whatever value defined by the programmer
4. All of the above

Respond: 1

8)  Which ado.net class provide a asunder environment?

1. DataReader
2. DataSet
3. Command
4. None of the above.

Reply: ii

9) What data is specified in the Connection tab of the DataLink window?

1. Database login
2. Database name
3. Database type
4. All of the above.

Answer: 4

10) Which of the following is true for ADO.NET DataSet?

1. DataSet provides a disconnected view of a data source.
2. Dataset enables to store information from multiple tables and multiple sources
3. We can create a relationship between the tables in a DataSet.
4. All of the above is true

Answer: 4

xi) Which file you lot should write for the connection string so that you tin admission information technology in all the web pages for the same application?

1. In App_Data folder
2. In Web.config file
3. In MasterPage file
4. None of the above

Answer: 2

12) Which of the post-obit is non a DataReader method?

1. NextResult
2. GetName
3. GetValue
4. GetDataType

Answer: 4

thirteen) Which database is the ADO.NET SqlConnection object designed for?

1. Access
2. Microsoft SQL Server
3. MySQL
4. Oracle

Answer: 2

14) The information is stored in a Microsoft SQL Server database on a server named Admin and the Database name is Diploma. You connect to Diploma by using Windows authentication mode. Y'all use a SqlConnection object to connect to the database. And then which is the right connection string from beneath?

1. Information Source=Admin\SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=True
2. Data Source=Admin/SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=True
3. Data Source=Admin\SQLEXPRESS;Initial Catalog=Diploma;Integrated Security=Fake
4. All of the Above

Respond: i

xv) Choose the correct option about the Integrated Security property of the connection object.

1. If Integrated Security=false so User ID and Countersign must be specified in the connection string.
2. If Integrated Security=true, so current Windows account credentials are used for authentication.
3. Both A and B option are right.
4. None of the higher up.

Respond : iii

16) The first step of configuring a DataAdapter is to select:

1. An adapter object.
2. A connection object.
3. A database object.
4. A dataset object.

Reply: 2

17) To check the condition of the connection, ____ property is useful

1. ConnectionStatus
2. Status
3. State
4. ConnectionState

Reply: iii

18) Which is not an ADO.NET DataAdapter Object?

1. OleDbDataAdapter
2. SQLDataAdapter
3. QueryDataAdapter
4. All of the above.

Answer: three

19) Which type of object has the Generate Dataset method?

1. Adapter object
2. Connexion object
3. Database object
4. Dataset object

Reply: 1

20) Which of the following illustrates the benefit of ADO.Cyberspace?

1. Interoperability
2. It uses DataSet to represent data in memory that can store data from multiple tables and multiple sources.
3. Disconnected data admission
4. All of higher up

Answer: 4

21) Which object does the data-aware control demark to?

1. Dataset
2. DataAdapter
3. Connectedness
4. All of the higher up.

Answer: 1

22) Which object contains the Position property of the current record in a dataset?

1. BindingContext
2. BindingData
3. DataBinding
4. DataBound

Answer: 1

23) Which below is specified by the DataSource Belongings?

1. Connection object
2. DataAdapter object
3. Database field
4. Dataset object

Reply : 3

24) Which of the following method of the command object is best suited when yous have aggregate functions in a SELECT argument?

1. ExecuteScalar
2. ExecuteReader
3. ExecuteNonQuery
4. None

Reply: 1

25) What data type is returned when calling the ExecuteScalar method of a command object?

1. System.Int32
2. Object
3. No of affected records.
4. None of the above.

Answer: 2

26)To perform Insert, Update and Delete Command which method is used?

1. ExecuteScalar
2. ExecuteReader
3. ExecuteNonQuery
4. None

Respond: three

27) Which DataAdapter Query Blazon can be used with the Access database?

1. Apply SQL statements.
2. Create a new stored procedure.
3. Use existing stored procedure.
4. All of the above.

Reply: one

28) What is the proper code to put data into the dataset called EmployDataset using the EmployDataAdapter object?

1. EmployDataset.Fill up(EmployDataAdapter)
2. EmployDataAdapter.Fill(EmployDataset)
3. EmployDataset.Load(EmployDataAdapter)
4. EmployDataAdapter.Load(EmployDataset)

Respond: 2

29) Which of the following is the method provided by the DataSet object to generate XML?

1. ReadXML
2. WriteXML
3. three.GetXML
4. All of the to a higher place

Answer: 4

thirty) The default timeout for SqlCommand.Command timeout property

1. 10 Seconds
2. 20 Seconds
3. thirty Seconds
4. 40 Seconds

Respond : three

More than Interview Questions and Answers:

• Superlative 15 Python Interview Questions
• React Interview Question
• C# Interview Questions and Answers
• Superlative 10 IoT Interview Questions
• DotNet Cadre Interview Questions and Answers
• Angular Interview Questions with Answers
• Interview questions for Asp.Net and .Net
• OOPs Interview Questions and Answers
• Blazor Interview Questions and Answer
• Top 10 Interview Questions and Answered for Web Developer of 2020
• OOPs Interview Questions and Answers in C#
• GoogleCloud Interview Questions
• Asp.cyberspace MVC Interview Questions and Answers
• Interview Questions and Answers On Selenium Webdriver

Which Is True About Using Data From An Existing Database?,

Source: https://www.tutorialslink.com/Articles/Adonet-Multiple-choice-questions-and-answer/1714

Posted by: leenegards40.blogspot.com

Share this post