Deck 4: The Relational : Advanced Topics

Question 1

A stored procedure is placed on a client computer.​

Answer 1

False

Question 2

Indexes can increase the efficiency with which data is retrieved from the database.​

Answer 2

True

Question 3

Access supports stored procedures.​

Answer 3

False

Question 4

A view is a physical table in the DBMS.

Question 5

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

Question 6

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 7

The command DEL INDEX CustList; would remove the index named CustList.​

Question 8

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

Question 9

One advantage of using views is that they provide data dependence.​

Question 10

A row-and-column subset ____ consists of a subset of the rows and columns in some individual table.​

A) view​
B) ​trigger
C) ​index
D) ​catalog

Question 11

Referential integrity is specified using the FOREIGN KEY clause in the SELECT command.​

Question 12

In Access,a key symbol appears in the row selector of the field that is the ____ key.​

A) ​index
B) ​catalog
C) ​Foreign
D) ​Primary

Question 13

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

Question 14

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

Question 15

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

A) ​CREATE INDEX
B) ​SELECT INDEX
C) ​SELECT VIEW
D) ​CREATE VIEW

Question 16

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

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

Question 17

To create an index 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) ;

Question 18

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

Question 19

Views cannot be used to examine table data.​

Question 20

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

Question 21

The field or combination of fields on which an index is built is called the ____________________ key.​

Question 22

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

A) ​N/A
B) ​nil
C) ​null
D) ​0

Question 23

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 24

A trigger is stored and compiled on the ____.​

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

Question 25

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

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

Question 26

​To create the primary key clause for the OrderLine table on the OrderNum and ItemNum fields,the correct statement is ____.

A) ​PRIMARY KEY (OrderLine, OrderNum, ItemNum)
B) ​KEY (OrderNum, ItemNum)
C) ​PRIMARY KEY (OrderNum, ItemNum)
D) ​PRIMARY (OrderNum, ItemNum)

Question 27

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 28

____________________ is the prevention of unauthorized access to the database.​

Question 29

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 30

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 31

A(n)____________________ index is an index with more than one key field.​

Question 32

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

Question 33

In a client/server system,users access the database through ____.​

A) ​triggers
B) ​documenters
C) ​servers
D) ​clients

Question 34

​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 35

The statement,____,removes the table Smaller from a DBMS.​

A) ​DELETE TABLE Smaller ;
B) ​DROP TABLE Smaller ;
C) ​REMOVE TABLE Smaller ;
D) ​RID TABLE Smaller ;

Question 36

​In a client/server system,the database resides on a computer called the ____.

A) ​index
B) ​documenter
C) ​server
D) ​client

Question 37

Which of the following statement fragments will only allow a CreditLimit of $5,000,$7,500,or $15,000?​

A) ​(CreditLimit IN (5000, 7500, 15000))
B) ​CHECK ((5000, 7500, 15000))
C) ​CHECK (CreditLimit LIKE (5000, 7500, 15000))
D) ​CHECK (CreditLimit IN (5000, 7500, 15000))

Question 38

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

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

Question 39

The SQL command for deleting the Storehouse field from the Item table is ____.​

A) ​ALTER TABLE Item DELETE Storehouse ;
B) ​ALTER TABLE Item DROP COLUMN Storehouse ;
C) ​ALTER Item DELETE Storehouse ;
D) ​ALTER TABLE DELETE Storehouse ;

Question 40

The CHECK clause can be included in the ____ command.​

A) SELECT TABLE​
B) ​ALTER TABLE
C) ​DROP TABLE
D) ​DELETE TABLE

Question 41

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 42

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 43

The type of field for which you should never allow nulls is the ____________________.​

Question 44

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

Question 45

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

Question 46

In Access,you can restrict the legal values accepted by a field by entering an appropriate ____________________ that data entered in the field must follow.​

Question 47

​Discuss what are validation rules and validation text.

Question 48

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

Question 49

​What is the difference between entity integrity and referential integrity?

Question 50

In Access,a(n)____________________ enables you to add logic to table events such as adding,changing,or deleting data​