CMMI,.NET,JAVA,Networking,Oracle,SQL Server, Testing Questions And Answers

Home| Forums | Join Google Group | Join Yahoo Group | Jobs

Earn Money
Trading Forex Online
  Paramount Airways
  Free Data Recovery
Cargo
Job Portal
  HSBC Investment
Management
Cheap Web Hosting
  Make Trip
  Cheap Air Travel
Leisure Hotel
  Free Air Travel
  Mutual Fund Informations
Cheapest Cellular Plan
Free Sexy Indians
  Call Center Software
  Hot Indian

Programming Help | Homework Help | Counseling
Astrology Advice | Tarot Advice | Parenting
Dating Advice | Love Advice | Divorce Advice
Legal Advice | Debt Advice | Career Advice
11. Explain an Oracle view?
A view is a virtual table. Every view has a query attached to it. (The query is a SELECT
statement that identifies the columns and rows of the table(s) the view uses.)
12. Do a view contain data?
Views do not contain or store data.
13. Can a view based on another view?
Yes.
14. Explain the advantages of views?
- Provide an additional level of table security, by restricting access to a predetermined set of
rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
15. Explain an Oracle sequence?
A sequence generates a serial list of unique numbers for numerical columns of a database's
tables.
16. Explain a synonym?
A synonym is an alias for a table, view, sequence or program unit.
17. Explain the types of synonyms?
There are two types of synonyms private and public.
18. Explain a private synonym?
Only its owner can access a private synonym.
19. Explain a public synonym?
Any database user can access a public synonym.
20. Explain synonyms used for?
- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.