BCIS 4660 Exam 1 Flashcards Quizlet PDF

Preview

Summary

13212...

Description

7/28/2021

BCIS 4660 Exam 1 Flashcards | Quizlet

BCIS 4660 Exam 1

Streamline studying with Quizlet Plus Study smarter, save time and

Get access to all your stats, your personal progress dashboard and smart study shortcuts with Quizlet Plus. Unlock Progress

create better sets. Got it

Terms in this set (121) c

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

...

c

3. A(n) ____ is a characteristic or property of

a

an entity. a. attribute c. datapoint b. constraint d. record

4. A(n) ____ is the computer counterpart to an

c

ordinary paper file you might keep in a file cabinet or an accounting ledger. a. spreadsheet c. data file b. database d. attribute

5. The ____ of an entity become the columns

d

in the database table. a. E-R diagrams c. data files b. tuples d. attributes

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

1/23

7/28/2021

6. An association between entities is known

BCIS 4660 Exam 1 Flashcards | Quizlet

b

as a(n) ____. a. integrity constraint c. database b. relationship d. data file

7. A visual way to represent a database is

d

with a(n) ____. a. spreadsheet c. DBA b. DBMS d. entity-relationship diagram

8. Popular ____ include Access, Oracle, DB2,

c

MySQL, and SQL Server. a. E-R diagrams c. DBMSs b. DBAs d. data files

9. During the ____ process, a database expert

c

determines the structure of the required database. a. data security c. database design b. database integrity d. database selection

10. ____ are screen objects used to maintain,

a

view, and print data from a database. a. Forms c. Data files b. Fields d. Entities

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

2/23

7/28/2021

11. Which of the following statements is

BCIS 4660 Exam 1 Flashcards | Quizlet

a

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.

12. An integrity constraint is a rule that ____.

d

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

13. A database has ____ if the data in it satisfies

b

all established integrity constraints. a. redundancy c. data independence b. integrity d. database design

14. ____ is the prevention of unauthorized

d

access to the database. a. Data independence c. Redundancy b. Integrity constraint d. Security

15. A(n) ____ frees programmers who write

d

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

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

3/23

7/28/2021

BCIS 4660 Exam 1 Flashcards | Quizlet

16. A person who is in charge of a database

b

within an organization is often called the database ____. a. writer c. designer b. administrator d. controller

17. A good ____ should provide an opportunity

d

for users to incorporate integrity constraints when they design the database. a. database administrator c. E-R diagram b. DBA d. DBMS

18. A DBMS lets you assign users to ____.

a

a. groups c. attributes b. classes d. clusters

19. ____ is a property that lets you change the

a

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

20. One disadvantage of a database system

a

is ____. a. a larger file size c. reduced integrity b. data dependence d. reduced productivity

1. A relation is a(n) ____.

d

a. attribute c. field b. column d. table

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

4/23

7/28/2021

BCIS 4660 Exam 1 Flashcards | Quizlet

2. Based on the statement below, which of

a

the following is the primary key? Part (PartNum, Description, OnHand, Class, Warehouse, Price) a. PartNum c. Class b. Description d. Warehouse

3. When duplicate column names exist in a

d

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

4. Rows are also called ____.

b

a. fields b. tuples c. columns d. attributes

5. The ____ key of a table is the column or

a

collection of columns that uniquely identifies a given row in that table. a. primary c. foreign b. secondary d. minor

6. The compound criteria (conditions) are

b

created by using ____. a. AND or NOR c. OR or NOT b. AND or OR d. NOT or ONLY

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

5/23

7/28/2021

7. Count, Sum, Avg, Max, and Min are a few

BCIS 4660 Exam 1 Flashcards | Quizlet

b

of the built-in statistics or ____ functions that can be used in a query. a. accumulated c. primary b. aggregate d. allowed

8. If you are sorting records by more than

c

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

9. A query that changes data is a(n) ____ query.

c

a. addition c. update b. update d. select

10. A ____ query creates a new table using the

a

query results. a. make-table c. create-table b. new-table d. merge-table

11. The ____ command within relational algebra

d

takes a vertical subset of a table. a. SELECT c. PROGRAM b. DELETE d. PROJECT

13. The ____ command within relational

b

algebra includes the word OVER followed by a list of the columns to be included. a. DELETE c. INTERSECT b. PROJECT d. UNION

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

6/23

7/28/2021

14. Which operation will allow you to extract

BCIS 4660 Exam 1 Flashcards | Quizlet

b

data from more than one table? a. Select c. Project b. Join d. Merge

15. You can restrict the output from a join to

c

include only certain columns by using the ____ command. a. DELETE c. PROJECT b. UNION d. INTERSECT

16. Two tables are considered to be ____

a

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

17. The ____ operator is performed by the

d

SUBTRACT command in relational algebra. a. union c. product b. intersection d. difference

18. The ____ operator is used to concatenate

c

every row in the first table with every row in the second table. a. union c. product b. difference d. intersection

19. The product of two tables is also called

a

the ____ product. a. Cartesian c. Cathode b. aggregate d. exponential

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

7/23

7/28/2021

20. Using the product operator, if table A has

BCIS 4660 Exam 1 Flashcards | Quizlet

c

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

1. When you use a name containing a space

a

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

2. Many versions of SQL require you to end a

d

command with a ____. a. comma (,) c. colon (:) b. period (.) d. semicolon (;)

3. The basic form of an SQL retrieval

d

command is ____. a. SELECT-WHERE-FROM c. SELECT-WHERE b. CREATE-SELECT-FROM d. SELECT-FROM-WHERE

4. When used after the word SELECT, the ____

b

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. #

5. To use a wildcard, include the ____ operator

d

in the WHERE clause. a. AS c. BETWEEN b. UNION d. LIKE

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

