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 data definition commands make up a(n) ________ .

DDL

DML

HTML

XML

[#]

The condition in a WHERE clause can refer to only one value.

True

False

[#]

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

Three rows have the values Brown, NULL, and Blue in the same column.

One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

[#]

Each entity is represented as a(n):

tuple.

table.

attribute.

file.

[#]

What SQL structure is used to limit column values of a table?

The LIMIT constraint

The CHECK constraint

The VALUE constraint

None of the above is correct.

[#]

There are three SQL data modification operations: insert, modify and delete.

True

False

[#]

The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.

True

False

[#]

Locks placed by the DBMS are explicit locks.

True

False

[#]

SQL Server supports two kinds of indexes: clustered and nonclustered.

True

False

[#]

10.

The ODBC Level 1 API contains which of the following functions?

Browse possible connections and data sources only

Connect to data sources with driver-specific information only

Process a scrollable cursor only

Both 1 and 3 above are in the OBDC Level 1 API.

[#]

11.

An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.

True

False

[#]

12.

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

True

False

[#]

13.

Generalization is the process of defining more general entity types from a set of more specialized entity types.

True

False

[#]

14.

Which of the following is an advantage of partitioning?

Complexity

Inconsistent access speed

Extra space

Security

[#]

15.

Embedded SQL is which of the following?

Hard-coded SQL statements in a program language such as Java.

The process of making an application capable of generating specific SQL code on the fly.

Hard-coded SQL statements in a procedure.

Hard-coded SQL statements in a trigger.

[#]

16.

Joining is the process of partitioning data according to predefined criteria.

True

False

[#]

17.

The semijoin approach saves network traffic.

True

False

[#]

18.

An object can have which of the following multiplicities?

Zero

One

More than one

All of the above.

[#]

19.

Which of the following is a technique for hiding the internal implementation details of an object?

Encapsulation

Polymorphism

Inheritance

All of the above.

[#]

20.

Which of the following is true concerning the following statement: class Manager extends Employee

Manager is a concrete class and a superclass.

Manager is a concrete class and a subclass.

Manager is an abstract class and a superclass.

Manager is an abstract class and a subclass.

[#]

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