1.) (15 Points) Describe the 3 major types of SQL statements and describe the 4
ID: 3719957 • Letter: 1
Question
1.) (15 Points) Describe the 3 major types of SQL statements and describe the 4 primary Data Manipulation statements. 2.) (15 Points) Describe all of the different options you have for the “Where” clause.(i.e. ‘Like’, ‘In’, etc) 3.) (10 Points) Describe the difference between “Order By” and “Group By”. 4.) (15 Points) Describe how the use of an INDEX will make queries using “Order By” much faster. 5.) (15 Points) Explain just what Data Integrity is and how the use of Constraints may result in better Data Integrity. 6.) (10 Points) Explain exactly how a “Join” works. What is a Cartesian Product? 7.) (15 Points) Briefly describe the difference and similarities between a “Join” and a ‘Correlated Sub-Query”. Discuss the advantages and disadvantages of each. 8.) (10 Points) Describe a Transaction. What is a transaction and what keywords are used to create transactions? 9.) (10 Points) What is the “Transaction Log”? Describe how it works and what it is used for. 10.) (10 Points) What are Triggers and Stored Procedures and how can they be used to make a database better?
Explanation / Answer
Answer:
Defining Database Structures
Data Definition Language, DDL, is the piece of SQL that enables a database client to make and rebuild database objects, for example, the creation or the cancellation of a table.
Probably the most major DDL orders talked about amid following hours incorporate the accompanying:
Make TABLE
Adjust TABLE
DROP TABLE
Make INDEX
Adjust INDEX
DROP INDEX
Make VIEW
DROP VIEW
These summons are talked about in detail amid Hour 3, "Overseeing Database Objects," Hour 17, "Enhancing Database Performance," and Hour 20, "Making and Using Views and Synonyms."
Manipulating Data
Data Manipulation Language, DML, is the piece of SQL used to control data inside objects of a social database.
There are three essential DML summons:
Embed
Refresh
Erase
These orders are examined in detail amid Hour 5, "Manipulating Data."
Selecting Data
In spite of the fact that included just a single charge, Data Query Language (DQL) is the most thought focal point of SQL for current social database clients. The base charge is as per the following:
SELECT
This summon, joined by numerous choices and conditions, is utilized to form questions against a social database. Questions, from easy to complex, from dubious to particular, can be effortlessly made. The SELECT summon is examined in thrilling point of interest amid Hours 7 through 16.
A question is a request to the database for data. An inquiry is typically issued to the database through an application interface or by means of a summon line incite.
proclamations used to control data:
Embed
Places new records, or columns, into a database table.
SELECT
Recovers already embedded columns from a database table.
Refresh
Alters data in a table.
Erase
Erases data from a table.
DEAR PLEASE DO RATE IT IF HELPS ELSE LET ME KNOW YOUR DOUBT.
THANK YOU!!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.