8/23

7/28/2021

6. In MySQL, the ____ is used as a wildcard to

BCIS 4660 Exam 1 Flashcards | Quizlet

c

represent any collection of characters. a. asterisk (*) c. percent sign (%) b. underscore (_) d. question mark (?)

7. In Access SQL, the ____ is used as a

d

wildcard to represent any individual character. a. asterisk (*) c. percent sign (%) b. underscore (_) d. question mark (?)

8. The ____ function determines the largest

c

value in a given column. a. LGE c. MAX b. LARGE d. MAXIMUM

9. When a subquery is used, ____ is(are)

a

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

10. The ____ clause can be used to create

d

groups of records. a. SELECT c. SORT BY b. ORDER BY d. GROUP BY

11. When rows are grouped, ____.

d

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

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

9/23

7/28/2021

12. In order to make changes to existing data

BCIS 4660 Exam 1 Flashcards | Quizlet

d

in a table, you would use the ____ command. a. DELETE c. SELECT b. CHANGE d. UPDATE

13. To add new data to a table, use the ____

c

command. a. ADDTO c. INSERT b. DELETE d. SELECT

14. You can save the results of a query as a

a

table by including the ____ clause in the query. a. INTO c. UPDATE b. INSERT d. DELETE

1. The ____ command will create an application

d

program's or individual user's picture of the database. a. CREATE SNAPSHOT c. SELECT VIEW b. SELECT SNAPSHOT d. CREATE VIEW

2. To create an index for the Customer table

d

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);

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

10/23

7/28/2021

3. The ____ statement will take away user

BCIS 4660 Exam 1 Flashcards | Quizlet

d

privileges to the database. a. SELECT c. DEL b. INDEX d. REVOKE

4. To create the primary key clause for the

a

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)

5. To create the primary key clause for the

c

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)

6. Essentially, setting the value in a given

d

field to ____ is similar to not entering a value in it at all. a. 0 c. blank b. nil d. null

7. Which of the following statement

d

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))

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

11/23

7/28/2021

8. The CHECK clause can be included in the

BCIS 4660 Exam 1 Flashcards | Quizlet

b

____ command. a. SELECT TABLE c. CHANGE TABLE b. CREATE TABLE d. MODIFY TABLE

9. In SQL, you use the CHECK clause to

b

enforce ____ integrity. a. referential c. entity b. legal-values d. catalog

10. To insert a new field in a table, the ____

a

keyword should be used with the ALTER TABLE command. a. ADD c. INCLUDE b. INSERT d. ALTER

11. The SQL command for deleting the

a

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;

12. The statement, ____, removes the table

b

LargeCust from a DBMS. a. DELETE TABLE LargeCust; c. REMOVE TABLE LargeCust; b. DROP TABLE LargeCust; d. RID TABLE LargeCust;

13. In MySQL, you use the _____ command to

c

produce a list of tables. a. SYSTABLES c. SHOW TABLES b. SYSTEM TABLES d. CATALOG TABLES

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

12/23

7/28/2021

14. If you anticipate running a particular

BCIS 4660 Exam 1 Flashcards | Quizlet

b

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

15. A(n) ____ is a computer that is connected to

a

a network and has access through the server to the database. a. client c. index b. view d. trigger

16. A(n) ____ is an action that occurs

b

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

17. A trigger is stored and compiled on the

d

____. a. client c. index b. Web d. server

18. To use a stored procedure in MySQL, a

d

user enters the word _____ followed by the procedure name. a. USE c. RUN b. DO d. CALL

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

13/23

7/28/2021

19. To create a trigger in MySQL, use the _____

BCIS 4660 Exam 1 Flashcards | Quizlet

b

command. a. ADD TRIGGER c. INSERT TRIGGER b. CREATE TRIGGER d. UPDATE TRIGGER

20. In Access, many macro actions require

d

additional information, called _____ to complete the action. a. conditions c. submacros b. constructs d. arguments

1. Potential problems in the design of a

b

relational database are known as ____. a. select anomalies c. modification anomalies b. update anomalies d. relational anomalies

3. If B (an attribute) is functionally dependent

a

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

4. The ____ is a column (or collection of

c

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

5. The definition for ____ also defines a

c

candidate key. a. functional key c. primary key b. natural key d. surrogate key

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

14/23

7/28/2021

6. A(n) ____ is a column or collection of

BCIS 4660 Exam 1 Flashcards | Quizlet

b

columns on which all columns in the table are functionally dependent. a. index key c. major key b. candidate key d. special key

7. An alternate key is a ____.

c

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

8. A table is in first normal form if it does not

b

contain ____. a. dependencies c. a primary key b. repeating groups d. anomalies

9. A table that contains a repeating group is

b

called a(n) ____. a. dependent relation c. nominal relation b. unnormalized relation d. non-nominal relation

10. If there is more than one possible choice

b

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

11. From all the ____ keys, one is chosen to be

b

the primary key. a. alternate c. natural b. candidate d. normal

BCIS 4660 Exam 1 https://quizlet.com/441193018/bcis-4660-exam-1-flash-cards/

15/23

7/28/2021

12. ____ contains a repeating group.

BCIS 4660 Exam 1 Flashcards | Quizlet

a

a. Orders (OrderNum, OrderDate, (PartNum, NumOrdered) ) b. Orders (OrderNum, OrderDate, PartNum, NumOrdered ) c. Orders (OrderNum, OrderDate) d. Orders (OrderNum, PartNum, NumOrdered )

13. A column is a nonkey column if it is ____.

d

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

14. Another name for a nonkey column is a

a

____. a. nonkey attribute c. nonkey row b., key attribute d. key table

15. Second normal form can be defined as a

a

table that is in first normal form but that contains no ____....