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 is database Trigger?
A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigger can e defined to execute once for the entire statement or once for each row that is inserted, updated, or deleted. For any one table, there are twelve events for which you can explain database triggers. A database trigger can call database procedures that are also written in PL/SQL.
Define multivalued dependency and 4NF. Ans: Multivalued Dependency - Assume R be a relation schema and let α ⊆ R and β ⊆ R. The multivalued dependency α →→β holds o
What is Secondary Index While making the index, generally the index table is kept in the primary memory (RAM) and the main table, because of its size is keeps in the secondary
Key to represent relationship amongs tables is called ? A Key that represent the relationship between tables is called Foreign Key.
What is a heterogeneous distributed database? In a heterogeneous distributed database, dissimilar sites may use different schemas, and dissimilar dbms s/w. The sites may not be
Define the Query optimisation The query parser commonly generates a standard initial tree to correspond to an SQL query, with no doing any optimization. Such type of a canonica
why data in an RDMS need to be normalised
In Oracle what is system global area and how is it organized? The SGA is a collection of shared memory fields which along with the Oracle processes constitute an Oracle instan
what do you mean by primary key constraint?
What is trigger Triggers are statements that are implemented automatically by the system as the side effect of a change to the database.
What Command You Use What Day of the week were you born
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