SQL INTERVIEW QUESTIONS PART-3 FREE DOWNLOAD

HI FRIENDS,
           HERE YOU CAN GET SOME IMPORTANT QUESTIONS THAT ARE ASK IN ALL INTERVIEW AND VI-VA.

HERE I COVERED MANY TOPIC WITH DIFFERENT QUESTIONS. THESE QUESTIONS ARE FOR BEGINNER  OR PROFESSIONALS.

INTERVIEW QUESTIONS ARE ON TOPIC THAT ARE COVERED IN THIS BLOG AREJAVA, C. C++, SOFTWARE TESTING, SOFTWARE ENGG, NETWORKING ETC.
 


  1) What are most important DDL Commands in SQL?

CREATE TABLE - creates a new database table
ALTER TABLE - alters (changes) a database table
DROP TABLE - deletes a database table
CREATE INDEX - creates an index (search key)
DROP INDEX - deletes an index

2) What are the Operators used in SELECT statements?
= Equal

<> or != Not equal

> Greater than

< Less than

>= Greater than or equal

<= Less than or equal

BETWEEN Between an inclusive range LIKE Search for a pattern

3) How to INSERT Values into Tables?

INSERT INTO table_name VALUES (value1, value2,....)

INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)

4) How to Update a Column Name?

UPDATE table_name SET column_name = new_value WHERE column_name = some_value

5) How to Delete Columns, Rows?


Delete a particular column:

DELETE FROM table_name WHERE column_name = some_value

Delete All Rows:

DELETE FROM table_name or DELETE * FROM table_name



6) Give an usage for BETWEEN ... AND?


SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.

FOR MORE DOWNLOAD FROM BELOW LINK

SO DOWNLOAD INTERVIEW QUESTION FROM BELOW LINK.

SQL  INTERVIEW QUESTIONS PART-1

SQL INTERVIEW QUESTIONS PART-2

BEST OF LUCK IN ADVANCE......GOD IS ALWAYS WITH YOU

IF yOU HAVE ANY STOCK OF QUESTION, THEN PLEASE SEND ME FOR OTHER HELPFUL STUDENTS.
 
THANK

Posted in: INTERVIEW QUESTIONS