Online Database Test - Database Test - Random



Loading...  Loading Test...

Instruction:

  • This is a FREE online test. DO NOT pay money to anyone to attend this test.
  • Total number of questions : 20.
  • Time alloted : 30 minutes.
  • Each question carry 1 mark, no negative marks.
  • DO NOT refresh the page.
  • All the best :-).


1.

An operational system is which of the following?

A.
A system that is used to run the business in real time and is based on historical data.
B.
A system that is used to run the business in real time and is based on current data.
C.
A system that is used to support decision making and is based on current data.
D.
A system that is used to support decision making and is based on historical data.

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Warehousing

Discuss about this problem : Discuss in Forum


2.

Total specialization is represented by double lines between the supertype and subtype on an EER.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : ER Model and Business Rules

Discuss about this problem : Discuss in Forum


3.

Which of the following is not a component of a data warehouse?

A.
Data extraction/cleaning/preparation programs
B.
Data warehouse data
C.
Data metadata
D.
None of the above are data warehouse components.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


4.

We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .

A.
Has ordered recently, orders frequently, and places a large order when she orders.
B.
Hasn't ordered recently, orders infrequently, but places a large order when she orders.
C.
Has ordered recently, orders frequently, but doesn't place a large order when she orders
D.
Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


5.

Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

A.
Supertype entity
B.
Subtype entity
C.
Archetype entity
D.
Instance entity

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Modeling with ER Model

Discuss about this problem : Discuss in Forum


6.

Multivalued dependencies should ________ be eliminated.

A.
always
B.
commonly
C.
seldom
D.
never

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Design Using Normalization

Discuss about this problem : Discuss in Forum


7.

In a relation, the columns are sometimes called "attributes."

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


8.

Keys made up of two or more attributes are called composite keys.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


9.

How does Tomcat execute a JSP?

A.
As a CGI script
B.
As an independent process
C.
By one of Tomcat's threads
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : JDBC, Java Server Pages, and MySQL

Discuss about this problem : Discuss in Forum


10.

Which of the following are integrity controls that a DBMS may support?

A.
Assume a default value in a field unless a user enters a value for that field.
B.
Limit the set of permissible values that a field may assume.
C.
Limit the use of null values in some fields.
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Physical Database Design

Discuss about this problem : Discuss in Forum


11.

When the parent entity is required and the parent has a surrogate key, update actions can be ignored.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


12.

When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


13.

During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Database Development Process

Discuss about this problem : Discuss in Forum


14.

Backward recovery is used to reverse the changes made by transactions that have aborted, or terminated abnormally.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data and Database Administration

Discuss about this problem : Discuss in Forum


15.

Which of the following is true concerning a procedure?

A.
You do not create them with SQL.
B.
They do not need to have a unique name.
C.
They include procedural and SQL statements.
D.
They are the same thing as a function.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


16.

The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : SQL for Database Construction

Discuss about this problem : Discuss in Forum


17.

Periodic data are data that are physically altered once added to the store.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Warehousing

Discuss about this problem : Discuss in Forum


18.

A database has data and relationships.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


19.

Microsoft Access is an enterprise-class database product.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


20.

READ COMMITTED is the default isolation level.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


Submit your test now to view the Results and Statistics with answer explanation.