Online Database Test - Database Test 5



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 projects illustrates a database being designed from existing data?

A.
A database using the Production Department's spreadsheets
B.
A database designed to produce production reports for a new Production Department manufacturing process
C.
A database that will combine two databases currently used by the Production Department
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to Database

Discuss about this problem : Discuss in Forum


2.

A view is which of the following?

A.
A virtual table that can be accessed via SQL commands
B.
A virtual table that cannot be accessed via SQL commands
C.
A base table that can be accessed via SQL commands
D.
A base table that cannot be accessed via SQL commands

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


3.

The keyword LIKE 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 B

Learn more problems on : Introduction to SQL

Discuss about this problem : Discuss in Forum


4.

When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:

A.
first step.
B.
second step.
C.
third step.
D.
fourth step.

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.

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

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

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


6.

A foreign key is used to implement relationships between tables.

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


7.

The data model produced from the reverse engineering process does not include intersection table data.

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.

Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?

A.
Nonrepeatable read
B.
Phantom read
C.
Dirty read
D.
Consistent read

Your Answer: Option (Not Answered)

Correct Answer: Option B

Learn more problems on : Managing Multiuser Databases

Discuss about this problem : Discuss in Forum


9.

Which of the following is not a factor in determining the concurrency control behavior of SQL Server?

A.
Lock level
B.
Transaction isolation level
C.
Cursor concurrency setting
D.
Locking hints

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : SQL Server 2000

Discuss about this problem : Discuss in Forum


10.

ODBC conformance levels specify which SQL statements, expressions, and data types a driver can process.

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


11.

HTML is an application of a more robust document markup language called:

A.
XHTML.
B.
XML.
C.
SGML.
D.
None of the above is correct.

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : XML and ADO.NET

Discuss about this problem : Discuss in Forum


12.

OLAP uses measures, dimensions and associations.

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


13.

Which of the following types of databases are the most common?

A.
Personal
B.
Workgroup
C.
Department
D.
Enterprise

Your Answer: Option (Not Answered)

Correct Answer: Option C

Learn more problems on : The Database Environment

Discuss about this problem : Discuss in Forum


14.

A binary relationship is a relationship between two or more entities.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option B

Explanation:

Binary relationship is the relationship between two entities. Not more than two.

Learn more problems on : Modeling Data in the Organization

Discuss about this problem : Discuss in Forum


15.

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Logical Database Design

Discuss about this problem : Discuss in Forum


16.

Both ASP and ColdFusion allow for the coding of custom tags within an HTML document.

A.
True
B.
False

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.

Every key used to join the fact table with a dimensional table should be a surrogate key.

A.
True
B.
False

Your Answer: Option (Not Answered)

Correct Answer: Option A

Learn more problems on : Data Warehousing

Discuss about this problem : Discuss in Forum


18.

The term Incomplete for a UML has the same meaning as which of the following for an EER diagram?

A.
Overlapping rule
B.
Disjoint rule
C.
Total specialization rule
D.
Partial specialization rule

Your Answer: Option (Not Answered)

Correct Answer: Option D

Learn more problems on : Object-Oriented Data Modeling

Discuss about this problem : Discuss in Forum


19.

Composition does not allow an object to be part of more than one aggregate object.

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.

An atomic literal is which of the following?

A.
Strings
B.
Boolean
C.
Long
D.
All of the above.

Your Answer: Option (Not Answered)

Correct Answer: Option D

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.