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!
Type of views:
Simple views and Difficult Views
Feature
Simple Views
Complex Views
Number of tables
One
One or more
Contain Functions
No
Yes
Contain groups of data
Data Manipulation
IS allowed
Not always
Let us look into some of the examples. To see all the details about existing views in
Oracle:
SELECT* FROM USER_VIEWS;
as a customer service employee explain five measures you would recommend to make even a displeased students patronize the school canteen
What is foreign key? A relation schema r1 derived from an ER schema may contain among its attributes the primary key of another relation schema r2.this attribute is known as a
What is a candidate key? Minimal super keys are known as candidate keys.
explain three types of internet risks to the consummers whent he business system is data dependent. how can we minimise these risks
Define the Two Phase Locking Protocol This is a protocol that is used to make sure serializability of transactions. This protocol needs that every transaction issue lock and u
What is schema
Write an sql statement to find what is the percentage of home policies which are from the state of Arizona out of all Home policies by Policy Value.
What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency
atient(PNumber, Name, NHS_no, Amount_due, DNO, Doctor, Medical_Treatment), relation of schema Staff(StaffNum, Name, DNO, Task) and relation of schema Dept(DNO, Name, Location, Dire
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_PRI
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