What is the process called to deny access to other users while the DBMS processes one user's updates? Lockout Excluding Locking None of the above.
Added by Linda W.
Close
Step 1
This is a common database concurrency control mechanism. Show more…
Show all steps
Your feedback will help us improve your experience
Anand Jangid and 91 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Techwire Lanka is a software company who has expertise in developing secure software applications the hotel industry. As such, a reputed global hotel chain has given the responsibility of automating their tasks to Techwire Lanka. Nalaka is the project manager responsible for the entire project. Nalaka has asked Malani who is the senior DBA to handle the database development and management process. This includes creating a secure database to the hotel. Malani is responsible for handling all the hotel reservations and bookings. Accordingly, she has designed the hoteldb. Since there will be lot of users for the project. Sonal is assigned with the responsibility of handling logins to the system. Akram is assigned to create tables, required views, stored procedures and triggers. Palika and Mahesh who are data entry operators are given the responsibility of inserting the data to the tables. With the data added to the database. Aruni should be able to generate reports as well as directly query the data or call functions and procedures.Assuming that Aruni left the company and thus she should be prevented from inserting data to the system. Which of the following command/s can facilitate the above assuming that Aruni has a login name aruni.g Select one or more:a. REVOKE select to aruni.gb. REVOKE grant to aruni.gc. ALTER permission to aruni.gd. DENY permission to aruni.ge. DENY insert to aruni.g
Anand J.
What is the difference between a transaction having exclusive access or shared access to an item in a database and why is the distinction important?
_____ occurs when multiple users make updates to the same database at the same time.
Nick J.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD