SQL Interview Questions and Answers
Ques 66. The most important DDL statements in SQL are:
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
Ques 67. Operators used in SELECT statements.
= Equal
or != Not equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
BETWEEN an inclusive range
LIKE Search for a pattern
Ques 68. SELECT statements:
SELECT * FROM WITHOUTBOOK;
Ques 69. The INSERT INTO Statements:
INSERT INTO WITHOUTBOOK(NAME,ADDRESS) VALUES('JOHN','GURGAON, INDIA');
Ques 70. The Update Statement:
UPDATE WITHOUTBOOK SET ADDRESS='KOLKATA, INDIA' WHERE NAME='JOHN';
Most helpful rated by users: