BCIS 4660 Exam 1

7. An alternate key is a ____. a. surrogate key b. natural key c. column that could be a primary key but was not chosen d. row that could be a primary key but was not chosen

c

17. The ____ operator is performed by the SUBTRACT command in relational algebra. a. union c. product b. intersection d. difference

d

20. The conversion of an unnormalized table to first normal form requires the removal of ____. a. determinants c. nonkey columns b. interrelation constraints d. repeating groups

d

1. A set of requirements that is necessary to support the operations of a particular database user is known as a(n) ____. a. user view c. user window b. user snapshot d. user system

a

1. When you use a name containing a space in Access SQL, you must ____. a. enclose it in square brackets c. precede it by an asterisk b. enclose it in quotation marks d. precede it by a question mark

a

10. A ____ query creates a new table using the query results. a. make-table c. create-table b. new-table d. merge-table

a

10. To insert a new field in a table, the ____ keyword should be used with the ALTER TABLE command. a. ADD c. INCLUDE b. INSERT d. ALTER

a

10. ____ are screen objects used to maintain, view, and print data from a database. a. Forms c. Data files b. Fields d. Entities

a

11. The SQL command for deleting the Warehouse field from the Part table is ____. a. ALTER TABLE Part DROP COLUMN Warehouse ; b. ALTER Part DROP Warehouse; c. ALTER Part DELETE Warehouse; d. ALTER TABLE DELETE Warehouse;

a

11. Which of the following statements is correct? a. In a nondatabase, file-oriented environment, data is often partitioned into several disjointed systems with each system having its own collection of files. b. User data cannot be combined and shared among authorized users. c. Database users should not have access to the same information. d. The elimination of redundancy is always possible.

a

12. ____ contains a repeating group. a. Orders (OrderNum, OrderDate, (PartNum, NumOrdered) ) b. Orders (OrderNum, OrderDate, PartNum, NumOrdered ) c. Orders (OrderNum, OrderDate) d. Orders (OrderNum, PartNum, NumOrdered )

a

14. Another name for a nonkey column is a ____. a. nonkey attribute c. nonkey row b., key attribute d. key table

a

14. You can save the results of a query as a table by including the ____ clause in the query. a. INTO c. UPDATE b. INSERT d. DELETE

a

15. A(n) ____ is a computer that is connected to a network and has access through the server to the database. a. client c. index b. view d. trigger

a

15. Second normal form can be defined as a table that is in first normal form but that contains no ____. a. partial dependencies c. nonkey columns b. alternate keys d. interrelation constraints

a

16. Two tables are considered to be ____ compatible if they have the same number of columns and their corresponding columns represent the same type of data. a. union c. difference b. intersection d. product

a

18. A DBMS lets you assign users to ____. a. groups c. attributes b. classes d. clusters

a

19. The product of two tables is also called the ____ product. a. Cartesian c. Cathode b. aggregate d. exponential

a

2. Based on the statement below, which of the following is the primary key? Part (PartNum, Description, OnHand, Class, Warehouse, Price) a. PartNum c. Class b. Description d. Warehouse

a

20. One disadvantage of a database system is ____. a. a larger file size c. reduced integrity b. data dependence d. reduced productivity

a

3. If B (an attribute) is functionally dependent on A, we can also say that ____. a. A functionally determines B b. A functionally determines another attribute in the table c. B functionally determines A d. B does not determine any other attribute

a

3. If each employee works in a single department and each department has only one employee, the relationship between employees and departments is ____. a. one-to-one c. many-to-one b. one-to-many d. many-to-many

a

4. To create the primary key clause for the Customer table on the CustomerNum field, the correct statement is ____. a. PRIMARY KEY (CustomerNum) b. PRIMARY KEY (Customer, CustomerNum) c. KEY (CustomerNum) d. PRIMARY (CustomerNum)

a

5. The ____ key of a table is the column or collection of columns that uniquely identifies a given row in that table. a. primary c. foreign b. secondary d. minor

a

8. When a DBMS creates a(n) ____ key, it is usually an automatic numbering data type, such as the Access AutoNumber data type. a. surrogate c. natural b. artificial d. logical

a

9. When a subquery is used, ____ is(are) evaluated first. a. the subquery query b. the outer query c. both a and b simultaneously d. whichever query is selected to execute first by the user

a

1. Potential problems in the design of a relational database are known as ____. a. select anomalies c. modification anomalies b. update anomalies d. relational anomalies

b

10. If there is more than one possible choice for the primary key, and one of the possibilities is chosen to be the primary key, the other choices are referred to as ____. a. surrogate keys c. intelligent keys b. alternate keys d. contributory keys

b

11. From all the ____ keys, one is chosen to be the primary key. a. alternate c. natural b. candidate d. normal

b

12. The statement, ____, removes the table LargeCust from a DBMS. a. DELETE TABLE LargeCust; c. REMOVE TABLE LargeCust; b. DROP TABLE LargeCust; d. RID TABLE LargeCust;

b

