CS403 - Database Management Systems

An entity type is
• defined when the database is actually constructed.
• a specific type such as an integer, text, date, logical etc.
• a coherent set of similar objects that we want to store data on (e.g. STUDENT,COURSE, CAR).
• Defined by the database designer.


Question # 6 of 10 ( Start time: 11:30:35 AM ) Total Marks: 1
Which of the following is NOT a component of a DFD?
Dataflow
Datastore
External entities
Relationship between external entities c
Question # 10 of 10 ( Start time: 11:34:22 AM ) Total Marks: 1
A________is used to maintain a connection between the users of the database system.
mail server
file server 48
client-server
none of the given
Question # 2 of 10 ( Start time: 11:18:38 AM ) Total Marks: 1
User rights information is stored in
Physical database
Catalog c
Logical database
Buffer
Data about data is database
True c
False
Partially True
None of the Above
Question # 9 of 10 ( Start time: 11:33:11 AM ) Total Marks: 1
An instance is
a particular occurance of an entity
a special type of relation
an attribute of an entity c p75
any particular entity
Question # 2 of 10 ( Start time: 03:32:15 PM ) Total Marks: 1
The most widely used conceptual model is the ____ model. 69 implementation
ER c 69
Object Oriented
Internal
Question # 6 of 10 ( Start time: 11:22:28 AM ) Total Marks: 1
Who is responsible for authorizing access to the database, for coordinating and monitoring its use?
Database Designer
Database Administrator
End User
Application Programmer
Within a table, each primary key value ____.
is a minimal superkey
is always the first field in each table
must be numeric
must be unique
Question # 8 of 10 ( Start time: 11:24:50 AM ) Total Marks: 1
Incase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only page 60
Any number of processes
06 Jul 2010,Question # 1 of 10 ( Start time: 10:58:28 AM ) Total Marks: 1
The _________ function helps reduce the need to use mutiple OR conditions.
Select correct option:
Like
IN
AND
BETWEEN
Columns used to uniquely identify individual rows of a given table, may be specified to be not NOT NULL.
True sss
False s
In SQL, which command is used to delete rows from table. DELETE
REMOVE
TRUNCATE
Both I and II
Question # 4 of 10 ( Start time: 10:08:24 AM ) Total Marks: 1
Which of the fllowing clauses allows to sort the records in result set? where
order by
from
having
Question # 6 of 10 ( Start time: 12:19:05 PM ) Total Marks: 1
Which of the following statements creates a database named IMDB. CREATE DATABASE IMDB;
CREATE DB IMDB;
ADD DATABASE named IMDB;
CREATE IMDB DATABASE;
Question # 6 of 10 ( Start time: 11:05:29 AM ) Total Marks: 1
Which of the following SQL statements used to control access to the data and to the database?
GRANT
REVOKE
Both GRANT and REVOKE
SELECT
Question # 5 of 10 ( Start time: 04:41:35 PM ) Total Marks: 1
Which of the following is used with INSERT command to insert values in a DB table?
ONTO
INTO
UPTO
WITH
Question # 8 of 10 ( Start time: 11:08:05 AM ) Total Marks: 1
Which of the following is used to retrieve and insert information from database?
DML
DDL
DCL
Both DML and DDL
SQL commands that allow for the manipulation of data in the database, such as SELECT, INSERT, DELETE, and UPDATE.
Question # 4 of 10 ( Start time: 12:18:11 PM ) Total Marks: 1
In SQL queries, while creating tables or relations in database, key columns may be specified by Null
Not Null
Data Type
None of the above
Question # 10 of 10 ( Start time: 11:10:53 AM ) Total Marks: 1
Which of the following is not an aggregate function
AVG
SUM
UPPER
MAX
07 Jul 2010Question # 1 of 10 ( Start time: 11:02:31 PM ) Total Marks: 1
SQL is used for:
Creating, managing and deleting tables and manage the relationships among the stored date.
Generating queries, organizing, managing and retrieving data stored in a database.
Maintaining data integrity and coordinate data sharing.
All of the above
Question # 2 of 10 ( Start time: 04:37:30 PM ) Total Marks: 1
Which of the following is incorrect about alter table statement?
Cannot be used to modify type or size of an existing column ( Not Sure )
Can be used to delete a column
Can not be used to create a new table
Can be used to add column in the existing table
Question # 7 of 10 ( Start time: 10:09:26 AM ) Total Marks: 1
CREATE TABLE and CREATE index belongs to which type of SQL commands DML
DDL
DCL
DQL
# 9 of 10 ( Start time: 04:44:43 PM ) Total Marks: 1
Objective of an order by clause is to display or arrange output of a select statement in a particular order.
True
False
Question # 6 of 10 ( Start time: 04:42:24 PM ) Total Marks: 1
In SQL, which command is used to modify the rows of tables.
UPDATE
INSERT
BROWSE
APPEND
What is the size of TinyInt?
0 to 255
0 to 256
125 to 255
100 to 255
Question # 9 of 10 ( Start time: 11:06:59 PM ) Total Marks: 1
The ________ operator allows to use wild cards in the where clause of an SQL statement.
IN
FROM
LIKE
None of the above.
Question # 5 of 10 ( Start time: 09:54:31 PM ) Total Marks: 1
Which of the following is not true regarding clustering?
It increases the efficiency since related records are placed close to each other
Clustering makes records, difficult to access
suitable to relatively static situations.
It is a process, which means to place records from different tables to place in adjacent physical locations
Post subject: CS403 Current Quiz
PostPosted: 15 May 2010, 2:00 am
2 Making a change to the conceptual schema of a database but not affecting the existing external schemas is an example of

