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.
Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP's Business Information Warehouse to better understand their
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
What is the use of sub queries? A sub query is a select-from-where expression that is nested with in another query. A common use of sub queries is to do tests for set membershi
Primary Key The primary key is the candidate key that is selected by the database designer as the principal denotes of identifying entities within an entity set. The left candi
What is a guard condition? Explain it with a suitable example. The guard-condition is a Boolean expression written with respect to parameters of triggering event and attributes
explain participation constraints with examples
Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have
What subschema expresses ? A subschema expresses the external view. (External schemas are called also called as subschemas)
What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.
Two Phase Locking (2PL) The two-phase locking protocol having of two phases: Phase 1 : The lock acquisition phase : If a transaction T needs to read an object, it wants to
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