C175 Data Management Foundations

The SQL SELECT command is used to ____ a relational database. a) retrieve data from b) update records in c) insert new records into d) delete records from e) None of the above.

A

The SQL command that lets you insert data into a table, one row at a time, is ____. a) INSERT b) SELECT c) COMMIT d) UPDATE

A

The SQL CREATE TABLE command is capable of doing all of the following, except ____. a) building indexes b) specifying which attributes are unique c) specifying which attributes serve as the primary key d) specifying referential integrity constraints (e.g. cascade) e) specifying which attributes serve as foreign keys

A

The SQL SELECT DISTINCT operator ____. a) eliminates duplicate rows in the output of an SQL SELECT command b) eliminates duplicate columns in the output of an SQL SELECT command c) eliminates duplicate attribute values within a row of the output of an SQL SELECT command d) eliminates duplicate attribute values within a column of the output of an SQL SELECT command e) None of the above.

A

A binary relationship is a relationship between two _____. a) entity types b) attribute types c) associations d) files e) cardinalities

A

A business school's faculty parking lot has assigned parking spaces. Each professor is entitled to one parking space. This is an example of a _____ relationship. a) one-to-one binary b) one-to-many binary c) many-to-many binary d) one-to-one unary e) one-to-many unary

A

A one-to-one unary relationship _____. a) involves a single entity type b) involves two entity types c) allows an occurrence of one entity type to be associated with several occurrences of another entity type d) allows an occurrence of one entity type to be associated with several occurrences of another entity type and vice versa e) allows an occurrence of one entity type to be associated with several occurrences of the same entity type

A

A single piece of data is _____ the business environment. a) a fact about (data can be any form, not necessary be a record) b) a record describing an object in c) the same thing as an object in d) a file describing an object in e) an event in

A

A table can be deleted from the database by using the ____ command. a) DROP b) DELETE c) MODIFY d) ERASE

A

A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key, is said to be in ____. a) 1NF b) 2NF c) 3NF d) 4NF

A

A value that is a foreign key in one relation of a database must be ____ another relation in the database. a) the primary key of b) a secondary key of c) an alternate key of d) a non-unique attribute or combination of attributes of e) None of the above.

A

All of the following are basic principles of the database concept, except _____. a) maintaining redundant data that does not cause data integrity problems b) the ability to store data in a non-redundant fashion c) the ability to store data representing entities involved in multiple relationships d) striving to achieve a high degree of data independence e) data integration

A

An attribute (or combination of attributes) that uniquely identifies each entity in a table is called a ____. a) superkey b) candidate key c) primary key d) secondary key

A

Database models were developed to ____. a) model real-world events or conditions b) deposit data within a single file c) keep data within multiple data repositories d) allow DBMSs to maintain loose control over the database activities

A

Given the table: EMP_PROJ (PROJ_NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS, CHG_HOURS, HOURS) Which of the following is a partial dependency? a) PROJ_NUM --> PROJ_NAME b) JOB_CLASS --> CHG_HOUR c) PROJ_NUM, EMP_NUM --> HOURS d) PROJ_NUM, EMP_NUM --> CHG_HOURS

A

If an entity can exist apart from one or more related entities, it is said to be ____-independent. a) existence b) relationship c) business d) weak

A

In the SQL SELECT command, the attributes to be retrieved are specified in the ____ clause. a) SELECT b) PROJECT c) FROM d) WHERE e) RETRIEVE

A

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

A

The modality of a relationship is _____. a) The minimum number of entities that can be involved in the relationship. b) The maximum number of entities that can be involved in the relationship. c) The minimum number of attributes that can be in the entity types in a relationship. d) The maximum number of attributes that can be in the entity types in a relationship. e) The minimum number of associations that can be involved in the relationship.

A

The set of possible values for an attribute is a ____. a) domain b) range c) set d) key

A

What type of relationship is expressed with the phrase "A Painter paints one or more Paintings"? a) 1:M b) 1:1 c) M:1 d) M:N

A

When designing a new database, it is a good idea to ____. a) minimize data redundancy b) include redundant fields c) include a common field in all tables d) use composite keys

A

Which classification is correct for the box marked "Registration" in the given E-R Diagram? a) Intersection data b) Modality data c) Cardinality data d) Student data

A

Which command would be used to delete the table row where the P_Code = '2238/QPD'? a) DELETE FROM PRODUCT WHERE P_CODE = '2238/QPD'; b) REMOVE FROM PRODUCT WHERE P_CODE = '2238/QPD'; c) ERASE FROM PRODUCT WHERE P_CODE = '2238/QPD'; d) ROLLBACK FROM PRODUCT WHERE P_CODE = '2238/QPD';

A

Which of the following does not change the contents of a table? a) retrieve b) insert c) delete d) update e) all of the above

A

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.

A

Which query will list all the rows in which the inventory stock dates occur on or after January 20, 2006? a) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= '01/20/2006' b) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= #01/20/2004# c) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= '20-JAN-2004' d) SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE FROM PRODUCT WHERE P_INDICATE >= {01-20-2004}

A

A ____ attribute is one that cannot be subdivided. a) composite b) atomic c) single-valued d) multivalued

B

A derived attribute ____. a) must be stored physically within the database b) need not be physically stored within the database c) has many values d) must be based on the value of three or more attributes

B

A many-to-many unary relationship allows an occurrence of one entity type to be associated with _____. a) a single occurrence of the same entity type b) multiple occurrences of the same entity type(e.g. Bill-of-Material, "Component" as a table). c) a single occurrence of another entity type d) multiple occurrences of another entity type e) multiple occurrences of three entity types

B

A one-to-many unary relationship allows an occurrence of the entity type on the "one side" of the relationship to be associated with _____. a) a single occurrence of the same entity type b) multiple occurrences of the same entity type c) a single occurrence of the different entity type on the "many side" of the relationship d) multiple occurrences of the different entity type on the "many side" of the relationship e) multiple occur

B

A one-to-one binary relationship _____. a) involves a single entity type b) involves two entity types c) allows an occurrence of one entity type to be associated with several occurrences of another entity type d) allows an occurrence of one entity type to be associated with several occurrences of another entity type and vice versa e) restricts the number of attributes that an entity has

B

A relationship is an association between ____. a) objects b) entities c) databases d) fields

B

A table can be logically connected to another table by defining a ____. a) hyperlink b) common attribute c) primary key d) logic key

B

A table is perceived as a ____. a) flat structure b) two-dimensional structure c) linked structure d) graph

B

All of the following are SQL commands, except ____. a) CREATE TABLE b) CREATE SELECT c) CREATE INDEX d) CREATE VIEW e) DROP TABLE

B

An attribute is _____. a) a collection of objects of the same type b) a characteristic of an entity c) a record of a file d) a collection of records of the same type e) an event

B

Data is/are: a) information b) raw facts c) processed information d) a DBMS

B

Dependencies based on only a part of a composite primary key are called ____ dependencies. a) primary b) partial c) incomplete d) composite

B

Each building on a university campus has several faculty offices. Each professor has one office. The relationship between campus buildings and professors is a _____ relationship. a) one-to-one binary b) one-to-many binary c) many-to-many binary d) one-to-one unary e) one-to-many unary

B

In a university setting, the relationship between students and the professors who have been their instructors is a _____ relationship. a) one-to-one binary b) one-to-many binary (NOTE: "who have been their instructors") c) many-to-many binary d) one-to-one unary e) one-to-many unary

B

In a university, the relationship between courses and their sections can best be described as a _____ relationship. a) one-to-one binary b) one-to-many binary (Because a section can NOT have many courses) c) many-to-many binary d) one-to-one unary e) one-to-many unary

B

Rebuilding a database after it is destroyed by a natural disaster is an aspect of _____. a) computer security b) backup and recovery c) concurrency control d) integration control e) access control

B

The cardinality of a relationship is _____. a) The minimum number of entities that can be involved in the relationship. b) The maximum number of entities that can be involved in the relationship. c) The minimum number of attributes that can be in the entity types in a relationship. d) The maximum number of attributes that can be in the entity types in a relationship. e) The minimum number of associations that can be involved in the relationship.

B

The term "binary" in binary relationship indicates that the relationship is between ______. a) two halves of an entity type b) two entity types c) two divisions of an entity's attributes d) two attributes e) two relationships

B

To list all the contents of the PRODUCT table, you would use ____. a) LIST * FROM PRODUCT; b) SELECT * FROM PRODUCT; c) DISPLAY * FROM PRODUCT; d) SELECT ALL FROM PRODUCT;

B

What is the command to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the value of V_CODE match? a) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_ AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; b) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; c) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; d) SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;

B

Which item is unstructured data? a) A record representing one student b) A video c) A table that holds student data d) A relational database that hold course registration data.

B

Which kind of binary relationship is described in this example? a) One-to-one b) One-to-many c) Many-to-many d) Associative

B

Which of the following is the unique identifier of an entity? a) field b) key c) record type d) record occurrence e) file

B

Which query will output the table contents when the value of V_CODE is less than or equal to 21344? a) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <> 21344; b) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE <=21344; c) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE => 21344; d) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344;