Physical data independence
Logical data independence p44
Functional dependency
Concurrency control

Ans: 2
Question # 2 of 10 ( Start time: 11:27:53 AM ) Total Marks: 1
Which of the following is INCORRECT statement concerning the database design process?

During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified. s

Which of the following is correct regarding Dataflow diagram?
Single DFD is required to represent a system
Created at increasing levels of detail
The dataflow must be bidirectional
Used to represent the relationships among the external entities
7 Each table must have a __ key.
primary
secondary
logical
foreign
ans: 1
A table can be logically connected to another table by defining a __.
hyperlink
common attribute
primary key
superkey
CS403 – Database Management SystemsOnline Quiz # 1May 14, 2010Total Questions: 10
Data Redundancy Means
Security of data
Duplication of data s
Management of data
Recovery of data
A relational database system is based on the concept(s) of:
A network of data records c
Nested tables
Tables, rows and columns
A tree-like structure of data
most commercial DBMS are based on the record-based data models, like Hierarchical, Network or Relational.
Which of the following describes the job of a database administrator?
Development, implementation operation of the physical database
Creation of the system catalog
Monitoring and controlling database security and authorization: Setting up controls to ensure the quality and integrity of data
All of the above
Question # 7 of 10 ( Start time: 01:35:51 PM ) Total Marks: 1
Which levels are mostly used for Detailed DFD?
Level-0, Level-1
Level-1, Level-2
Level-2, Level-3
Level-3, Level-4
Question # 8 of 10 ( Start time: 01:37:01 PM ) Total Marks: 1
A software package designed to store and manage databases
Database
DBMS
Data model
Data
Reference: http://www.wiziq.com/tutorial/32184-Module-in-Database-Management-Systems
Question # 9 of 10 ( Start time: 01:37:58 PM ) Total Marks: 1
A collection of concepts that can be used to describe the structure of a database
Database
DBMS
Data model
Data
Data model is a set or collection of construct used for creating a database and producing designs for the databases

