COMMON FUNCTIONS IN SQL

Question 1

USED TO EXECUTE TASKS SUCH AS INSERTING DELETING OR UPDATING RECORDS

Answer 1

ACTION QUERIES

Question 2

A QUERY THAT MAKES A NUMBER OF CHANGES TO VARIOUS RECORDS USING A SINGLE OPERATION

Answer 2

ACTION QUERY

Question 3

WHAT ARE THE 4 TYPES OF ACTION QUERIES

Answer 3

DELETE,APPEND,UPDATE AND MAKE-TABLE

Question 4

IS USED TO DELETE A GROUP OF RECORDS IN ONE OR MORE TABLES

Answer 4

ACTION QUERY FOR DELETE

Question 5

DELETED USING THE DELETE QUERY IT CANNOT BE UNDONE, THUS CAUTION SHOULD BE EXERCISED ALL THE TIME.

Answer 5

-ONCE A RECORD

Question 6

ENSURE THAT YOU HAVE A FALLBACK IF YOU DELETE THE WRONG RECORDS

Answer 6

ALWAYS MAKE A BACKUP COPY OF YOUR DATA

Question 7

PERFORMING A DELETE QUERY MAY DELETE RECORDS IN RELATED TABLES

Answer 7

CHECK THE DEPENDENCIES OF YOUR TABLES BEFORE USING THE DELETE QUERY

Question 8

APPENDS A GROUP OF RECORDS TO THE END OF THE TABLE FOR EXAMPLE IF WE WANT TO ADD NEW STUDENT NAMED “AND BROWN” WE USE THE ACTION QUERY FOR INSERT

Answer 8

ACTION QUERY FOR INSERT

Question 9

MAKES AN UPDATE TO A GROUP OF RECORDS IN THE EXISTING SINGLE OR MULTIPLE TIMES

Answer 9

ACTION QUERY FOR UPDATE

Question 10

ONCE AN UPDATE ACTION QUERY IS EXECUTED YOU WILL NOT BE ABLE TO RETRIEVE THE PREVIOUS DATA

Answer 10

ACTION QUERY FOR UPDATE

Question 11

TO BUILDS A NEW TABLE FROM ALL OR SOME OF THE DATA IN OTHER TABLES

Answer 11

ACTION QUERY FOR MAKE-TABLE