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 are the DBMS languages? Explain.
Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc.
b) Data Manipulation language (DML): DML is employed to express database queries and update. For example: SELECT, UPDATE, DELETE statements, etc.
Discuss The difference between drop table R and delete from R. DROP TABLE command deletes all the records with the table definition. This command will automatically committed
Information about a bank is about customers and their account. Customer has a name, address that consists of house number, area and city, and one or more phone numbers. Account ha
Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro
Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea
In Database software have only pure security or some dis secured by administrator?
Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.
Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat
What is a B+-Tree index? A B+-Tree index takes the form of a balanced tree in which each path from the root of the root of the root of the tree to a leaf of the tree is of the
What is a SELECT operation? The select operation selects tuples that please a given predicate. We use the lowercase letter σ to denote selection.
What are the properties of transaction? There are three properties of transactions :- A) Atomicity B) Consistency C) Isolation
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