Online Database Test - Database Test 9



Loading...  Loading Test...

Instruction:

  • This is a FREE online test. DO NOT pay money to anyone to attend this test.
  • Total number of questions : 20.
  • Time alloted : 30 minutes.
  • Each question carry 1 mark, no negative marks.
  • DO NOT refresh the page.
  • All the best :-).


1.

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

A.
LIKE only
B.
IN only
C.
NOT IN only
D.
IN and NOT IN

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


2.

A subquery in an SQL SELECT statement is enclosed in:

A.
braces -- {...}.
B.
CAPITAL LETTERS.
C.
parenthesis -- (...) .
D.
brackets -- [...].

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


3.

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.

A.
ONLY
B.
UNIQUE
C.
DISTINCT
D.
SINGLE

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


4.

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

A.
DDL
B.
DML
C.
HTML
D.
XML

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


5.

Multivalued dependencies should ________ be eliminated.

A.
always
B.
commonly
C.
seldom
D.
never

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Design Using Normalization

Discuss about this problem : Discuss in Forum


6.

Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Database Design Using Normalization

Discuss about this problem : Discuss in Forum


7.

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

A.
Supertype entity
B.
Subtype entity
C.
Archetype entity
D.
Instance entity

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Modeling with ER Model

Discuss about this problem : Discuss in Forum


8.

Which of the following is an SQL trigger supported by Oracle?

A.
BEFORE
B.
INSTEAD OF
C.
AFTER
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : SQL for Database Construction

Discuss about this problem : Discuss in Forum


9.

The SQL statement used to create a view is CREATE VIEW.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL for Database Construction

Discuss about this problem : Discuss in Forum


10.

A tool that can help designers understand the dependencies of database structures is a:

A.
dependency graph.
B.
data model.
C.
graphical display.
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


11.

Money is defined in Oracle with the Currency data type.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Managing Databases with Oracle

Discuss about this problem : Discuss in Forum


12.

Oracle, the world's most popular DBMS, is powerful and robust, running on many different operating systems.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Managing Databases with Oracle

Discuss about this problem : Discuss in Forum


13.

Legacy data is which of the following?

A.
Data contained in a newly-installed system
B.
Data rejected during the installation of a new system
C.
Data contained in a file system
D.
Data contained by a system used prior to the installation of a new system

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


14.

Which of the following is true for a relational database?

A.
Data is represented by tables.
B.
It is difficult to access data.
C.
Complex programs have to be written for simple queries.
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


15.

If an entity adheres to the disjoint rule, then an entity instance can be a member of more than one entity for a given supertype.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : ER Model and Business Rules

Discuss about this problem : Discuss in Forum


16.

Hashing algorithm converts a primary key value into a record address.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Physical Database Design

Discuss about this problem : Discuss in Forum


17.

It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Physical Database Design

Discuss about this problem : Discuss in Forum


18.

ROLLBACK WORK asks SQL to empty the log file.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


19.

Activities of a DBMS occur in the processing component logic.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Client-Server Database

Discuss about this problem : Discuss in Forum


20.

The extract process is which of the following?

A.
Capturing all of the data contained in various operational systems
B.
Capturing a subset of the data contained in various operational systems
C.
Capturing all of the data contained in various decision support systems
D.
Capturing a subset of the data contained in various decision support systems

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Warehousing

Discuss about this problem : Discuss in Forum


Submit your test now to view the Results and Statistics with answer explanation.