Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Example-GRANT CREATE SESSION TO MCA12;
(This command gives system level permission on creating a session - not portable)
GRANT SELECT ON EMP TO MCA12;
(Object level permission on table EMP)
GRANT SELECT, UPDATE, INSERT, DELETE ON EMP TO MCA12;
GRANT SELECT, UPDATE ON EMP TO MCA12, MCA13;
(Two users)
GRANT ALL ON EMP TO PUBLIC;
(All permission to every users, do not use it. It is very risky for database)
Revoke: It is used to revoke the permission granted.
How does the system cope up with a record crash when recovery is going on after the first crash? Ans: In a system the undo and redo operations are needed to be idempotent to c
Give an example of operations from the State Actions and Activities. For instance, in bank the activity verify account code and verify password
What is the difference between SQL Server 2000 complete and differential backups? A complete backup makes a copy of the whole database. A differential backup creates a copy of
Types Of Indexes One of the words used during the file organisation is the term index. In this part, let us describe this term in more detail. We find the index of keywords
What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed f) Terminated
Aggregation : One limitation of the E-R diagram is that they do not permit representation of relationships between relationships. In such a case the relationship along with its ent
This project requires you to create a database design. Your design will be documented in a set of Entity-Relationship diagrams. Draw a set of Entity-Relationship diagrams to mode
Discuss the types of integrity constraints in which must be checked for the update operations - Insert and Delete. Give examples. Insert operation can violet any of the subse
Implementation and SQL Applications
Type of database technology
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd