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
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
Q.3

 ON UPDATE CASCADE ensures which of the following?

  • Normalization
  • Data Integrity
  • Materialized Views
  • All of the above.
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
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.
Q.6

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

  • MySQL
  • JSP/SQL
  • JDBC/SQL
  • Sun ACCESS
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
Q.8

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

  • Reports
  • Relationships
  • Tables
  • Queries
Q.9

 Which of the following is an advantage of partitioning?

  • Complexity
  • Inconsistent access speed
  • Extra space
  • Security
Q.10

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

  • atomic.
  • consistent.
  • isolated.
  • durable.
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.
Q.12

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

  • Participation
  • Recursive
  • Standard
  • Normal
Q.13

The time complexity of sequential search is

  • O(n)
  • O(2n)
  • O(n^2)
  • None
Q.14

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

  • TRUE
  • FALSE
Q.15

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

  • TRUE
  • FALSE
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
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.
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
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.
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
0 h : 0 m : 1 s