SQL Questions

0 votes, 0 avg
116

SQL Questions

1 / 15

1. In order to delete the database, which keyword is used?

2 / 15

2. Which among the following is the correct syntax for modifying the definition of an existing table?

3 / 15

3. Which statement can be used for modifying the definition for an existing table?

4 / 15

4.

In the following SQL query, what does “person” stands for? INSERT INTO person
(person_id, fname, lname)
VALUES (1,’S’,’P’);

5 / 15

5. A multiple-table delete can apply any join.

6 / 15

6. Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

7 / 15

7. SQL DELETE can be used to delete,

8 / 15

8. SQL INSERT is used to insert a –

9 / 15

9. . A View can be used to select a subset of the table columns.

10 / 15

10. Full form of DML is –

11 / 15

11. What is the meaning of “REFERENCES” in table definition?

12 / 15

12. Views are not updatable.

13 / 15

13. What is x in the following MySQL statement? DELETE FROM x USING x LEFT JOIN y ON x.col = y.col;

14 / 15

14. Which clause is used to retrieve a unique element from the table?

15 / 15

15. What is joining a table to itself called?

Your score is

The average score is 53%

0%