Which of the following is an object privilege?a. DELETE ANYb. INSERT ANYc. UPDATE ANYd. REFERENCES

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…

Chapter 17 How to manage database security Exercises using the My Guitar Shop Database Use Microsoft SQL Server Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give SELECT permission for all user tables. 2.Write a script that (1) creates a login ID named “RobertHalliday” with the password “HelloBob”; (2) sets the default database for the login to the MyGuitarShop database; (3) creates a user named “RobertHalliday” for the login; and (4) assigns the user to the OrderEntry role you created in exercise 1.

1. The log is a sequence of ___________, recording all the update activities in the database. a. Log records b. Records c. Entries d. Redo

Create another application/class named EmployeeDatabase that allows you to store anarray that acts as a database of any number of Employee objects up to 25. While the userdecides to continue, offer three options: to add a record to the database, to delete a recordfrom the database, or to change a record in the database. Then proceed as follows:If the user selects the add option, issue an error message if the database is full.Otherwise, prompt the user for an Id. If the Id already exists in the database, issuean error message. Otherwise, prompt the user for rest of the inputs and add the newrecord to the database.If the user selects the delete option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the Id does not exist, issue an error message.Otherwise, delete the record.If the user selects the change option, issue an error message if the database is empty.Otherwise, prompt the user for an Id. If the requested record does not exist, issuean…

Create an access database named student1.

1. If a user has only read authorization for the database, can he modify the data in the database? 2. If a user has only read authorization for the database, can he retrieve data from the database?

@3

16. Which commands are used to control which users have which privilege over which objects ? a. QUE and QUIST b. GRANT and REVOKE c. CASECADE and MVD d. None of the above

Which type of database stores information in tables composed of rows and columns? a. columnar b. relational c. sorted d. tabular