B

Which type of relationship exists between Student and Course? a) One-to-many binary b) Many-to-many binary c) One-to-many unary d) Many-to-many unary

B

A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. Which of the following is NOT one of those functions? a) Data integrity management b) Data storage management c) Data reports d) Security management

C

A ____ key is a key that consists of more than one attribute. a) primary b) foreign c) composite d) domain

C

A ____ relationship exists when three entities are associated. a) unary b) binary c) ternary d) weak

C

A data definition language (DDL) ____. a) is the same as a data manipulation language b) is limited to defining the size and type of attributes c) specifies what tables will be in the database, what attributes will be in the tables, and which attributes will be indexed d) specifies the programming language statements that will be used to access the data in a relational database e) specifies the operating system parameters that will permit the relational DBMS to function within its environment

C

A record consists of a ____. a) character b) collection of related records c) set of one or more fields d) group of files

C

A relation is not in 1NF if: a) it has multiple candidate keys b) all of the key attributes are defined c) there are repeating groups in the table d) all attributes are dependent on the primary key

C

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

C

A table that is in 2NF and contains no transitive dependencies is said to be in ____. a) 1NF b) 2NF c) 3NF d) 4NF

C

All of the following are problems caused by redundant data, except _____. a) wasted disk space b) additional processing time for data updates c) wasted network transmission time d) potential data integrity problems e) the possibility of having what should be the same data value in two different files having different values.

C

An associative entity is an alternate way of expressing a(n) _____. a) one-to-one binary relationship b) one-to-many binary relationship c) many-to-many binary relationship d) entity that has no attributes other than the unique identifier or key e) entity that has no unique identifiers or keys

C

An entity is _____ in the business environment. a) a fact about an object b) a record in a file c) an object or event d) an attribute e) a file

C

Another word for the term "relation" is ____. a) datafile b) data index c) table d) data query

C

Consider relations X and Y, each representing one of two entities in a many-to-many binary relationship. Relation Z is the additional relation created to store the many-to-many relationship. Intersection data ____. a) is stored in relation X or in relation Y, but not in both b) must be stored in both relations X and Y c) is stored in relation Z d) is stored in all three relations X, Y, and Z e) cannot be stored in any of relations X, Y, or Z

C

DISTINT filters the results to remove duplicates. ORDER BY ____. a) does the same thing. b) alters the order of the rows in a table. c) modifies the presentation by changing the order of the result set. d) removes duplicates in the table.

C

In the SQL SELECT command, the table(s) involved in the query is (are) specified in the ____ clause. a) SELECT b) PROJECT c) FROM d) WHERE e) RETRIEVE

C

Intersection data _____. a) is an attribute of the entity on the "one side" of a one-to-many relationship b) is an attribute of the entity on the "many side" of a one-to-many relationship c) describes the relationship between two entities in a many-to-many relationship d) describes one of the entities in a many-to-many relationship e) describes one of the entities in a ternary relationship

C

Problems caused by two or more users trying to update the same data simultaneously fall primarily under the heading of _____. a) computer security b) backup and recovery c) concurrency control d) integration control e) access control

C

SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____. a) BETWEEN b) IS NULL c) LIKE d) IN

C

The Entity-Relationship (E-R) model is _____. a) a diagramming technique that describes record structures (i.e. the fields that make up the records of a file) b) an alternative to indexing and hashing as a means for providing direct access in files c) a diagramming technique that describes entities, their attributes, and the relationships between them d) an alternative to file design in which attributes are used instead of fields e) a diagramming technique that relates entities to each other, attributes to each other, and relationships to each other

C

The SQL SELECT LIKE operator ____. a) involves looking for numeric values close to a specified numeric value b) involves numeric values in between two specified numeric values c) involves the use of wildcards d) involves limiting duplicate values in the output of an SQL SELECT command e) None of the above.

C

The values of the primary key of a relation ____. a) cannot be unique b) may be unique or non-unique c) must be unique d) must consist of a single attribute e) None of the above.

C

We can describe a link by observing that ____. a) a primary key of one table appears again as a primary key in a related table b) a foreign key of one table appears again as a foreign key in a related table c) a primary key of one table appears again as a foreign key in a related table d) a foreign key of one table appears again as a primary key in a related table

C

What does the 'refer' in referential integrity mean? a) The relationships between entities and attributes, also called referrals b) Reference points that databases place in each record during backups c) A foreign key in a table must refer to a valid primary key in another table. d) you delete a row in one table whose primary key does not have a matching foreign value in another table

C

