Practice Database Questions Multiple Choice Questions with Answers Quiz-1

Q.1.

A goal of data mining includes which of the following?

To explain some observed event or condition
To analyze data for expected relationships
To confirm that data exists
To create a new data warehouse

Explanation

Q.2.

The FROM SQL clause is used to

specify what table we are selecting or deleting data FROM
specify search condition
specify range for search condition
None of these

Explanation

Q.3.

ON UPDATE CASCADE ensures which of the following?

Normalization
Data Integrity
Materialized Views
All of the above.

Explanation

Q.4.

A DBMS that combines a DBMS and an application generator is ________ .

Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle

Explanation

Q.5.

Which of the following is the original purpose of SQL?

To specify the syntax and semantics of SQL data definition language
To specify the syntax and semantics of SQL manipulation language
To define the data structures
All of the above.

Explanation

Q.6.

________ is an open source DBMS product that runs on UNIX, Linux and Windows.

MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS

Explanation

Q.7.

If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?

First normal form
Second normal form
Third normal form
Fourth normal form

Explanation

Q.8.

Which of the following is not a database object in MS Access?

Reports
Relationships
Tables
Queries

Explanation

Q.9.

Which of the following is an advantage of partitioning?

Complexity
Inconsistent access speed
Extra space
Security

Explanation

Q.10.

A transaction for which all committed changes are permanent is called:

atomic.
consistent.
isolated.
durable.

Explanation

Q.11.

The ODBC Level 1 API contains which of the following functions?

Browse possible connections and data sources only
Connect to data sources with driver-specific information only
Process a scrollable cursor only
Both 1 and 3 above are in the OBDC Level 1 API.

Explanation

Q.12.

The relationship where both the participating entities belong to same entity type is called

Participation
Recursive
Standard
Normal

Explanation

Q.13.

The time complexity of sequential search is

O(n)
O(2n)
O(n^2)
None

Explanation

Q.14.

Database is a collection of concepts that can be used to describe the structure of a database

TRUE
FALSE

Explanation

Q.15.

Representation level data models provide the concepts that are close to the way many users perceive data

TRUE
FALSE

Explanation

Q.16.

Does the minimum spanning tree of a graph give the shortest distance between any 2 specified nodes?

Yes
No
May be Yes or No
None

Explanation

Q.17.

The expression FOR XML RAW tells SQL Server to:

place the values of the columns as attributes in the resulting XML document.
place the values of the columns into elements rather than attributes.
place some columns into elements and others into attributes.
None of the above is correct.

Explanation

Q.18.

A subset of the database which contain virtual data that is derived from the database files but is not explicitly stored is called

Touple
View
Relation
Key

Explanation

Q.19.

Which of the following improves a query's processing time?

Write complex queries.
Combine a table with itself.
Query one query within another.
Use compatible data types.

Explanation

Q.20.

A report generated by a reporting system is delivered to the appropriate users via a user-accessed Web site. This system uses which of the following report modes?

Push
Pull
RFM
OLAP

Explanation

Support mcqgeeks.com by disabling your adblocker.