SQL Questions

0 votes, 0 avg
53

SQL Questions

1 / 15

1. Which data manipulation command is used to combines the records from one or more tables?

2 / 15

2. What is generally done if an error occurs during the transaction?

3 / 15

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

4 / 15

4. In SQL SELECT COUNT, one needs to specify the –

5 / 15

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

6 / 15

6. Which statement is TRUE about the GROUP BY Clause?

7 / 15

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

8 / 15

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

9 / 15

9. Command that comes under DML is/are –

10 / 15

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

11 / 15

11. The join where all possible row combinations are produced is called _________

12 / 15

12. Which of these is also known as a virtual table?

13 / 15

13. Full form of DCL is –

14 / 15

14.

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

15 / 15

15. What is the keyword of the Ascending and Descending?

Your score is

The average score is 55%

0%