What is the E-R Diagram about an online pet food vendor showing? a) An Invoice Line can include many Items b) An item can only be included in one Invoice Line c) One Invoice Line must include a minimum of one and a maximum d) The relationship between Item and Invoice Line is many-to-many

C

What is the correct way to read the modality on the right side of the association? a) A maximum of one activity b) A maximum of zero activities c) A minimum of zero activities d) A maximum of many activities

C

Which attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM) a) CRS_CODE b) CLASS_SECTION c) CRS_CODE and CLASS_SECTION d) There is no primary key

C

Which command is used to select partial table contents? a) SELECT <column(s)> FROM <Table name> WHERE <Item>; b) LIST <column(s)> FROM <Table name> WHERE <Conditions>; c) SELECT <column(s)> FROM <Table name> WHERE <Conditions>; d) LIST<column(s)> FROM <Table name> WHERE <Item>;

C

A many-to-many binary relationship allows an occurrence of one entity type to be associated with _____. a) a single occurrence of the same entity type b) multiple occurrences of the same entity type c) a single occurrence of another entity type d) multiple occurrences of another entity type

D

A foreign key must ____. a) be numeric b) be unique c) be defined in all tables within the database d) match the value of a primary key in a related table

D

A one-to-many binary relationship allows an occurrence of the entity type on the "one side" of the relationship to be associated with _____. a) a single occurrence of the same entity type b) multiple occurrences of the same entity type c) a single occurrence of the entity type on the "many side" of the relationship d) multiple occurrences of the entity type on the "many side" of the relationship e) multiple occurrences of the entity type on the "one side" of the relationship

D

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

D

Data redundancy produces ____. a) slower lookups b) robust design c) efficient storage use d) data integrity problems

D

In the SQL SELECT command, the search arguments that limit the rows involved in the query are specified in the ____ clause. a) SELECT b) PROJECT c) FROM d) WHERE e) RETRIEVE

D

Normalization works through a series of normal ____. a) schemas b) entities c) databases d) forms

D

Structured Query Language (SQL) ____. a) is capable of retrieving data from a relational database b) is capable of defining the tables, attributes, and indexes of a relational database c) is a relational DBMS d) a and b above e) a, b, and c above

D

The ERD is used to graphically represent the ____ database model. a) condensed b) physical c) logical d) conceptual

D

The SQL SELECT IN operator ____. a) involves looking for numeric values and can be used instead of a series of AND operators b) involves looking for numeric values and can be used instead of a series of OR operators c) involves looking for character strings and can be used instead of a series of AND operators d) involves looking for character strings and can be used instead of a series of OR operators (On text, search for "IN (") e) None of the above.

D

The SQL SELECT built-in function that adds the values of a specified set of attributes is ____. a) COUNT b) MIN c) MAX d) SUM e) AVG

D

The SQL command that enables you to make changes in the data is ____. a) INSERT b) SELECT c) COMMIT d) UPDATE

D

What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288? a) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE <= 24288 b) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE => 24288 c) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE > 24288 d) SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE FROM PRODUCT WHERE V_CODE = 21344 OR V_CODE = 24288

D

What is the modality of Volunteer? a) Two or more b) Two c) Dependent on registration date d) At least one

D

When data structures can be modified without affecting the programs that use the data, we say that the environment is highly _____. a) secure b) recoverable c) data structured d) data independent e) data dependent

D

Which command would you use when making corrections to the PRODUCT table? a) CHANGE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2'; b) ROLLBACK PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2'; c) EDIT PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2'; d) UPDATE PRODUCT SET P_INDATE = '01/18/2004' WHERE P_CODE = '13-Q2/P2';

D

A data manipulation language (DML) is capable of ____. a) inserting new records or rows into a relation b) deleting records or rows of a relation c) retrieving data from a relation d) a and b above e) a, b, and c above

E

An association between entities is a(n) _____. a) entity type b) entity occurrence c) record d) attribute e) relationship

E

Each student at a university takes many courses; each course is taken by many students. The semester that a student took a course and the grade that the student received in the course is called _____ data. a) index b) key c) pointer d) direct access e) intersection

E

In a university setting, every professor reports to another professor who is the department chair. This is a _____ relationship. a) one-to-one binary b) one-to-many binary c) many-to-many binary d)one-to-one unary e) one-to-many unary

E

The SQL SELECT ORDER BY operator ____. a) groups together rows with identical values of a specified attribute b) groups together columns with identical values of a specified attribute c) changes the order of the rows of one of the tables in a Join operation d) changes the order of the columns of one of the tables in a Join operation e) None of the above. (orders them by one or more specified attributes)

E