Question 1

Which of the following namespace contains the LINQ to XML?

Accepted Answer

A) System.Xml; 
B) System.Data; 
C) System.Xml.Linq; 
D) System.Linq;

Question 2

A connection string contains

Accepted Answer

A) a using directive 
B) the name of the data source 
C) the version number of database management system 
D) the list of fields in the database

Question 3

The field in the child table that links information to the parent table is known as the

Accepted Answer

A) Foreign key. 
B) Primary key. 
C) Tertiary key. 
D) Secondary key.

Question 4

In Visual Studio, the tool that enables you to connect to a database and automatically populate a dataset object using a TableAdapter object is the ___________wizard:

Accepted Answer

A) Data Source Configuration 
B) Data Source 
C) Query Builder 
D) DataSet Designer

Question 5

Choose the namespace which consists of classes that are part of .NET Reflection API:

Accepted Answer

A) System.Text 
B) System.Name 
C) System.Reflection 
D) None of the mentioned

Question 6

A unique field which distinguishs a record is known as a

Accepted Answer

A) Foreign key. 
B) Primary key. 
C) Tertiary key. 
D) Secondary key.

Question 7

A copy of a database is called a

Accepted Answer

A) Duplicate database. 
B) Dataset. 
C) Table. 
D) Database copy.

Question 8

Choose the correct statements about the LINQ?

Accepted Answer

A) The main concept behind the linq is query 
B) linq make use of for loop to execute the query 
C) It is not required that linq should make use of IEnumerable interface 
D) None of the mentioned

Question 9

ADO.NET is the data access component of Microsoft's .NET framework that enables you to

Accepted Answer

A) connect your Visual Basic.NET applications to your company's local area network. 
B) connect your Visual Basic.NET applications to databases. 
C) connect your PC to the Internet. 
D) connect your local area network to the Internet.

Question 10

The connection to the database is established by

Accepted Answer

A) Using a local area network. 
B) Installing a special software package. 
C) Using managed providers. 
D) Using a wide area network.

Question 11

Can we use linq to query against a DataTable?

Accepted Answer

A) Yes 
B) No 
C) Situational 
D) None of the mentioned

Question 12

Choose the namespace in which the interface IEnumerable is declared?

Accepted Answer

A) System.Collections 
B) System.Collections.Generic 
C) Both a & b 
D) None of the mentioned

Question 13

In a database, a parent-child relationship is also known as a

Accepted Answer

A) Many-to-one relationship. 
B) Many-to-many relationship. 
C) One-to-many relationship. 
D) One-to-one relationship.

Question 14

Databases store information in records, fields and:

Accepted Answer

A) data providers 
B) grids 
C) columns 
D) tables

Question 15

The following namespaces (System.Data.OleDB, System.Data.SqlClient, System.Data.Odbc, System.Data.OracleClient) include classes for different:

Accepted Answer

A) Data providers 
B) File streams 
C) ADO.NET applications 
D) Databases

Question 16

The ADO.NET disconnected dataset

Accepted Answer

A) Provides a flexible way of working with database records. 
B) Makes working with databases very complex. 
C) Requires a large amount of memory space. 
D) Is required when single users want to access a database.

Question 17

Forms and reports, used for entering and editing records, and for generating useful information in reports are

Accepted Answer

A) additional database objects. 
B) only useful for complex databases. 
C) difficult to generate. 
D) stored separately from databases.

Question 18

ADO.NET was created for

Accepted Answer

A) Multiple users. 
B) Single users. 
C) Home network users. 
D) Limited users.

Exam 4: C Programming: Database and ADO.NET