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
Is it helpful?
Add CommentView Comments
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
Is it helpful?
Add CommentView Comments
Ques 68. SELECT statements:
SELECT * FROM WITHOUTBOOK;
Is it helpful?
Add CommentView Comments
Ques 69. The INSERT INTO Statements:
INSERT INTO WITHOUTBOOK(NAME,ADDRESS) VALUES('JOHN','GURGAON, INDIA');
Is it helpful?
Add CommentView Comments
Ques 70. The Update Statement:
UPDATE WITHOUTBOOK SET ADDRESS='KOLKATA, INDIA' WHERE NAME='JOHN';