Question # 1 of 10 ( Start time: 11:17:22 AM ) Total Marks: 1
Controlling redundancy in a database management system DOES NOT help to
avoid duplication
avoid unnecessary wastage of storage space
avoid unauthorised access to data
avoid inconsistency among data
Question # 5 of 10 ( Start time: 11:21:45 AM ) Total Marks: 1
A primary key is an attribute (or set of attributes) that has been chosen for an entity, whose values are used to uniquely identify a particular instance of an entity. True or false?
True
False
Partially True
None of the given
Question # 9 of 10 ( Start time: 11:25:39 AM ) Total Marks: 1
In a three-level DBMS architecture, the ______ level interacts directly with the users.
external
conceptual
internal
physical
Question # 10 of 10 ( Start time: 11:26:04 AM ) Total Marks: 1
Which feature of database provides conversion from inconsistent state of DB to a consistent state ensuring minimum data loss?
User accessible catalog
Data processing
Recovery service c
Authorization service
Question # 1 of 10 ( Start time: 11:27:14 AM ) Total Marks: 1
Which of the following describes a database system?
A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above
Question # 2 of 10 ( Start time: 11:27:53 AM ) Total Marks: 1
Which of the following is INCORRECT statement concerning the database design process?
During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.

CS403 – Database Management SystemsOnline Quiz # 1May 14, 2010Total Questions: 10

Question # 7 of 10 ( Start time: 05:57:39 PM ) Total Marks: 1
Which model operates at the lowest level of abstraction?[/justify]
conceptual
internal
external
physical c
Question # 1 of 10 ( Start time: 05:37:59 PM ) Total Marks: 1
A relational database is
one that consists of two or more tables
a database that is able to process tables, queries, forms, reports and macros
one that consists of two or more tables that are joined in some way
the same as a flat file database
Question # 2 of 10 ( Start time: 05:39:21 PM ) Total Marks: 1
]hich model operates at the lowest level of abstraction?[/justify]
conceptual
internal
external
physical
Question # 5 of 10 ( Start time: 05:41:31 PM ) Total Marks: 1
Data about data is metadata

Truec
False
Database is a data structure that stores metadata, i.e. data about data. More generally we can say an organized collection of information.

The Entity Relation Model models
Entities, Relationships and Processes
Entities and Relationships
Relationships
Entities
10 feb
uestion # 1 of 10 ( Start time: 12:55:52 AM ) Total Marks: 1
What does the abbreviation DBMS stand for?
Database Manipulation Software.
Data Borrowing and Movement Software
Digital Base Mapping System.
Database Management System.

Question # 2 of 10 ( Start time: 12:56:24 AM ) Total Marks: 1
Which of the following is not DML command?
Select
Update
Delete
Truncate
GRANT belongs to which type of SQL commands classification
DML
DDL
DCL
DQL
Question # 5 of 10 ( Start time: 12:57:42 AM ) Total Marks: 1
Data Definition Language (DDL) consists of commands used to define a database including creating, altering, dropping tables and establishing constraints.
True
False
Question # 7 of 10 ( Start time: 12:58:12 AM ) Total Marks: 1
DDL has two types of statements, Procedural and Non procedural.
True
False
# 8 of 10 ( Start time: 12:58:25 AM ) Total Marks: 1
Suppose we have two tables T1 and T2. Tuples of T1 that do not match some row in T2 will not appear in
Outer Join
Inner Join
Both I and II
None of the above
Question # 9 of 10 ( Start time: 12:58:45 AM ) Total Marks: 1
Which of the following is NOT a DDL command?
Create DB
Create table
Delete
Drop

Which of the following is a feature of CHECK constraint?
Question # 1 of 10 ( Start time: 11:35:39 AM ) Total Marks: 1
A ____ relationship exists when an association is maintained within a single entity.
Unary c
Binary
Ternary
Weak
a table, each primary key value ____.
is a minimal superkey
is always the first field in each table
must be numeric
must be unique c
The ER model is meant to
replace relational design
be close to a users perception of the data
enable low level descriptions of data
enable detailed descriptions of data query processing
Question # 9 of 10 ( Start time: 05:13:37 PM ) Total Marks: 1
A Foreign Key is
A field in a table that matches a key field in another table
A field in a table that contains data that is also contained elsewhere in another table
A field in a table that has the same name as a key field in another table
A field in a table that has the same name as a key field in another table

