Deck 4: The Relational Model 3: Advanced Topics

Question 1

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

Answer 1

D

Question 2

The ____ command will create an application program's or individual user's picture of the database.

A)CREATE SNAPSHOT
B)SELECT SNAPSHOT
C)SELECT VIEW
D)CREATE VIEW

Answer 2

D

Question 3

The command DELETE INDEX CustList; would remove the index named CustList.

Answer 3

False

Question 4

Access 2010 supports data macros.

Question 5

Legal-values integrity is the property that states that no record can exist in the database with a value in the field other than one of the legal values.

Question 6

Once you add an index to a database,you cannot delete it.

Question 7

The SELECT command that creates the view,which is called the view query,indicates what to include in the view.

Question 8

To change the field names in a view include the AS clause in the CREATE VIEW command.

Question 9

Views cannot be used to examine table data.

Question 10

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)

Question 11

To create a view in Access,you simply create and then save a query.

Question 12

An individual can use a view to create reports,charts,and other objects that show database data.

Question 13

When you create an index whose key has a single field,you have created what is called a primary index.

Question 14

One advantage of a view is that different users can view the same data in different ways.

Question 15

The following command will revoke the ability to retrieve Customer records from user Jones:
REVOKE GRANT ON Customer FROM Jones ;

Question 16

Information about tables in the database is kept in the system catalog.

Question 17

The ____ statement will take away user privileges to the database.

A)SELECT
B)INDEX
C)DEL
D)REVOKE

Question 18

A stored procedure is placed on a client computer.

Question 19

The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer TO Jones ;

Question 20

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)

Question 21

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
B)stored procedure
C)trigger
D)view

Question 22

To use a stored procedure in MySQL,a user enters the word _____ followed by the procedure name.

A)USE
B)DO
C)RUN
D)CALL

Question 23

A(n) ____ is a computer that is connected to a network and has access through the server to the database.

A)client
B)view
C)index
D)trigger

Question 24

To insert a new field in a table,the ____ keyword should be used with the ALTER TABLE command.

A)ADD
B)INSERT
C)INCLUDE
D)ALTER

Question 25

In Access,many macro actions require additional information,called _____ to complete the action.

A)conditions
B)constructs
C)submacros
D)arguments

Question 26

Within relational model systems on both mainframes and personal computers,the main mechanism for increasing the efficiency with which data is retrieved from the database is the ____________________.

Question 27

____________________ is the rule that no field that is part of the primary key may accept null values.

Question 28

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

A)ADD TRIGGER
B)CREATE TRIGGER
C)INSERT TRIGGER
D)UPDATE TRIGGER

Question 29

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

Question 30

In SQL,you use the CHECK clause to enforce ____ integrity.

A)referential
B)legal-values
C)entity
D)catalog

Question 31

The CHECK clause can be included in the ____ command.

A)SELECT TABLE
B)CREATE TABLE
C)CHANGE TABLE
D)MODIFY TABLE

Question 32

In MySQL,you use the _____ command to produce a list of tables.

A)SYSTABLES
B)SYSTEM TABLES
C)SHOW TABLES
D)CATALOG TABLES

Question 33

The statement,____,removes the table LargeCust from a DBMS.

A)DELETE TABLE LargeCust ;
B)DROP TABLE LargeCust ;
C)REMOVE TABLE LargeCust ;
D)RID TABLE LargeCust ;

Question 34

____________________ is the prevention of unauthorized access to the database.

Question 35

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 ;

Question 36

Within an organization,the ____________________ determines the types of access various users can have to the database.

Question 37

Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.

A)0
B)nil
C)blank
D)null

Question 38

A trigger is stored and compiled on the ____.

A)client
B)Web
C)index
D)server

Question 39

The SQL command used to delete an index that is no longer necessary is ____________________.

Question 40

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
B)trigger
C)view
D)index

Question 41

Under which conditions should you create an index on a field (or combination of fields)?

Question 42

What are the advantages of having views only contain the fields required by a given user?

Question 43

Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.

Question 44

The semicolon at the end of a MySQL command is called a(n) ____________________.

Question 45

Explain what is meant by a null value. Is a null value the same as a value of zero?

Question 46

In SQL,you specify referential integrity using a(n) ____________________ clause in either the CREATE TABLE or ALTER TABLE commands.

Question 47

In Access 2010,you can gain the same functionality as triggers by creating a(n) ____________________.

Question 48

In a system catalog,the ____________________ table contains information about the tables known to SQL.

Question 49

Discuss what you can do if you need to change a table's structure in ways that are beyond the capabilities of your DBMS.

Question 50

What is the difference between entity integrity and referential integrity?