13. A database has ____ if the data in it satisfies all established integrity constraints. a. redundancy c. data independence b. integrity d. database design

b

13. The ____ command within relational algebra includes the word OVER followed by a list of the columns to be included. a. DELETE c. INTERSECT b. PROJECT d. UNION

b

14. If you anticipate running a particular query often, you can improve overall performance by saving the query in a special file called a(n) ____. a. index c. trigger b. stored procedure d. view

b

16. A person who is in charge of a database within an organization is often called the database ____. a. writer c. designer b. administrator d. controller

b

16. A(n) ____ is an action that occurs automatically in response to an associated database operation such as an INSERT, UPDATE, or DELETE command. a. stored procedure c. view b. trigger d. index

b

19. To convert a table to fourth normal form, split the third normal form table into separate tables, each containing the column that ____ the others. a. determines c. defines b. multidetermines d. identifies

b

19. To create a trigger in MySQL, use the _____ command. a. ADD TRIGGER c. INSERT TRIGGER b. CREATE TRIGGER d. UPDATE TRIGGER

b

2. The properties of the entities you choose as you design the user view will become the ____ in the appropriate tables. a. rows c. records b. columns d. tuples

b

4. Rows are also called ____. a. fields b. tuples c. columns d. attributes

b

4. When used after the word SELECT, the ____ symbol indicates that you want to include all fields in the query results in the order in which you described them to the DBMS when you created the table. a. & c. $ b. * d. #

b

6. A(n) ____ is a column or collection of columns on which all columns in the table are functionally dependent. a. index key c. major key b. candidate key d. special key

b

6. A(n) ____ is a system-generated primary key that is usually hidden from users. a. logical key c. natural key b. surrogate key d. artificial key

b

6. The compound criteria (conditions) are created by using ____. a. AND or NOR c. OR or NOT b. AND or OR d. NOT or ONLY

b

7. A natural key is also called a(n) ____ key. a. surrogate c. secondary b. intelligent d. synthetic

b

7. Count, Sum, Avg, Max, and Min are a few of the built-in statistics or ____ functions that can be used in a query. a. accumulated c. primary b. aggregate d. allowed

b

8. A table is in first normal form if it does not contain ____. a. dependencies c. a primary key b. repeating groups d. anomalies

b

8. The CHECK clause can be included in the ____ command. a. SELECT TABLE c. CHANGE TABLE b. CREATE TABLE d. MODIFY TABLE

b

9. A table that contains a repeating group is called a(n) ____. a. dependent relation c. nominal relation b. unnormalized relation d. non-nominal relation

b

9. In SQL, you use the CHECK clause to enforce ____ integrity. a. referential c. entity b. legal-values d. catalog

b

1. Storing the same data in more than one place is called ____. a. data independence c. redundancy b. data integrity d. security

c

13. In MySQL, you use the _____ command to produce a list of tables. a. SYSTABLES c. SHOW TABLES b. SYSTEM TABLES d. CATALOG TABLES

c

13. To add new data to a table, use the ____ command. a. ADDTO c. INSERT b. DELETE d. SELECT

c

15. You can restrict the output from a join to include only certain columns by using the ____ command. a. DELETE c. PROJECT b. UNION d. INTERSECT

c

16. Partial dependencies are dependencies on only a portion of the ____. a. intelligent key c. primary key b. first column or attribute d. index key

c

17. ____ normal form has an additional condition that the only determinants the table contains are candidate keys. a. First c. Third b. Second d. Fourth

c

18. A table is in fourth normal form when it is in third normal form and there are no ____. a. alternate dependencies c. multivalued dependencies b. partial dependencies d. primary dependencies

c

18. The ____ operator is used to concatenate every row in the first table with every row in the second table. a. union c. product b. difference d. intersection

c

20. Using the product operator, if table A has 4 rows and table B has 4 rows, the number of rows in the product of these two tables is ____. a. 4 c. 16 b. 8 d. 256

c

4. A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet or an accounting ledger. a. spreadsheet c. data file b. database d. attribute

c

4. The ____ is a column (or collection of columns) A such that all other columns are functionally dependent on A and no subcollection of the columns in A has this property. a. functional key c. primary key b. composite key d. declared key

c

5. A column that you create for an entity to serve solely as the primary key and that is visible to users is called a(n) ____. a. synthetic key c. artificial key b. surrogate key d. natural key

c

5. The definition for ____ also defines a candidate key. a. functional key c. primary key b. natural key d. surrogate key

c

5. To create the primary key clause for the Orders table on the OrderNum and PartNum fields, the correct statement is ____. a. PRIMARY KEY (Orders, OrderNum, PartNum) b. KEY (OrderNum, PartNum) c. PRIMARY KEY (OrderNum, PartNum) d. PRIMARY (OrderNum, PartNum)

c

6. In MySQL, the ____ is used as a wildcard to represent any collection of characters. a. asterisk (*) c. percent sign (%) b. underscore (_) d. question mark (?)

c

