1.) (15 Points) Describe the 3 major types of SQL statements and describe the 4

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

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.