In OLE DB, a tabular data provider:

OLE DB tabular data providers present data in the form of rowsets.

A

True

B

False

OLE DB has two types of data providers: tabular data providers and service providers.

A

True

B

False

Which of the following statements are true?
Statement I Big data refers to no precise quantity, but generally refers to data in the range of Petabytes and Exabyte, i.e. billions to trillions of records, all from various sources. Big data is generated much faster. than traditional data in much larger quantities.
Statement II Big data interests industries because they are able to learn more patterns and curious variances than smaller data sets, with the capability to provide valuable insights into consumer behaviour, weather systems, financial market activity, or other phenomena.
Statement III Various departments and product lines use various applications within most organisations and store data in separate datasets. These separate databases may contain similar data, but data from one data base to another is not always consistent. This is called data silo.

A

Both statements I and II

B

Both statements II and III

C

Both statements I and III

D

All of the above

Point out the correct statement. ‘location’ is the location of the database as interpreted by the OLE DB provider in sp_addlinkedserver d) All of the mentioned

A

To access a mirrored database, a connection string must contain the database name

B

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

C

[ @location=

D

@location=

The INSERT, UPDATE, or DELETE statement fails if the OLE DB provider used to access the linked server does not support the _________ interface.

A

ITransJoin

B

ITransactionJoin

C

IactionJoin

D

None of the mentioned

In OLE DB, a service provider:

A

does not own data only.

B

transforms data through OLE DB interfaces only.

C

is both a consumer and a provider of data only.

D

All of the above are true of an OLE DB service provider.

Which data manipulation library in Python is commonly used for handling tabular data and data cleaning tasks?

A

Pandas

B

Matplotlib

C

NumPy

D

Scikit-learn

Cloud computing has the following distinct characteristics : (A) The service is hosted on the internet. (B) It is made available by a service provider. (C) It computes and predicts rain when the weather is cloudy. (D) The service is fully managed by the provider Choose the correct answer from the options given below :

A

(A), (B) only

B

(A), (B), (C) only

C

(A), (D) only

D

(A), (B), (D) only

A statement is given followed by two inferences I and II. You have to consider the statement to be true even if it seems to be at variance from commonly known facts. You have to decide which of the given inferences, if any, follow from the given statement? Statement: The global cab service provider has now started running real-time background checks on their drivers. Inferences: I. The number of users of the cab service provider will increase. II. The cab service will be safer for its users henceforth.

A

Only inference I follows

B

Only inference II follows

C

Both inference I and II follow

D

None of the inferences follow

__________are Data frames which contain lists of homogeneous data in a tabular format.

A

Matrix

B

Vector

C

Lists

D

Array

In OLE DB, a tabular data provider:

Related Questions