MIS 4113: Database Management Systems FINAL Review

An entity that represents something that can exist on its own. a.) Strong Entity b.) Weak Entity c.) Parent d.) Child

a

Char is what kind of data type? a.) a fixed length string; any remaining space in field is padded with blanks b.) a variable length string; it holds only the characters you assign it c.) a fixed integer length; any remaining space in field is padded with zeros d.) a fixed date string; it holds a data value

a

Correlated subqueries are useful for checking functional dependencies. a.) True b.) False

a

Creating relationships between tables in database design is done by placing the primary ket of one entity in the other entity as a foreign key. a.) True b.) False

a

SQL Views do not support the ORDER BY clause, thus you cannot sort within a view. a.) True b.) False

a

Surrogate Keys have no meaning to users when shared. a.) True b.) False

a

The 'n' in the alternate key notation represents: a.) the number of the alternate key b.) the column number in that alternate key c.) the row that particular value is in d.) none of the above

a

The SQL keyword CHECK, checks the column characteristics for each column. a.) True b.) False

a

The data type numeric (p[s]) works identically to a decimal. a.) True b.) False

a

The identifier of an entity instance, consists of one or more of the entity's attributes. a.) True b.) False

a

The solid line connection an ID-dependent entity and its parent is a _________ relationship, while the dashed line connecting strong entities or a non-ID Dependent weak entity to its parent is a __________ relationship. a.) identifying; nonidentifying b.) nonidentifying; identifying c.) weak; strong d.) strong; weak

a

What are identifiers? a.) attributes that name or identify entities b.) entities that consist of 2 or more attributes c.) the occurrence of a particular entity class d.) describes an entity's characteristics

a

What is a data model? a.) a plan or blueprint for a database design b.) the occurrence of a particular entity class c.) a supertype entity d.) all the above

a

What is a database design? a.) a set of database specifications that can actually be implemented as a database in a specific DBMS product b.) a plan or blueprint for a data model c.) a more generalized and abstract data model d.) all the above

a

Which of the following is a valid value that Char(2) would return? a.) 1N b.) Y c.) POP d.) 7 e.) all of these are valid values

a

Which of the following is the correct syntax for creating a CustomerName View on the CUSTOMER table that displays the customer's LastName and FirstName, and rename the fields? a.) CREATE VIEW CustomerNameView AS SELECT LastName AS C_LastName, FirstName AS C_FirstName, FROM CUSTOMER; b.) CREATE TABLE CustomerNameView AS SELECT LastName AS C_LastName, FirstName AS C_FirstName, FROM CUSTOMER; c.) CREATE VIEW CustomerNameView SELECT LastName AS C_LastName; FirstName AS C_FirstName; FROM CUSTOMER; d.) CREATE VIEW CustomerNameView SELECT LastName AS C_LastName, FirstName AS C_FirstName, FROM CUSTOMER;

a

_________ occurs when a change to the parent's primary key is applied to the child's foreign key. a.) CASCADE UPDATE b.) CASCADE DELETE c.) UPDATE NO ACTION d.) DELETE NO ACTION

a

_____________ is a virtual table that is constructed from other tables to views. a.) SQL View b.) Truncate tables c.) DBMS d.) Supertype entity

a

A database design is more generalized and abstract that a data model. a.) True b.) False

b

An entity whose existence depends on the presence of another entity. a.) Strong Entity b.) Weak Entity c.) Parent d.) Child

b

Identifiers have entities. a.) True b.) False

b

Many-to-many is a maximum cardinality expressed how? a.) M:M b.) N:M c.) N:N d.) 1:M

b

Strong entities generally do cascade deletes while weak entities generally do not cascade deletes. a.) True b.) False

b

The 'm' in the alternate key notation represents: a.) the number of the alternate key b.) the column number in that alternate key c.) the row that particular value is in d.) none of the above

b

The process of reading and producing a data model form a database schema. a.) SQL CHECK b.) reverse engineering c.) database redesign d.) SQL VIEW

b

VarChar is what kind of data type? a.) a fixed length string; any remaining space in field is padded with blanks b.) a variable length string; it holds only the characters you assign it c.) a fixed integer length; any remaining space in field is padded with zeros d.) a fixed date string; it holds a data value

b

What are composite identifiers? a.) attributes that name or identify entities b.) identifiers that consist of 2 or more attributes c.) the occurrence of a particular entity class d.) describes an entity's characteristics

b

When one supertype entity can relate to one ore more subtype entities, this is ___________. a.) connected b.) inclusive c.) disconnected d.) exclusive