Question # 6 of 10 ( Start time: 12:17:25 PM ) Total Marks: 1
Which of the following functions are NOT performed by a database administrator?
Planning, designing and implementing database systems
Establishing standards and procedures for database systems
Communicating with database users
Allocation of storage locations and data structures
Question # 6 of 10 ( Start time: 11:40:28 AM ) Total Marks: 1
Identify the constraint that limits the values that can be placed in a column.
Select correct option:

NOT NULL
CHECK c
FOREIGN KEY
UNIQUE

Question # 7 of 10 ( Start time: 11:41:15 AM ) Total Marks: 1
Which of the following describes a database system?
A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data. c
All of the above
Question # 9 of 10 ( Start time: 11:44:01 AM ) Total Marks: 1
The main software package that supports a database management approach is called
Data Dictionary
Report Generator
Database Management System c
Distributed database
of the following might be represented with a multivalued attribute?
person's name
class location
bank account balance c
book title
/




1st
Question # 9 of 10 ( Start time: 11:25:39 AM ) Total Marks: 1
In a three-level DBMS architecture, the ______ level interacts directly with the users.
external
conceptual
internal
physical
Question # 1 of 10 ( Start time: 11:27:14 AM ) Total Marks: 1
Which of the following describes a database system?
A collection of stored operational data used by the application system of some particular enterprise
A shared collection of logically related data (and a description of this data) designed to meet the information needs of an organisation
A collection of stored data organised in such a way that all user requirements are satisfied by the database. In general there is only one copy of each item of data although there may be controlled repetition of some data.
All of the above

Data about data is database
True
False
Partially True
None of the Above
one that consists of two or more tables c
a database that is able to process tables, queries, forms, reports and macros
one that consists of two or more tables that are joined in some way
the same as a flat file database
Question # 3 of 10 ( Start time: 03:58:44 PM ) Total Marks: 1
Which one of the following is NOT a characteristic of meta data?
Data about data
Describes a data dictionary
Self-describing
Includes user data
Q3
A description on a particular collection of data using the given data model
Database
Relation
Schema
None
A candidate key that does not have a null value and is selected to uniquely identify all other attribute values in any given row is called a __.
superkey
candidate key
primary key
secondary key
cs403_quiz_1

CS403_Quiz#2 Solved
Question # 1 of 10 ( Start time: 04:36:06 PM ) Total Marks: 1
Which of the following is one of the purposes of using DDL commands?
inserting records into databases
updating records into databases
manipulating databases
creating and destroying databases
Question # 7 of 10 ( Start time: 04:43:44 PM ) Total Marks: 1
Identify the basic part(s) of a SELECT statement?
SELECT
FROM
Both SELECT and FROM s
DISTINCT
Question # 10 of 10 ( Start time: 04:46:10 PM ) Total Marks: 1
Which of the following is not a part of an INSERT statement?
INTO
VALUES (Not sure)
INSERT
MODIFY
cs403 squiz #2
Question # 8 of 10 ( Start time: 10:10:21 AM ) Total Marks: 1
Which of the following function falls in the category of Aggregate functions.
SUM
MIN
MAX
All of the above
Question # 5 of 10 ( Start time: 10:08:48 AM ) Total Marks: 1
Which of the following prevents duplicate values to be displayed as a result of an SQL statement?
DISTINCT
DELETE
UPDATE
ALTER
Question # 10 of 10 ( Start time: 10:12:03 AM ) Total Marks: 1
DML does not used to :
add new rows to tables
retrieve rows from table
modify the rows of tables
alter a table definition
Question # 3 of 10 ( Start time: 10:08:07 AM ) Total Marks: 1
The _________ function helps reduce the need to use multiple OR conditions.
Like
IN
AND
BETWEEN

