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 the Difference between DROP and DELETE
DELETE deletes one or more than one tuples of a particular relation from the database. DROP is employed to remove a table from the schema. While DROP removes the definition of the relation also the data in the given relation, delete only deletes the tuples but keeps the table definition.
Question 1 What are the advantages of DBMS approach in managing data? Question 2 What are the services provided by a database system Question 3 List and briefly describe
What is the meaning of Data independence? Data independence means a programs that are not dependent on the physical attributes of data and a programs that are not dependent on
What is a relationship called when it is maintained between two entities? A relationship is called Binary relationship when it is maintained between two entities.
Write the motivations led to development of OO-DBMS? 1. Programmer frustration with RDBMSs. 2. Requirement for special features.
What is a view? Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary. Ans: View is a virtual table that does not consist
What is meant by software and hardware RAID systems? RAID can be executed with no change at the hardware level, using only software modification. Such RAID implementations are
What is Gathering information and Producing ERD Gathering information: This could be a written document that explains the system in question with reasonable quantity of detai
State the definition of association An association is a structural relationship which specifies that objects of one thing are connected with objects of another. In UML, asso
Define the concept of Object Diagram An object diagram shows a set of the objects and their relationships with each other at a point of time. In a static view, object diagram
Multiple column Queries: Syntax: SELECT COLUMN1, COL2,...... FROM TABLE WHERE (COLUMN1, COL2, ...) IN (SELECT COLUMN1, COL2,.... FROM TABLE WHERE );
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