b

__________ indicates the subtype in a super type entity. a.) Cardinality b.) Discriminator c.) Modality d.) Attributes

b

__________ statement is used to remove all data from a table while leaving the table structure intact. a.) CREATE TABLE b.) TRUNCATE TABLE c.) DELETE d.) ALTER TABLE

b

___________ occurs when associated child rows are deleted along with the deletion of a parent row. a.) CASCADE UPDATE b.) CASCADE DELETE c.) UPDATE NO ACTION d.) DELETE NO ACTION

b

_________________ is the identifier of the parent that not does not appear in the identifier of the weak child entity. a.) Supertype Entity b.) Non-ID Dependent Weak Entity c.) ID-Dependent Weak Entity d.) Subtype entity

b

One-to-many is a maximum cardinality expressed how? a.) 1:1 b.) 1:M c.) 1:N d.) N:M

c

The SQL View statement is written as: a.) ORDERY BY b.) CREATE TABLE c.) CREATE VIEW d.) SELECT SQL VIEW

c

The notation for an alternate key is: a.) AK b.) CK1.1 c.) AKn.m d.) Cand.AK

c

What is an entity instance? a.) attributes that name or identify entities b.) entities that consist of 2 or more attributes c.) the occurrence of a particular entity class d.) describes an entity's characteristics

c

Which of the following is NOT a property of a column? a.) NULL status b.) Data Type c.) Relationship d.) Data Constraints e.) all the above are properties of a column

c

Which of the following is a NOT valid value that VarChar(10) would return? a.) Tim b.) Billy Bob c.) Christopher d.) 137_Ricky e.) None of these are valid values

c

__________ statement is used to add rows of data to an existing table. a.) CREATE ROW b.) TRUNCATE TABLE c.) INSERT d.) ALTER TABLE

c

__________ statement is used to delete specific rows in a column. a.) CREATE TABLE b.) TRUNCATE TABLE c.) DELETE d.) ALTER TABLE

c

____________ keys are unique within the table, are assigned when the row is created, and it designed to be short, numeric and fixed. a.) Foreign b.) Candidate c.) Surrogate d.) Composite

c

_____________ is an entity whose identifier includes the identifier of another entity. a.) Supertype Entity b.) Non-ID Dependent Weak Entity c.) ID-Dependent Weak Entity d.) Subtype entity

c

Books on systems analysis and design often identify: a.) conceptual design b.) logical design c.) physical design d.) all the above

d

Data Definition Language (DDL) statements are used for all of the following except, _____________. a.) creating tables b.) relationships c.) structures d.) queries e.) all the above are used

d

Database design includes: a.) measuring twice and cutting once b.) testing the new changes on a test database before making real changes c.) creating a complete back of the operational database before making any structure changes d.) all the above

d

What is the relationship between the identifier of an entity and the primary key of a table? a.) the identifier of the entity shares a 1:1 relationship with the primary key b.) the primary key usually becomes the identifier of the table c.) the primary key serves as a surrogate key for the identifier d.) the identifier of the entity usually becomes the primary key of the table e.) the identifier and the primary key have no direct relationship

d

When one supertype entity relates to, at most, one subtype entity, indicated by the X in the O, this is ___________. a.) connected b.) inclusive c.) disconnected d.) exclusive

d

_________ describe an entity's characteristic. a.) Cardinality b.) Modality c.) Identifiers d.) Attributes

d

__________ indicates whether or not the value of the column can be NULL. a.) Column Name b.) Data Type c.) Remarks d.) NULL status

d

___________ statement is an SQL DDL that is used to change the structure of an existing table. a.) CREATE TABLE b.) TRUNCATE TABLE c.) INSERT d.) ALTER TABLE

d

____________ statement is used to change values of existing rows. a.) INSERT b.) DELETE c.) ADD d.) UPDATE

d

Data Manipulation Language (DML) statements are used for all of the following except, _____________. a.) queries b.) inserting data c.) modifying data d.) deleting data e.) all the above are used

e

ID-Dependent Entities are used for: a.) representing N:M relationships b.) representing association relationships c.) storing multivalued attributes d.) representing archetype/instance relationships e.) all the above

e

What is the use of SQL views? a.) hide columns or rows b.) display results of computations c.) provide level of isolation between table data and users' view of the data d.) assign different processing permissions to different views of the same table e.) all the above

e

When transforming a data model into a database design, creating a table for each entity requires ________________. a.) specifying the primary key b.) specifying the alternate (candidate) key c.) specifying the properties for each column d.) verifying normalization e.) all the above

e