Online Database Test - Database Test - Random

Instruction:

This is a FREE online test. Beware of scammers who ask for money to attend this test.
Total number of questions: 20.
Time allotted: 30 minutes.
Each question carries 1 mark; there are no negative marks.
DO NOT refresh the page.
All the best!

A database is called "self-describing" because it contains a description of itself.

True

False

[#]

The SQL keyword BETWEEN is used:

for ranges.

to limit the columns displayed.

as a wildcard.

None of the above is correct.

[#]

In all cases, normalization into BCNF is desirable.

True

False

[#]

Composite identifiers consist of two or more attributes.

True

False

[#]

A subtype entity is a special case of another entity called a supertype entity.

True

False

[#]

A ________ is a program that performs some common action on database data and that is stored in the database.

trigger

stored procedure

pseudofile

None of the above is correct.

[#]

The data model produced from the reverse engineering process is a true logical model.

True

False

[#]

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

Nonrepeatable read

Phantom read

Dirty read

Consistent read

[#]

SQL Server 2000 stored procedures can:

never be kept within the database.

be kept within the database and invoked by application programs.

be stored on the users' computer.

support BEFORE, INSTEAD OF and AFTER types.

[#]

10.

What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?

A Java application

A Java applet

A Java servlet

None of the above is correct.

[#]

11.

What servlet processor was developed by Apache Foundation and Sun?

Apache Tomcat

Apache Web server

Sun servlet processor

None of the above is correct.

[#]

12.

A data warehouse is a database system that is optimized for operational transaction processing.

True

False

[#]

13.

There is one physical schema for each logical schema.

True

False

[#]

14.

With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.

True

False

[#]

15.

Data processing logic includes such activities as data validation and identification of processing errors.

True

False

[#]

16.

C++ is an object-oriented language and is simpler than Java.

True

False

[#]

17.

Data transformation includes which of the following?

A process to change data from a detailed level to a summary level

A process to change data from a summary level to a detailed level

Joining data from one source into various sources of data

Separating data from one source into various sources of data

[#]

18.

Static extract is used for ongoing warehouse maintenance.

True

False

[#]

19.

A traditional data administrator performs which of the following roles?

Tune database performance

Establish backup and recovery procedures

Resolve data ownership issues

Protect the security of the database.

[#]

20.

An aggregation is a stronger form of association relationship and is represented with a solid diamond at the aggregate end.

True

False

[#]

Quick links

Quantitative Aptitude

Verbal (English)

Reasoning

Programming

Interview

Placement Papers

Online Database Test - Database Test - Random

Marks : 2/20

Test Review : View answers and explanation for this test.

Current Affairs

Interview Questions

Group Discussions