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.
Describe the capabilities offered via MySQL client APIs? . • Checking for errors. . • Connecting to the MySQL server, selecting a database, disconnecting from the server
What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea
Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P
Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them. Ans: Entity: An entity is a "thing" or "object" in th
Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ
#question. acompani datdbase needs to store information about employees (identified by a social security number,with salary and phone as attributes) and departments (identified by
Explain the EXISTS and UNIQUE functions of SQL. Give an example for each? EXISTS: The EXISTS function takes one parameter that is a SQL statement. If any records exist which
Let consider the given partial relation EMP. Let us make some sub-queries for them EMPNO ENAME JOB SAL DEPTNO 7566
What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr
how many hourse have been spent on a certain project
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