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!
System level permissions: With the use of data dictionary you can view them.
Let us take the table name as user_sys_privs (used in oracle).
DESCRIBE USER_SYS_PRIVS ;
SELECT * FROM USER_SYS_PRIVS ;
All these commands are very definite to a data base system and may be dissimilar on dissimilar DBMS.
DATABASE OBJECTS: VIEWS, SEQUENCES, INDEXES AND SYNONYMS
Some of the important concepts in a database system are the views and indexes.
Views are a mechanism that can support data independence and security. Indexes help in better query responses. Let us discuss about them along with two more concepts sequences and synonyms in more details.
Insulation between conceptual and physical structures It can be defined as: 1. The Database Administrator should be capable to vary the storage structures without affectin
What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log. Ans: The system log, which is generally writt
Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac
Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name
anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me
Define the term Domain. For each n every attribute there is a set of permitted values known as the domain of that attribute.
What are the Issues when Selecting a Database Issues when Selecting a Database Storage space requirement: A database requires about triple storage space of the actua
Desirable Properties Of Decomposition Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection
What is an ERD?
how map binary relation one to one
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