DATABASE QUIZ

Online Examination for Database  Quiz Question And Answer

Online Test

1. Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:

A ? B
A ? C.
A ? (B,C).
(B,C) ? A.
-----------------------------------------------------------------------------------------------------------------
2. The different classes of relations created by the technique for preventing modification anomalies are called:

normal forms
referential integrity constraints
functional dependencies
None of the above is correct
-----------------------------------------------------------------------------------------------------------------
3. A relation is in this form if it is in BCNF and has no multivalued dependencies

second normal form.
third normal form
fourth normal form.
domain/key normal form
-----------------------------------------------------------------------------------------------------------------
4. Row is synonymous with the term

record
relation.
column.
field
-----------------------------------------------------------------------------------------------------------------
5. The primary key is selected from the

composite keys

determinants.
candidate keys
foreign keys
-----------------------------------------------------------------------------------------------------------------
6. The DBMS acts as an interface between what two components of an enterprise-class database system?

Database application and the database
Data and the database
The user and the database application
Database application and SQL
-----------------------------------------------------------------------------------------------------------------
7. Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

IDMS
DB2
dBase-II
R:base
-----------------------------------------------------------------------------------------------------------------
8. The following are components of a database except ________ .

user data
metadata
reports
indexes
-----------------------------------------------------------------------------------------------------------------
9. An application where only one user accesses the database at a given time is an example of a(n) ________ .

single-user database application
multiuser database application
e-commerce database application
data mining database application
-----------------------------------------------------------------------------------------------------------------
10. An on-line commercial site such as Amazon.com is an example of a(n) ________ .

single-user database application
multiuser database application
e-commerce database application
data mining database application
-----------------------------------------------------------------------------------------------------------------
11. Which of the following indicates the maximum number of entities that can be involved in a relationship?

Minimum cardinality
Maximum cardinality
ERD
Greater Entity Count (GEC)
-----------------------------------------------------------------------------------------------------------------
12. The SQL command to create a table is:

MAKE TABLE
ALTER TABLE
DEFINE TABLE
CREATE TABLE
-----------------------------------------------------------------------------------------------------------------
13. Locks placed by command are called ________ .

implicit locks
explicit locks
exclusive locks
shared locks
-----------------------------------------------------------------------------------------------------------------
14. Which of the following locks the item from change but not from read?

Implicit lock
Explicit lock
Exclusive lock
Shared lock
-----------------------------------------------------------------------------------------------------------------
15. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

Differential recovery
Full recovery
Simple recovery
Bulk-logged recovery
-----------------------------------------------------------------------------------------------------------------
16. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?

#
%
&
@
-----------------------------------------------------------------------------------------------------------------
17. The XSLT processor copies the elements of the stylesheet until it finds a command in the format:

SELECT ... FROM ... WHERE.
{item, action}.
{for-each select}.
...<\HTML>.
-----------------------------------------------------------------------------------------------------------------
18. A BI reporting system does not ________ 

create meaningful information
deliver information to users on a timely basis
use statistical procedures to predict future events
use disparate data sources
-----------------------------------------------------------------------------------------------------------------
19. An action assertion must include which of the following?

Anchor object
Action
Corresponding object
All of the above
-----------------------------------------------------------------------------------------------------------------
20. If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?

All fields are stored in one relation
All fields are stored in two relations
All fields are stored in three relations
All fields are stored in four relations
-----------------------------------------------------------------------------------------------------------------
21. Which of the following statements is true about symmetric multiprocessing?

A single copy of the operating system resides in each processor
Useful for situations where data must remain in memory to process.
Bottlenecks increase with uniprocessor systems because tasks are not shared.
The problems of memory contention are unlikely.
-----------------------------------------------------------------------------------------------------------------
22. A goal of data mining includes which of the following?

To explain some observed event or condition
To confirm that data exists
To analyze data for expected relationships
To create a new data warehouse
-----------------------------------------------------------------------------------------------------------------
23. A distributed database has which of the following advantages over a centralized database?

Software cost
Software complexity
Slow Response
Modular growth
-----------------------------------------------------------------------------------------------------------------
24. You can add a row using SQL in a database with which of the following?

ADD
CREATE
INSERT
MAKE
-----------------------------------------------------------------------------------------------------------------
25. Needing to using more complicated SQL in database applications is a(n) ________ of normalization.

advantage
disadvantage
either an advantage or disadvantage
neither an advantage nor disadvantage
-----------------------------------------------------------------------------------------------------------------
Score =
Correct answers: