1 Identify the correct statement used to assign update permission to a role 'Assistant. O a. GRANT Assistant TO update; O b. GRANT update TO Assistant; O G GRANT update table; O d. GRANT update Assistant; Consider the following transactions, the statement rollback to savepoint M2 discards which operation ? DELETE INSERT Savepoint M1 UPDATE Savepoint M2 Create Table Rollback to Savepoint M2 O a. UPDATE O b. Create Table O CINSERT O d. DELETE

1 Identify the correct statement used to assign update permission to a role 'Assistant. O a. GRANT Assistant TO update; O b. GRANT update TO Assistant; O G GRANT update table; O d. GRANT update Assistant; Consider the following transactions, the statement rollback to savepoint M2 discards which operation ? DELETE INSERT Savepoint M1 UPDATE Savepoint M2 Create Table Rollback to Savepoint M2 O a. UPDATE O b. Create Table O CINSERT O d. DELETE

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

List out various user authorization to modify the database Schema
a. Display the employees where the salary is 2200-Upload Screen shot b. Display the employees where the salary is above 2000- Upload Screen shot c. Display the employees where the salary is greater than 2000 and the age is less than 25- Upload Screen shot d. Display only the Top 3 records from the employee table - Upload Screen shot e. Delete the employee whose ID is 2 - Upload Screen shot f. Display again only the Top 3 records from the employee table - Upload Screen shot
A specific command is required in order to copy data inside tables as well as copy data across tables.
How does the Internet of Things function, and what is it?
q25
Match each of the following actions according to their designated function used to enforce Confidentiality, Integrity, and Availability. ✓ Use a GRANT command to authorize a user to access to a table. A. Integrity ✓ Include a PRIMARY key in a CREATE TABLE command. B. Confidentiality ✓ Perform backup and recovery regularly on databases. C. Availability ✓ Use a CREATE TRIGGER command to prevent any insertion to a table.
Triggers? Why? What are the triggers in Access 2016?
Identify opportunities for using triggers in your database and write the appropriate DDL queries for them
Suppose each of the following update operations is applied directly to the below database state.Discuss which integrity constraints were violated by each operation and how you can enforce theseconstraints to ensure no violation occurs. If an operation does not violate any constraints, brieflyexplain why. d) Update dno of John B Smith to 3 in Employee table.e) Delete the employee Franklin T Wong from the Employee table.f) Delete the third record from works_on tableg) update pnumber of productX to 20 in project table
In MS Access, if you have two related tables and you check the box to enforce referential integrity, how does the software behave during the insertion of a new record into the many table? Options: 1) It prevents a row from being inserted into the many table if the data in the foreign key column does not match any of the values in the primary key column of the one table.2) It prevents any records from being deleted from the primary or secondary table.3) It creates a new primary key attribute that is automatically numbered as a sequence of numeric values.4) It prevents foreign key values from being duplicated in the many table.
Microsoft Access performs an immediate update of the database when data is modified, added, or deleted, but Oracle will not actually physically update the database until a COMMIT command is explicitly or implicitly run. Question 38 options: 1) True 2) False
Create access table relationships as shown in the ERD above.