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!

To define what columns should be displayed in an SQL SELECT statement:

use FROM to name the source table(s) and list the columns to be shown after SELECT.

use USING to name the source table(s) and list the columns to be shown after SELECT.

use SELECT to name the source table(s) and list the columns to be shown after USING.

use USING to name the source table(s) and list the columns to be shown after WHERE.

[#]

To establish a range of values, < and > can be used.

True

False

[#]

Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?

Supertype entity

Subtype entity

Archetype entity

Instance entity

[#]

Relationship classes are associations between entity classes.

True

False

[#]

In 1:N relationships, which entity becomes the parent entity is arbitrary.

True

False

[#]

Dirty read, nonrepeatable, and phantom reads are not possible in this instance.

Read committed

Read uncommitted

Repeatable read

Serializable

[#]

The default extension for SQL*Plus is .sql.

True

False

[#]

An abstraction is a generalization of something.

True

False

[#]

The DTD begins with the word:

#PCDATA.

XML.

DOCTYPE.

HTTPS.

[#]

10.

FOR XML EXPLICIT tells SQL Server to place the values of the columns as attributes in the resulting XML document.

True

False

[#]

11.

The goal of information systems planning is to align information technology with the business strategies of the organization.

True

False

[#]

12.

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

True

False

[#]

13.

An entity name should be which of the following?

A singular noun

Specific to the organization

Concise

All of the above.

[#]

14.

A logical representation of the data for an organization or for a business area is known as an entity-relationship model.

True

False

[#]

15.

When mapping a many-to-many unary relationship into a relation which of the following is true?

One relation is created.

Two relations are created.

Three relations are created.

Four relations are created.

[#]

16.

A composite attribute does not get mapped into a relation.

True

False

[#]

17.

A transaction is the complete set of closely related update commands that must all be done, or none of them done, for the database to remain valid.

True

False

[#]

18.

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

True

False

[#]

19.

An operation that alters the state of an object is known as a constructor operation.

True

False

[#]

20.

Which of the following is an ordered collection of elements of the same type?

Set

Bag

List

Dictionary

[#]

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