Online Database Test - Database Test 10



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.

Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


2.

Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A.
A → B.
B.
A → C.
C.
A → (B,C).
D.
(B,C) → A.

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


3.

The different classes of relations created by the technique for preventing modification anomalies are called:

A.
normal forms.
B.
referential integrity constraints.
C.
functional dependencies.
D.
None of the above is correct.

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


4.

A relation is considered a:

A.
Column.
B.
one-dimensional table.
C.
two-dimensional table.
D.
three-dimensional table.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


5.

A primary key is a composite key that was selected to be the main identifier for the relation.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


6.

The EXISTS keyword will be true if:

A.
any row in the subquery meets the condition only.
B.
all rows in the subquery fail the condition only.
C.
both of these two conditions are met.
D.
neither of these two conditions is met.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


7.

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


8.

When two transactions are being processed against the database at the same time they are termed concurrent transactions.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Managing Multiuser Databases

Discuss about this problem : Discuss in Forum


9.

The lost update problem is when User A reads data that have been processed by a portion of a transaction from User B.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Managing Multiuser Databases

Discuss about this problem : Discuss in Forum


10.

The JVM (Java virtual machine) interprets Java bytecode at run time.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

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

Discuss about this problem : Discuss in Forum


11.

Some advantages of the database approach include all, but:

A.
minimal data redundancy.
B.
improved data consistency.
C.
improved data sharing.
D.
program-data dependency.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


12.

User views are included as part of which schema?

A.
Internal
B.
Conceptual
C.
External
D.
None of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : The Database Development Process

Discuss about this problem : Discuss in Forum


13.

A conceptual schema is usually depicted in graphical format using E-R or object-modeling notations.

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.

A fact is a word or phrase that has a specific meaning for the business.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Modeling Data in the Organization

Discuss about this problem : Discuss in Forum


15.

A candidate key must uniquely identify each row.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Logical Database Design

Discuss about this problem : Discuss in Forum


16.

A pointer is a detailed coding scheme recognized by system software for representing organizational data.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Physical Database Design

Discuss about this problem : Discuss in Forum


17.

Mirrored databases are almost always provided in high-availability systems.

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


18.

Composition is a stronger form of which of the following?

A.
Aggregation
B.
Encapsulation
C.
Inheritance
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


19.

A constructor operation does which of the following?

A.
Creates a new instance of a class
B.
Updates an existing instance of a class
C.
Deletes and existing instance of a class
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


20.

Database objects are almost always transient.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Object-Oriented Database

Discuss about this problem : Discuss in Forum


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