Online Database Test - Database Test 7



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 HAVING clause does which of the following?

A.
Acts like a WHERE clause but is used for groups rather than rows.
B.
Acts like a WHERE clause but is used for rows rather than columns.
C.
Acts like a WHERE clause but is used for columns rather than groups.
D.
Acts EXACTLY like a WHERE clause.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


2.

The keyword BETWEEN can be used in a WHERE clause to refer to a range of values.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


3.

In the relational model, relationships between relations or tables are created by using:

A.
composite keys.
B.
determinants.
C.
candidate keys.
D.
foreign keys.

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


4.

When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.

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


5.

Which is not true about surrogate keys?

A.
They are short.
B.
They are fixed.
C.
They have meaning to the user.
D.
They are numeric.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


6.

For every relationship, how many possible sets of minimum cardinalities are there?

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

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


7.

All primary keys are required.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


8.

If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.

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


9.

Information systems and organizations do not just influence each other; they create each other.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


10.

To see the contents of the SQL*Plus buffer, type:

A.
CONTENTS.
B.
BUFFER.
C.
CURRENT.
D.
LIST.

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.

SQL*Plus is a text editor.

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


12.

SQL Server automatically creates an index on:

A.
primary keys only.
B.
foreign key only.
C.
both primary and foreign keys.
D.
SQL Server never automatically creates an index.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


13.

In OLE DB, actions that an object can perform are called:

A.
properties.
B.
collections.
C.
methods.
D.
abstractions.

Your Answer: Option (Not Answered)

Correct Answer: Option C

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

Discuss about this problem : Discuss in Forum


14.

An application that uses the ODBC interface could process any database that is ODBC-compliant without any program coding changes.

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


15.

Business Intelligence (BI) reporting analyses can be performed using ________ .

A.
standard SQL only
B.
extensions to SQL only
C.
OLAP only
D.
both standard SQL and extensions to SQL

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.

Another name for multimedia data is unstructured data.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


17.

A function returns one value and has only output parameters.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


18.

Which of the following statements is true concerning JDBC?

A.
It is language independent.
B.
It is similar in concept to ODBC.
C.
It is useful for all object-oriented languages.
D.
It consists of three main layers.

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Client-Server Database

Discuss about this problem : Discuss in Forum


19.

Data replication is favored where most process requests are read-only and where the data are relatively static.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Distributed Databases

Discuss about this problem : Discuss in Forum


20.

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

A.
Manager is a concrete class and a superclass.
B.
Manager is a concrete class and a subclass.
C.
Manager is an abstract class and a superclass.
D.
Manager is an abstract class and a subclass.

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.