Consider a table named “emp” having fields Empname, EmpID, Age, salary. Which of the following is true if the following SQL statement tries to execute? SELECT * FROM emp WHERE Empname=’ALI’;
The statement has a syntax error
The statement only displays the EmpID of those employees whose name is ALI
The statement displays the entire fields from emp in which the Empname is ALI
The statement must have an ORDERBY clause
Question # 6 of 10 ( Start time: 10:08:56 AM ) Total Marks: 1
Which of the following is NOT a DDL command?
Create DB
Create table
Delete
Drop
Question # 1 of 10 ( Start time: 10:07:29 AM ) Total Marks: 1
DDL stands for _______________.
Data Description Language
Data Diagnostic Language
Data Definition Language
Data Design Language
Question # 9 of 10 ( Start time: 10:10:53 AM ) Total Marks: 1
Truncate command response time is ______ as compared to Delete command.
Poor
Same
Better
worst
CS403 Solved MCQ
SQL stands for ______________.
I - Structured Query Language
II – Standard Query Language
lll- Status Query Language
Only I
Only II
Both I and II
Only lll
Making a change to the conceptual schema of a database but not affecting the existing

SQL data types do not have support for storing multi-media objects directly.
True False
Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
True
Question # 8 of 10 ( Start time: 12:20:05 PM ) Total Marks: 1
In SQL, which command is used to add new rows to a table?
ADD ROW
INSERT
APPEND
ALTER TABLE
Question # 9 of 10 ( Start time: 12:20:36 PM ) Total Marks: 1
Correct statement for creating table in Microsoft SQL server is.
CREATE TABLE Customer (SID integer PRIMARY KEY, Last_Name varchar(30), First_Name varchar(30));
CREATE TABLE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30))
CREATE Customer (SID integer, Last_Name varchar(30), First_Name varchar(30));
All of the above
Question # 10 of 10 ( Start time: 12:21:27 PM ) Total Marks: 1
The ____________ keyword is used in SELECT statement to return different values. LIKE
IN
DISTINCT
WHERE
Question # 3 of 10 ( Start time: 12:33:28 PM ) Total Marks: 1
The ________ condition allows to retrieve values within a specific range. AND
LIKE
BETWEEN
FROM
Question # 10 of 10 ( Start time: 12:36:39 PM ) Total Marks: 1
UPDATE command belongs to which type of Classification DML
DDL
DCL
DQL
CS403 – Database Management Systems Online Quiz # 1 May 14, 2010 Total Questions: 10
Question # 10 of 10 ( Start time: 06:22:31 PM ) Total Marks: 1
Which of the following is the correct syntax for adding a new column into an existing table.

