Explain different types of Views ?
- 5 Answers
- 34496 Views
- HCL, Inbound Solutions, I also Faced
- E-Mail Answers
Answer Posted / sweta
There are two types of view-
1.Simple view(does not contain function, only one table exists,allow DML operation)
2.Complex View (Allow function,multiple table,did not allow DML operations all time)
Attributes of view --
1.with check option
2.read only
3.Force|Noforce
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Explain what are super servers?
What is a sequence in a database?
Define atomicity and aggregation.
What are the differences between drop, truncate and delete commands?
What are the features of a database management system?
What is the purpose of normalisation?
What is 2nf in the dbms?
why an information gap exists in most organizations.
Explain the necessary techniques to control deadlocks?
Describe concurrency control.
For each user who needs access, the DBA creates an account in which database?
Operators used in select statements are?
What is the relationship?
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in
what are the differences between an exclusive lock and a shared lock?
