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 DDL? Make a list of commands with short description used in DDL
Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data structures. The phrase was first introduced in relation to the Codasyl database model in which the schema of the database was written in a Data Definition Language explaining the records, fields, and "sets" making up the user Data Model.
List of DDL commands:
(a) To define a table/ relation
CREATE TABLE ------
(b) To eliminate table/relation definition
DROP TABLE ----
(iii) To alter the definition of an existing table
ALTER TABLE-------
1. Will you advise that your organization uses open source software and why? 2. Why is it important for business managers to have a basic understanding of the software development
WHAT IS DBMS
Backward Recovery (UNDO): In this system the uncommitted changes made by a transaction to a database are undone. Instead the system is reset to the last consistent state of databa
A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen
By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi
Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic
Evaluate: a.When transactions T1 and T2 are in a deadlock, one of the transactions will eventually implement to completion and let the other one continue implementation. b.
how can apply joins on table
State about the Activity Diagram Activity diagrams show flow from one activity to other. It is an ongoing non atomic execution within a state machine. Activity finally results
Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item
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