ALTER TABLE table_name { ALTER [COLUMN] column type [(size)] [DEFAULT default] }
ALTER TABLE table_name { ADD [COLUMN] column type [(size)] [DEFAULT default] }
Both I and II.
None of the above.
Which of the following is a correct way of selecting all the columns from a table called PERSONS?
SELECT FROM * Persons
SELECT * FROM Persons
SELECT * WHERE Persons
SELECT WHERE * Persons
Question # 6 of 10 ( Start time: 09:54:55 PM ) Total Marks: 1
Which of the following is used to filter rows according to some condition(s)?
SELECT
FROM
WHERE
UPDATE
Solved by vuZs Team
Making a change to the conceptual schema of a database but not affecting the existing
external schemas is an example of
Physical data independence.
Concurrency control.
Logical data independence.
Functional dependency
Logical data independence
Logical data independence provides the independence in a way that
changes in conceptual model do not af fect the external views. Or
simply i t can be stated at the Immunity of external level f rom
changes at conceptual level .
Truncate is an alternative of Delete command.
True
Fals
What happens if the WHERE clause is omitted from a DELETE statement?
All records from the table are deleted
No record from the table will be deleted
First record of the table will be deleted
The statement will not be executed and will give a syntax error
Query Analyzer is used to practice SQL in MS-Access and MS-SQL Server.
True
False
Which of the following can not be included into CREATE TABLE statement?
Data types
Constraints
Attributes
Cardinalities
A________is used to maintain a connection between the users of the database system.
mail server
file server
client-server
none of the given
A f i le server is used
to maintain a connection between the users of the database system.
Each cl ient of the network runs its own copy of the DBMS and the
database resides on the f i le server .
Which of the following is INCORRECT statement concerning the database design process?
During requirements collection and analysis phase, one can gather the data requirements of database users.
By referring to a high level data model, it is possible to understand the data requirements of the users, entity types, relationships and constraints.
Transformation of the high level data model into the implementation data model is called logical design or data model mapping.
During the logical design phase of internal storage structures, access paths and file organization for the database files are specified.
These things are done at physical design stage not at logical design stage. At logical design stage
Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
True
Cs403_Latest Quiz Solved In Conference By Many Students 14-may-2010 (First Quiz)
identify all other attribute values in any given row is called a __.
superkey
candidate key
primary key
secondary key
Incase of Context-level Diagram, the system is represented by
One process atleast
Two processes atleast
One process only
Any number of processes
Section 1: True/False Questions
Please circle the correct answer:
1. Accurate, relevant, and timely information is the key to good decision making.
True False
2. Metadata provide the description of the data characteristics but do not describe the set relationships that link the data found within the database.
True False
3. A database that is primarily designed to support a company’s day-to-day operations is called a data warehouse.
True False
4. A record is a logically connected set of one or more fields that describes a person, place, or thing.
True False
5. The final outcome of a natural JOIN operation yields a table that does not include the unmatched row.
True False
6. In a relational table, each column represents an attribute and each column has a distinctive name.
True False
7. In a relational table, each value in a column must conform to the same data format.
True False
8. A key consists of one or more attributes that determine other attributes.
True False
9. A primary key can be defined as a superkey with redundancies.
True False
10. To maintain entity integrity, a null value is permitted in the primary key.
True False

