Q1.) An integrity constraint is a rule that: a. is kept in an external file b. must be followed by data in the database c. can be accessed by authorized users d. can unintentionally be accessed by unauthorized users Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database. a. Database design b. Data independence c. Integrity constraint d. Data dependence Q3. The basic form of an SQL retrieval command is: a. SELECT-WHERE-FROM b. CREATE-SELECT-FROM c. SELECT-WHERE d. SELECT-FROM-WHERE Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances. a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; c. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance d. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ; Q5. The response of the DBMS to a query is the. a. ad hoc query b. ad hoc response c. query result set d. integrated view of the data Q6. Which of the following queries will list the descriptions of all parts that are located in warehouse 3 or for which there are more than 20 units on hand, or both. a. SELECT Description FROM Customer WHERE Warehouse=’AND OnHand>20 ; b. SELECT Description FROM Part WHERE Warehouse=’3’ OR OnHand>20 ; c. SELECT Description FROM Part WHERE Warehouse=’3’ ; d. SELECT Description FROM Part WHERE OnHand>20 ; Q7. Students and classes have a……. relationship. a. one-to-one b. one-to-many c. many-to-one d. many-to-many Q8. Referential……..dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. a. integrity b. uniqueness c. model d. attribute Q9. The …….. relationship is the “relational model ideal.” a. 1:1 b. 1:M c. M:1 d. M:N Q10. Information about tables in the database is kept: a. in the system catalog b. in each table in the database c. in each row of each table in the database d. in an external file

Q1.) An integrity constraint is a rule that: a. is kept in an external file b. must be followed by data in the database c. can be accessed by authorized users d. can unintentionally be accessed by unauthorized users Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database. a. Database design b. Data independence c. Integrity constraint d. Data dependence Q3. The basic form of an SQL retrieval command is: a. SELECT-WHERE-FROM b. CREATE-SELECT-FROM c. SELECT-WHERE d. SELECT-FROM-WHERE Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances. a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ; b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ; c. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance d. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ; Q5. The response of the DBMS to a query is the. a. ad hoc query b. ad hoc response c. query result set d. integrated view of the data Q6. Which of the following queries will list the descriptions of all parts that are located in warehouse 3 or for which there are more than 20 units on hand, or both. a. SELECT Description FROM Customer WHERE Warehouse=’AND OnHand>20 ; b. SELECT Description FROM Part WHERE Warehouse=’3’ OR OnHand>20 ; c. SELECT Description FROM Part WHERE Warehouse=’3’ ; d. SELECT Description FROM Part WHERE OnHand>20 ; Q7. Students and classes have a……. relationship. a. one-to-one b. one-to-many c. many-to-one d. many-to-many Q8. Referential……..dictates that the foreign key must contain values that match the primary key in the related table, or must contain null. a. integrity b. uniqueness c. model d. attribute Q9. The …….. relationship is the “relational model ideal.” a. 1:1 b. 1:M c. M:1 d. M:N Q10. Information about tables in the database is kept: a. in the system catalog b. in each table in the database c. in each row of each table in the database d. in an external file

Database Systems: Design, Implementation, & Management

11th Edition

ISBN:9781285196145

Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 7RQ: A database user manually notes that The file contains two hundred records, each record containing...

See similar textbooks

Related questions

Concept explainers

Question

Q1.) An integrity constraint is a rule that:

a. is kept in an external file

b. must be followed by data in the database

c. can be accessed by authorized users

d. can unintentionally be accessed by unauthorized users

Q2. __ is a property that lets you change the structure of the database without requiring you to change the programs that access the database.

a. Database design

b. Data independence

c. Integrity constraint

d. Data dependence

Q3. The basic form of an SQL retrieval command is:

a. SELECT-WHERE-FROM

b. CREATE-SELECT-FROM

c. SELECT-WHERE

d. SELECT-FROM-WHERE

Q4. Which of the following queries will list the number, name, credit limit, and balance for all customers with credit limits that exceed their balances.

a. SELECT CustomerNum, CustomerName FROM Customer WHERE CreditLimit>Balance ;

b. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer WHERE CreditLimit>Balance ;

c. SELECT CustomerNum, CustomerName, Balance FROM Customer WHERE CreditLimit>Balance

d. SELECT CustomerNum, CustomerName, CreditLimit, Balance FROM Customer ;

Q5. The response of the DBMS to a query is the.

a. ad hoc query

b. ad hoc response

c. query result set

d. integrated view of the data

Q6. Which of the following queries will list the descriptions of all parts that are located in warehouse 3 or for which there are more than 20 units on hand, or both.

a. SELECT Description FROM Customer WHERE Warehouse=’AND OnHand>20 ;

b. SELECT Description FROM Part WHERE Warehouse=’3’ OR OnHand>20 ;

c. SELECT Description FROM Part WHERE Warehouse=’3’ ;

d. SELECT Description FROM Part WHERE OnHand>20 ;

Q7. Students and classes have a……. relationship.

a. one-to-one

b. one-to-many

c. many-to-one

d. many-to-many

Q8. Referential……..dictates that the foreign key must contain values that match the primary key in the related table, or must contain null.

a. integrity

b. uniqueness

c. model

d. attribute

Q9. The …….. relationship is the “relational model ideal.”

a. 1:1

b. 1:M

c. M:1

d. M:N

Q10. Information about tables in the database is kept:

a. in the system catalog

b. in each table in the database

c. in each row of each table in the database

d. in an external file

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.