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.
Why Like predicate used for? LIKE predicate: The LIKE predicate searches for strings in which have a certain pattern.
Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui
Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a
what is attribute is attribute inheritance in dbms?
Explain Record Based Logical Models? Record-Based logical Models: Also define data at the conceptual and view levels. Unlike object-oriented models, are used to state overall
what factors might influence a company to outsource its IT infrascture.
Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or
What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.
Suppose R is a relation with attributes A1, A2,..., An. As a function of n, tell how many superkeys R has, if: 1.1 The only key is A1. 1.2 The only key is A1 and A2. 1.3 The o
Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess
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