SQL Questions

0 votes, 0 avg
27

SQL Questions

1 / 15

1. What is the functionality of SQL COUNT?

2 / 15

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

3 / 15

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

4 / 15

4. What is xyz in the following SQL statement? DELETE FROM xyz WHERE abc = 5;

5 / 15

5. Views are not updatable.

6 / 15

6. SQL Views are also known as

7 / 15

7. CREATE VIEW xyz (abc) AS SELECT a FROM t;

8 / 15

8. Which one is not the OPTIONAL Clause in SELECT statement?

9 / 15

9. SQL INSERT is used to insert a –

10 / 15

10. Which of the following is not a valid aggregate function?

11 / 15

11. UPDATE statement is a DML statement. What does DML stand for?

12 / 15

12. A view can be deleted using the command __________

13 / 15

13. What cannot be done on a view?

14 / 15

14. What is xyz in the following MySQL statement?CREATE VIEW xyz AS SELECT a, b FROM t;

15 / 15

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

Your score is

The average score is 46%

0%