8. If you are sorting records by more than one field, the more important field is called the ____. a. maximum sort key c. primary sort key b. secondary sort key d. minor sort key

c

8. Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server. a. E-R diagrams c. DBMSs b. DBAs d. data files

c

8. The ____ function determines the largest value in a given column. a. LGE c. MAX b. LARGE d. MAXIMUM

c

9. A query that changes data is a(n) ____ query. a. addition c. update b. update d. select

c

9. During the ____ process, a database expert determines the structure of the required database. a. data security c. database design b. database integrity d. database selection

c

1. A relation is a(n) ____. a. attribute c. field b. column d. table

d

1. The ____ command will create an application program's or individual user's picture of the database. a. CREATE SNAPSHOT c. SELECT VIEW b. SELECT SNAPSHOT d. CREATE VIEW

d

10. The ____ clause can be used to create groups of records. a. SELECT c. SORT BY b. ORDER BY d. GROUP BY

d

11. The ____ command within relational algebra takes a vertical subset of a table. a. SELECT c. PROGRAM b. DELETE d. PROJECT

d

11. When rows are grouped, ____. a. the totals appear with the rows b. the rows appear in order c. no output is produced d. one line of output is produced for each group

d

12. An integrity constraint is a rule that ____. a. is kept in an external file b. can unintentionally be accessed by unauthorized users c. can be accessed only by authorized users d. data must follow in the database

d

12. In order to make changes to existing data in a table, you would use the ____ command. a. DELETE c. SELECT b. CHANGE d. UPDATE

d

13. A column is a nonkey column if it is ____. a. in first normal form c. a part of the primary key b. in second normal form d. not a part of the primary key

d

14. ____ is the prevention of unauthorized access to the database. a. Data independence c. Redundancy b. Integrity constraint d. Security

d

15. A(n) ____ frees programmers who write database access programs from having to engage in mundane data manipulation activities, such as adding new data and deleting existing data. a. DBA c. entity b. E-R diagram d. DBMS

d

17. A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database. a. database administrator c. E-R diagram b. DBA d. DBMS

d

17. A trigger is stored and compiled on the ____. a. client c. index b. Web d. server

d

18. To use a stored procedure in MySQL, a user enters the word _____ followed by the procedure name. a. USE c. RUN b. DO d. CALL

d

2. Many versions of SQL require you to end a command with a ____. a. comma (,) c. colon (:) b. period (.) d. semicolon (;)

d

2. To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order, the command is ____. a. CREATE INDEX RepBal ON Customer (RepNum, Balance); b. CREATE INDEX RepBal Customer (RepNum DESC); c. CREATE INDEX ON Customer (RepNum, Balance ASC); d. CREATE INDEX RepBal ON Customer (RepNum, Balance DESC);

d

20. In Access, many macro actions require additional information, called _____ to complete the action. a. conditions c. submacros b. constructs d. arguments

d

3. The ____ statement will take away user privileges to the database. a. SELECT c. DEL b. INDEX d. REVOKE

d

3. The basic form of an SQL retrieval command is ____. a. SELECT-WHERE-FROM c. SELECT-WHERE b. CREATE-SELECT-FROM d. SELECT-FROM-WHERE

d

3. When duplicate column names exist in a database and you need to indicate the column to which you are referring, ____. a. do not use these two tables together b. do not use the column names in the same statement c. write the table name only d. write both the table name and the column name, separated by a period

d

4. A(n) ____ is a primary key that consists of a column that uniquely identifies an entity, such as a person's Social Security number. a. surrogate key c. artificial key b. synthetic key d. natural key

d

5. The ____ of an entity become the columns in the database table. a. E-R diagrams c. data files b. tuples d. attributes

d

5. To use a wildcard, include the ____ operator in the WHERE clause. a. AS c. BETWEEN b. UNION d. LIKE

d

6. Essentially, setting the value in a given field to ____ is similar to not entering a value in it at all. a. 0 c. blank b. nil d. null

d

7. A visual way to represent a database is with a(n) ____. a. spreadsheet c. DBA b. DBMS d. entity-relationship diagram

d

7. In Access SQL, the ____ is used as a wildcard to represent any individual character. a. asterisk (*) c. percent sign (%) b. underscore (_) d. question mark (?)

d

7. Which of the following statement fragments will only allow a CreditLimit of $7,500, $10,000, or $15,000? a. (CreditLimit IN (7500, 10000, 15000)) b. CHECK ((7500, 10000, 15000)) c. CHECK (CreditLimit LIKE (7500, 10000, 15000)) d. CHECK (CreditLimit IN (7500, 10000, 15000))

d

19. ____ is a property that lets you change the structure of the database without requiring you to change the programs that access the database. a. Data independence c. Database design b. Integrity constraint d. Data dependence

a

3. A(n) ____ is a characteristic or property of an entity. a. attribute c. datapoint b. constraint d. record

a

14. Which operation will allow you to extract data from more than one table? a. Select c. Project b. Join d. Merge

b

6. An association between entities is known as a(n) ____. a. integrity constraint c. database b. relationship d. data file

b