Online Database Test - Database Test 1



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.

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

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.

ORDER BY can be combined with the SELECT statements.

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.

Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?

A.
Weak entity
B.
Strong entity
C.
ID-dependent entity
D.
ID-independent entity

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


4.

Which of the following situation requires the use of ID-dependent entities?

A.
Association relationships only
B.
Multivalued attributes only
C.
Archetype/instance relationships only
D.
All of the above use ID dependent entities

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Data Models into Database Designs

Discuss about this problem : Discuss in Forum


5.

Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

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


6.

The ODBC core API consists of which of the following functions?

A.
Commit or rollback transactions only
B.
Connect to data sources with driver-specific information only
C.
Connect to data sources only
D.
Both 1 and 3 above are in the OBDC core API.

Your Answer: Option (Not Answered)

Correct Answer: Option D

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

Discuss about this problem : Discuss in Forum


7.

An OLE DB interface is specified by a set of objects and the properties and methods that they expose.

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


8.

What standard, protocol or language was generalized to become a standard protocol for sending messages of any type, using any protocol?

A.
SOAP
B.
SGML
C.
SQL
D.
ADO

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : XML and ADO.NET

Discuss about this problem : Discuss in Forum


9.

Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.

A.
True
B.
False

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


10.

A shared database should:

A.
be accurate and available.
B.
provide for backup and recovery.
C.
be secure.
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


11.

Database management systems were first introduced in the 1950s.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


12.

The primary mechanism for providing context for data is metadata.

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.

The three-schema components include all, but:

A.
internal schema.
B.
conceptual schema.
C.
programming schema.
D.
external schema.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : The Database Development Process

Discuss about this problem : Discuss in Forum


14.

When mapping a supertype/subtype relationship which of the following is true?

A.
The supertype primary key is assigned to each subtype.
B.
The subtype primary key is assigned to each supertype.
C.
There is no link between the supertype/subtype entities.
D.
There is no primary key/foreign key relationship between a supertype/subtype.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Logical Database Design

Discuss about this problem : Discuss in Forum


15.

Well-structured relations encourage anomalies of data.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Logical Database Design

Discuss about this problem : Discuss in Forum


16.

A server-side extension is needed to do what?

A.
Allow a request from a client to access the database.
B.
Allow a request from a client to access a HTML-formatted page.
C.
Allow a request from a client to access Web pages.
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Internet Database Environment

Discuss about this problem : Discuss in Forum


17.

Which of the following is true concerning the standard network protocol for connecting a client to a Web or database server via the Internet?

A.
Both TCP and IP are needed.
B.
TCP is needed but IP is not needed.
C.
TCP is not needed but IP is needed.
D.
Neither TCP and IP are needed.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : The Internet Database Environment

Discuss about this problem : Discuss in Forum


18.

The problem of concurrency control is more complex in a distributed database.

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


19.

An operation that alters the state of an object is known as a constructor operation.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


20.

An attribute's value is always literal.

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.