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!

SQL query and modification commands make up a(n) ________ .

DDL

DML

HTML

XML

[#]

SQL is:

a programming language.

an operating system.

a data sublanguage.

a DBMS.

[#]

The SQL keyword(s) ________ is used with wildcards.

LIKE only

IN only

NOT IN only

IN and NOT IN

[#]

________ was adopted as a national standard by ANSI in 1992.

Oracle

SQL

Microsoft Access

DBase

[#]

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

[#]

Which of the following is NOT a basic element of all versions of the E-R model?

Entities

Attributes

Relationships

Primary keys

[#]

An identifier determines the type of relationship that an entity has.

True

False

[#]

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

True

False

[#]

To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

a particular column in a particular underlying table.

a particular column in a particular row.

a particular row in a particular underlying table.

None of the above is correct.

[#]

10.

Before any changes to database structure are attempted one should first:

clearly understand the current structure and contents of the database only.

test any changes on a test database only.

create a complete backup of the operational database only.

All of the above should be done.

[#]

11.

What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

Application failure

Instance Failure

Media Failure

Rollback failure

[#]

12.

An OLE DB rowset is equivalent to a cursor.

True

False

[#]

13.

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>.

[#]

14.

The "curse of dimensionality" relates to which problem of using operational data for BI reporting?

Dirty data

Inconsistent data

Too much data

Non-integrated data

[#]

15.

Which of the following database activities determines the entities, attributes, and relationships of data?

Conceptual data modeling

Logical database design

Physical database design and definition

Database implementation

[#]

16.

With an enterprise data model, it is much easier to build applications because you know exactly what data exist and what needs to be added.

True

False

[#]

17.

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

True

False

[#]

18.

Which of the following is the preferred way to recover a database after a transaction in progress terminates abnormally?

Rollback

Rollforward

Switch to duplicate database

Reprocess transactions

[#]

19.

The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex.

True

False

[#]

20.

The UML notation is useful for graphically depicting an object-oriented analysis or design model.

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