please solve the follwing MCQ question

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

2. __ 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 c. Integrity constraint

b. Data independence d. Data dependence

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

a. SELECT-WHERE-FROM c. SELECT-WHERE

b. CREATE-SELECT-FROM d. d. SELECT-FROM-WHERE

4. 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 ;

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

6. 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 ;