Online Database Test - Database Test 6



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.

A database design may be based on existing data.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


2.

The result of a SQL SELECT statement is a(n) ________ .

A.
report
B.
form
C.
file
D.
table

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


3.

To sort the results of a query use:

A.
SORT BY.
B.
GROUP BY.
C.
ORDER BY.
D.
None of the above is correct.

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 is:

A.
a programming language.
B.
an operating system.
C.
a data sublanguage.
D.
a DBMS.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


5.

A relation in this form is free of all modification anomalies.

A.
First normal form
B.
Second normal form
C.
Third normal form
D.
Domain/key normal form

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


6.

In a relation, the columns are sometimes called "attributes."

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Relational Model and Normalization

Discuss about this problem : Discuss in Forum


7.

Proper normalization eliminates duplicated data.

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


8.

One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Design Using Normalization

Discuss about this problem : Discuss in Forum


9.

An identifier typically uses more than one attribute.

A.
True
B.
False

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


10.

The default extension for an Oracle SQL*Plus file is:

A.
.txt.
B.
.pls.
C.
.ora.
D.
.sql.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Managing Databases with Oracle

Discuss about this problem : Discuss in Forum


11.

An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:

A.
COBOL.
B.
VB.NET.
C.
TRANSACT SQL.
D.
Visual Basic.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


12.

READ COMMITTED is the default isolation level.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


13.

OLE DB tabular data providers present data in the form of rowsets.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : ODBC, OLE DB, ADO, and ASP

Discuss about this problem : Discuss in Forum


14.

How many JDBC driver types does Sun define?

A.
One
B.
Two
C.
Three
D.
Four

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : JDBC, Java Server Pages, and MySQL

Discuss about this problem : Discuss in Forum


15.

The "F" in RFM analysis stands for ________ .

A.
frequently
B.
freshness
C.
fast food
D.
fantasy

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


16.

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

A.
Equi-join
B.
Natural join
C.
Outer join
D.
Cartesian join

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


17.

A benefit of the three-tier architecture is which of the following?

A.
New modules can be built to support specific business needs
B.
Performance improves for compiled SQL statements
C.
Results in a thinner client and database server
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Client-Server Database

Discuss about this problem : Discuss in Forum


18.

Which of the following is part of an administrative policy to secure a database?

A.
Authentication policies
B.
Limiting particular areas within a building to only authorized people
C.
Ensure appropriate responses rates are in external maintenance agreements
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Data and Database Administration

Discuss about this problem : Discuss in Forum


19.

A semijoin is which of the following?

A.
Only the joining attributes are sent from one site to another and then all of the rows are returned.
B.
All of the attributes are sent from one site to another and then only the required rows are returned.
C.
Only the joining attributes are sent from one site to another and then only the required rows are returned.
D.
All of the attributes are sent from one site to another and then only the required rows are returned.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Distributed Databases

Discuss about this problem : Discuss in Forum


20.

A collection of literals or object types is called a bag.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Object-Oriented Database

Discuss about this problem : Discuss in Forum


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