Online Database Test - Database Test 8



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.

Which of the following is valid SQL for an Index?

A.
CREATE INDEX ID;
B.
CHANGE INDEX ID;
C.
ADD INDEX ID;
D.
REMOVE INDEX ID;

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


2.

An attribute that names or identifies entity instances is a(n):

A.
entity.
B.
attribute.
C.
identifier.
D.
relationship.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Data Modeling with ER Model

Discuss about this problem : Discuss in Forum


3.

Each entity is represented as a(n):

A.
tuple.
B.
table.
C.
attribute.
D.
file.

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


4.

In a 1:1 relationship, the primary key placement is arbitrary.

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


5.

Before any changes to database structure are attempted one should first:

A.
clearly understand the current structure and contents of the database only.
B.
test any changes on a test database only.
C.
create a complete backup of the operational database only.
D.
All of the above should be done.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


6.

Changing cardinalities in a database is:

A.
a common database design task.
B.
a rare database design task, but does occur.
C.
a database design task that never occurs.
D.
is impossible to do, so a new database must be constructed and the data moved into it.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


7.

The NOT EXISTS keyword will be true if any row in the subquery meets the condition.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Database Redesign

Discuss about this problem : Discuss in Forum


8.

A cursor type in which the application can only move forward through the recordset is called:

A.
forward only.
B.
static.
C.
keyset.
D.
dynamic.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Managing Multiuser Databases

Discuss about this problem : Discuss in Forum


9.

In ODBC, a data source that is local to a single computer is called a:

A.
system data source.
B.
file data source.
C.
user data source.
D.
SQL text file.

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


10.

How does Tomcat execute a JSP?

A.
As a CGI script
B.
As an independent process
C.
By one of Tomcat's threads
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option C

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

Discuss about this problem : Discuss in Forum


11.

The data warehouse DBMS needs to be the same DBMS used for the operational database.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


12.

The systems development life cycle cannot be used with database implementation.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Database Development Process

Discuss about this problem : Discuss in Forum


13.

Which of the following conditions should exist if you want to convert a relationship to an associative entity?

A.
Some of the relationships for the participating entities are "many".
B.
The resulting associative entity has an independent meaning.
C.
The resulting associative entity has no attributes.
D.
All of the above

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Modeling Data in the Organization

Discuss about this problem : Discuss in Forum


14.

A rectangle represents which of the following in an EER?

A.
Attribute
B.
Entity
C.
Optional One
D.
Relationship

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


15.

A subtype discriminator is which of the following?

A.
An attribute of the supertype whose values determine the subtype
B.
An attribute of the subtype whose values determine the supertype
C.
An attribute of the supertype whose values determine the supertype
D.
An attribute of the subtype whose values determine the subtype

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : ER Model and Business Rules

Discuss about this problem : Discuss in Forum


16.

The primary goal of physical database design is data processing efficiency.

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.

Hypertext Transfer Protocol (HTTP) is secure.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Internet Database Environment

Discuss about this problem : Discuss in Forum


18.

Performance analysis and tuning is which of the following?

A.
Undertaken one time at the time of a DBMS installation
B.
Undertaken one time at the time of the implementation of a new application
C.
Undertaken as an ongoing part of the backup of a database
D.
Undertaken as an ongoing part of managing a database

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.

Queries that do full table scans should be avoided.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data and Database Administration

Discuss about this problem : Discuss in Forum


20.

In an object diagram, an object is represented as a rectangle with two compartments.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


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