Online Database Test - Database Test 4



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.

Because it contains a description of its own structure, a database is considered to be ________ .

A.
described
B.
metadata compatible
C.
self-describing
D.
an application program

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


2.

The command to eliminate a table from a database is:

A.
REMOVE TABLE CUSTOMER;
B.
DROP TABLE CUSTOMER;
C.
DELETE TABLE CUSTOMER;
D.
UPDATE TABLE CUSTOMER;

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


3.

When the parent entity is required, a new child row can always be inserted.

A.
True
B.
False

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.

What is an SQL virtual table that is constructed from other tables?

A.
Just another table
B.
A view
C.
A relation
D.
Query results

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : SQL for Database Construction

Discuss about this problem : Discuss in Forum


5.

Which prefixes are available to Oracle triggers?

A.
:new only
B.
:old only
C.
Both :new and :old
D.
Neither :new nor :old

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Managing Databases with Oracle

Discuss about this problem : Discuss in Forum


6.

What servlet processor was developed by Apache Foundation and Sun?

A.
Apache Tomcat
B.
Apache Web server
C.
Sun servlet processor
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option A

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

Discuss about this problem : Discuss in Forum


7.

What is bytecode?

A.
Machine-specific code
B.
Java code
C.
Machine-independent code
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


8.

Which JDBC driver Types are for use over communications networks?

A.
Type 3 only
B.
Type 4 only
C.
Both Type 3 and Type 4
D.
Neither Type 3 nor Type 4

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


9.

Java bytecode is machine-specific code.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

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

Discuss about this problem : Discuss in Forum


10.

Even though Java is machine-independent, JSPs are not.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

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

Discuss about this problem : Discuss in Forum


11.

In a common form of RFM analysis, customers are sorted in five groups and given a score of 1 to 5 depending on their group.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Database Processing for BIS

Discuss about this problem : Discuss in Forum


12.

The database approach requires additional costs and risks.

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


13.

A time stamp is a time value that is associated with a data value.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Modeling Data in the Organization

Discuss about this problem : Discuss in Forum


14.

Which of the following is true concerning triggers?

A.
You do not create them with SQL.
B.
They execute against only some applications that access a database.
C.
They have an event, condition, and action.
D.
They cannot cascade (cause another trigger to fire).

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : Advanced SQL

Discuss about this problem : Discuss in Forum


15.

A fat client is a PC configured for handling user interfaces and some application processing, usually with no or limited local data storage.

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


16.

Information repositories are replacing data dictionaries in many organizations.

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


17.

A distributed database is which of the following?

A.
A single logical database that is spread to multiple locations and is interconnected by a network
B.
A loose collection of file that is spread to multiple locations and is interconnected by a network
C.
A single logical database that is limited to one location.
D.
A loose collection of file that is limited to one location.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Distributed Databases

Discuss about this problem : Discuss in Forum


18.

Which of the following statement is true concerning objects and/or classes?

A.
An object is an instance of a class.
B.
A class is an instance of an object.
C.
An object includes encapsulates only data.
D.
A class includes encapsulates only data.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


19.

The UML notation is useful for graphically depicting an object-oriented analysis or design model.

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


20.

The ODMG Object Model requires that a relationship be specified in both directions.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

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.