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 SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

True

False

[#]

The primary key is selected from the:

composite keys.

determinants.

candidate keys.

foreign keys.

[#]

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

True

False

[#]

When the parent entity is required, a new parent row can always be inserted.

True

False

[#]

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

True

False

[#]

A ________ is a stored program that is attached to a table or a view.

pseudofile

embedded SELECT statement

trigger

None of the above is correct.

[#]

An exclusive lock locks the item from change but not from read.

True

False

[#]

Oracle does NOT support a CASCADE UPDATE constraint.

True

False

[#]

Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

READ_ONLY

SCROLL_LOCK

OPTIMISTIC

READCOMMITTED

[#]

10.

An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.

True

False

[#]

11.

________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications.

ASP

XML

ODBC

ADO

[#]

12.

Business Intelligence (BI) reporting systems cannot do which of the following operations?

Filter data

Group data

Modify data

Both filter and group data

[#]

13.

There is one physical schema for each logical schema.

True

False

[#]

14.

A candidate key must uniquely identify each row.

True

False

[#]

15.

A primary key may be null.

True

False

[#]

16.

A bitmap index is an index on columns from two or more tables that come from the same domain of values.

True

False

[#]

17.

What type of join is needed when you wish to include rows that do not have matching values?

Equi-join

Natural join

Outer join

All of the above.

[#]

18.

Centralized systems are more susceptible to security threats than client/server architectures.

True

False

[#]

19.

With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.

True

False

[#]

20.

Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).

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