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!

Eliminating modification anomalies is a(n) ________ of normalization.

advantage

disadvantage

either an advantage or disadvantage

neither an advantage nor disadvantage

[#]

One common design problem when designing a database from existing data is the presence of missing values, called blank values, in received data.

True

False

[#]

When building a database from an existing set of tables, we may safely assume that referential integrity constraints have been enforced on the data we are given.

True

False

[#]

Denormalized tables are in BCNF.

True

False

[#]

A maximum cardinality is the maximum number of entity instances that can participate in a relationship instance.

True

False

[#]

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

None of the above is correct.

[#]

A transaction in which either all of the database actions occur or none of them do is called:

atomic.

consistent.

isolated.

durable.

[#]

The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.

True

False

[#]

READ COMMITTED is the default isolation level.

True

False

[#]

10.

An OLE DB rowset is equivalent to a cursor.

True

False

[#]

11.

The XSLT processor copies the elements of the stylesheet until it finds a command in the format:

SELECT ... FROM ... WHERE.

{item, action}.

{for-each select}.

<HTML>...<\HTML>.

[#]

12.

Which JDBC driver Types are for use over communications networks?

Type 3 only

Type 4 only

Both Type 3 and Type 4

Neither Type 3 nor Type 4

[#]

13.

Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.

True

False

[#]

14.

A strong entity is an entity whose existence depends on some other entity type.

True

False

[#]

15.

Overlapping and disjoint subtypes have different approaches on how the subtype discriminator is applied.

True

False

[#]

16.

The blocking factor is:

a group of fields stored in adjacent memory.

the number of physical records per page.

attributes grouped together by the same primary key.

attributes grouped together by the same secondary key.

[#]

17.

A CASE SQL statement is which of the following?

A way to establish an IF-THEN-ELSE in SQL.

A way to establish a loop in SQL.

A way to establish a data definition in SQL.

All of the above.

[#]

18.

Most plug-ins download slowly because they are rather large files.

True

False

[#]

19.

Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

True

False

[#]

20.

Composition does not allow an object to be part of more than one aggregate object.

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