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.
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
Update Operations and Dealing with Constraint Violations There are three basic operations to be executes on relations: Insertion Deletion Update The INSER
Creating views with Replace option : This option is used to alter the definition of the view without recreating and dropping it or regranting object privileges previously granted o
Boyce-Codd Normal Form (BCNF) The relation NEWSTUDENT (Enrolmentno, Sno, Sname, Cname, Cno,) has every attributes participating in candidate keys as all the attributes are assu
A basic model of Database Access Control Models of database access control have grown out of previous work on protection in operating systems. Let us talk about one simple mode
Difference between Operating System and Database Security Security within the operating system can be executed at various levels ranging from passwords for access to system, t
Determine the OBJECTIVES of object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl
What is serialization? Where it is used and why? Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for
Partial Key : It is a group of attributes that can uniquely identify small entities and that are related to same base entity. It is sometime named as Discriminator. Altern
Define multivalued dependency and 4NF. Ans: Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency α →→β holds o
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd