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!
Describe DROP TABLE command of SQL along with both the options - CASCADE and RESTRICT.
DROP TABLE command - This command drops the specified table. Dropping a table also drops indexes and grants related with it. Objects built on dropped tables are marked invalid and cease to work.
CASCADE and RESTRICT options - The DROP TABLE with RESTRICT option destroy the table unless a few view or integrity constraint refer to the given table; if so, the command fails. Other than along with the CASCADE option, any referencing views or integrity constraints are (recursively) dropped as well.
Construct an ER diagram for a hospital along with a set of patients and a set of medical doctors Associate with every patient a log of the several tests and examinations conducted.
The State of NewYork certifies firefighters throughout state and keep track all of them, as well as of the state’s fire departments. Each fire department has unique department numb
How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View
Define Serializable schedule Serializable schedule: An interleaved schedule of much more than one transaction is known as a serializable schedule, if it is equal to some serial
what is er digram given that example of hospital,bank and library er digram.
What is indexed sequential file organization? What are the applications of this organization? Ans: An index file can be employed to effectively overcome the problem of storing
Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ
Differentiate between a subquery and a join If we need to acquire information from one or more tables after that either subquery or join can be used. If the columns which are t
Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke
We have a buildup of payments that need to be processed. You will need:- To prepare customer account on our site Process payment (you must have working Paypal account to d
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