Section 2: Multiple Choice Questions
Please select only one of the choices (If more than one is selected, it is considered as incorrect)
1. The DBMS allows you to extrapolate information from your data by using a(n) ____.
a. query language
b. table generator
c. security system
d. access control
2. A ____ system is composed of software, hardware, procedures, and people.
a. software
b. computer
c. file
d. database
3. ____ are the people who run the organization’s daily operations.
a. End users
b. Managers
c. Database programmers
d. Data practitioners
4. Data is/are:
a. information
b. raw facts
c. processed information
d. a DBMS
5. A telephone number, a birth date, and a customer name are all examples of:
a. data
b. a record
c. a file
d. a database
6. A logically connected set of one or more fields that describes a person, place, or thing is a(n):
a. data
b. a record
c. a file
d. a database
7. Metadata is:
a. raw facts
b. data about data
c. user created data
d. warehoused data
8. SQL is:
a. a structured query language
b. a sequencing query language
c. a sequencing query listing
d. a structured query listing
9. A relational database is a group of ____.
a. common fields
b. field values
c. records
d. tables
10. Database models can be grouped into two categories: conceptual models and ____ models.
a. implementation
b. logical
c. physical
d. query
11. Each row in the relational table is known as an entity ____.
a. instance
b. relationship
c. attribute
d. model
12. Which model represents the end user’s view of the database?
a. Internal
b. Conceptual
c. Physical
d. External
13. Which model operates at the lowest level of abstraction?
a. Conceptual
b. Internal
c. External
d. Physical
14. What type of relationship is expressed with the phrase “Painter paints Painting”?
a. 1:M
b. 1:1
c. M:1
d. M:N
15. What type of relationship is expressed with the phrase “Employee manages Store”?
a. 1:M
b. 1:1
c. M:1
d. M:N
16. What type of relationship is expressed with the phrase “Student takes Class”?
a. 1:M
b. 1:1
c. M:1
d. M:N
17. Which of the following is least likely to be a business rule as relates to data modeling?
a. A customer may make many payments on an account.
b. A machine operator may not work more than 10 hours in a 24-hour period.
c. A training session cannot be scheduled for fewer than 10 employees or more than 30 employees.
d. Casual Fridays take place in the summer.
18. The entity integrity rule requires that ____.
a. all primary key entries are unique
b. a part of the key may be null
c. foreign key values do not reference primary key values
d. duplicate object values are allowed
19. The referential integrity rule requires that ____.
a. every null foreign key value must reference an existing primary key value
b. an attribute have a corresponding value
c. every non-null foreign key value reference an existing primary key value
d. you delete a row in one table whose primary key does not have a matching foreign key value in another table
20. Each table must have a ____ key.
a. primary
b. secondary
c. foreign
d. logical
21. A primary key ____.
a. is a minimal superkey
b. is always the first field in each table
c. must be numeric
d. must be unique
22. A relational operator that yields values from all rows in a table is known as the ____ operator.
a. DIFFERENCE
b. PRODUCT
c. SELECT
d. PROJECT
23. A relational operator that yields all values from selected attributes is known as the ____ operator.
a. DIFFERENCE
b. PRODUCT
c. SELECT
d. PROJECT
24. A relational operator that allows for the combination of information from two or more tables is known as the ____ operator.
a. SELECT
b. PROJECT
c. JOIN
d. DIFFERENCE
25. In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table.
a. combined key
b. redundant field
c. primary key
d. foreign key
26. A relational operator that yields all possible pairs of rows from two tables is known as the ____ operator.
a. UNION
b. INTERSECT
c. DIFFERENCE
d. PRODUCT
27. Which of the following statements concerning the primary key is true?
a. All primary key entries are unique.
b. The primary key may be null.
c. The primary key is not required for all tables.
d. The primary key data do not have to be unique.
28. In the context of a database table, the statement “A determines B” indicates that ____.
a. knowing the value of attribute A, you cannot look up the value of attribute B
b. you do not need to know the value of attribute A in order to look up the value of attribute B
c. knowing the value of attribute B, you can look up the value of attribute A
d. knowing the value of attribute A, you can look up the value of attribute B
29. A ____ is any key that identifies each entity uniquely. It functionally determines all of the entity’s attributes.
a. superkey
b. primary key
c. foreign key
d. combined key
30. A superkey that does not contain a subset of attributes that is itself a superkey is called a ____.
a. candidate key
b. primary key
c. superkey
d. secondary key
Section 3: Fill up the empty space with most appropriate word
1. A collection of programs that manages the database structure and controls access to the data stored in the database is called a ______________________________.
DBMS
2. A DBMS that supports more than one user is classified as a ____________________ user.
Multi
3. ____________________, or data about data, through which the end-user data and are integrated and managed.
MetaData
4. ____________________ exists when different versions of the same data appear in different places.
Data inconsistency
5. ____________________ refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data.
Database design
6. The relationship described by the phrase “the Customer generates the Invoice” is ____________________.
one-to-many
7. A(n) ____________________ is a brief, concise, and unambiguous description of a policy.
business rule
8. The query language for a relational database is _________________________.
SQL, structured query language
9. A(n) ____________________ consists of one or more attributes that determine other attributes.
key
10. Another form of JOIN, known as ____________________, links tables on the basis of an equality condition that compares columns of each table.
equijoin
Section 4:
Answer the following questions.
1. Explain why DBMSs are important in our information-based society.
Since data are important, we must have good ways of managing such data. Additionally, a DBMS creates an environment with better access to more and better data, makes it possible for end users to respond quickly to changes in their environment, and makes available data that can be easily transformed into usable information.
2. Explain data redundancy and what it sets the stage for.
Data redundancy occurs when the same data is stored in different locations; Redundancy creates data inconsistency, which results from different and conflicting versions of the same data in different places, and data anomalies, as a result of the need to modify the same data in different locations.
3. List the different types of relationships and provide an example of each.



There are three types of relationships:
1) One-to-One (1:1) relationships: Employee manages Store
2) One-to-Many (1:M) relationships: Painter paints Painting
3) Many-to-Many (M:N or M:M) relationships: Student takes Class