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!
What are views? Explain how views are different from tables?
A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base tables or previously described views. A view does not necessarily exist in physical form; it is considered a virtual table, in contrast to base tables, whose tuples are infact stored in the database. This limits the possible update operations in which can be applied to views, but it does not provide any limitations on querying a view. A view represents a variant perspective of a base relation(s). The definition of a view in a form view statement is stored in the system catalog. Any attribute in the view could be updated as long as the attribute is simple and not derived from a computation including two or more base relation attribute. View that includes a join may or may not be updatable. Such views are not updatable if they do not include the primary keys of the base relations.
Explain pipelining. Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,
Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,.... FROM TABLE WHERE );
What is object identity? An object retains its identity even if some or all the values of variables or explanations of methods change overtime.
Describe the responsibilities of the DBA and the database designer ? The responsibilities of DBA and database designer are: 1. Planning for the database's future storage needs
Which are the two ways in which entities can participate in a relationship? Total and partial are the two ways in which entities can participate in a relationship
For the question given below, you are required to submit design and implementation documentation as described over the page. Design, implement (in Java), test and document a set of
Determine the Strong and Weak Entity Based on the method of foreign key, there might be arise a situation when we have to relate an entity having a primary key of its own and a
Convert the following ER - diagram (Entity Relationship Diagram) into a relational database (the primary keys are underlined): Ans: The relational database schema f
#questiRegional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively.
Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series
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