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!
Explain view in RDBMS?
View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a relation. Instead, a view is a named table in which is represented, not through its own physically separate stored data, but through its definition in terms of other named tables (base tables or views). The base relations on that a view is based are sometimes known as the existing relations. The definition of a view in a create view statement is stored within the system catalog. The syntax to create a view is:
CREATE [OR REPLACE] VIEW [()] AS
WITH {READ ONLY|CHECK OPTION [CONSTRAINT
]};
Define the Immediate Update The immediate update methods may apply changes to the database on disk before the transaction arrives a successful conclusion. Though, these change
Explain data dictonary on oracle ? Data Dictionary - Data dictionaries are the system tables in which contain descriptions of the database objects and how they are structured.
What is Object Oriented model? This model is based on collection of objects. An object has values stored in instance variables with in the object. An object also having bodies
What are the advantages of having an index structure? Ans: The index structures commonly provide secondary access paths, which offer alternative ways of accessing the reco
WHY SHOULD NULL IN A RELATION BE AVOID AS possible?
The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.
Why does a DBMS query language is designed? A DBMS query language is designed to support end users who use English-like commands. support in the development of complex applicat
Project Description: Need Point of Sale software for pizza restaurant. Delivery and take out service, client's database, inventory control, order history, last order, order from
Explain the concept of QBE? Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tab
Express types of information available in MySQL? Information as regards the result of queries: This includes number of records affected by any SELECT or UPDATE or DELETE st
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd