SQL Questions

0 votes, 0 avg
299

SQL Questions

1 / 15

1. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

2 / 15

2. What default value gets stored in columns of the table?

3 / 15

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

4 / 15

4. Which Statement is used to insert the values in the table?

5 / 15

5.

Will the following SQL command produce any error? INSERT INTO person
(person_id, fname,lname)
VALUES (1,’S’,’U’),
VALUES (1,’T’,’U’);
/* where person_id is a primary key */

6 / 15

6. Select the correct syntax of SELECT TOP clause?

7 / 15

7. Full form of TCL is –

8 / 15

8. How many Primary keys can have in a table?

9 / 15

9. CROSS JOIN and JOIN are similar to __________

10 / 15

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

11 / 15

11. SQL INSERT is used to insert a –

12 / 15

12. Which datatype can store unstructured data in a column?

13 / 15

13. What is the role of “CONSTRAINS” in defining a table in Mysql?

14 / 15

14. Full form of DCL is –

15 / 15

15. Which command is used for the table definition in Mysql?

Your score is

The average score is 59%

0%