SQL Questions

0 votes, 0 avg
384

SQL Questions

1 / 15

1. The comma operator can also be used to join tables.

2 / 15

2. Which among the following are the correct definitions for “NULL” in Mysql?

3 / 15

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

4 / 15

4. Command that comes under DML is/are –

5 / 15

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

6 / 15

6. Full form of DML is –

7 / 15

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

8 / 15

8. Full form of DCL is –

9 / 15

9. Which operator is used to compare a value to a specified list of values?

10 / 15

10. Which statement is TRUE about the WHERE Clause?

11 / 15

11. By default, sorting by ORDER BY clause is done in which order?

12 / 15

12. In inner join, result is produced by matching rows in one table with rows in another table.

13 / 15

13. Is it necessary to insert the value in each column of the table?

14 / 15

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

15 / 15

15. Select the correct statement.

Your score is

The average score is 58%

0%