Excel advanced Quiz - Learn DA-DS Course in Hindi

QUIZ Time Starts !

5 minutes

Thanks you have successfully attempted the quiz.

SQL Mixture

Fill out the form to attempt test.

1 / 25

Question 1 of 25:

1. Which of the following are some common RDBMS in use?

Mysql

Oracle

SQL Server

All of Above

2 / 25

Question 2 of 25:

2. Which command is used to create a new table in SQL?

Alter

Drop

Create table

Create

3 / 25

Question 3 of 25:

3. What does the following statement in SQL do? DROP TABLE student;

Delete all records from the table student

Delete the entire table student

Describe the table

None of above

4 / 25

Question 4 of 25:

4. Which SQL statement is used to retrieve data from a database?

GET

SELECT

ALTER

RETRIEVE

5 / 25

Question 5 of 25:

5. Which of the following is used to remove data from a table in SQL?

DELETE

REMOVE

DROP

TRUNCATE

6 / 25

Question 6 of 25:

6. Which clause is used to filter records in SQL?

ORDER BY

HAVING

WHERE

GROUP BY

7 / 25

Question 7 of 25:

7. What is the default sorting order of the ORDER BY clause?

Ascending

Descending

Random

None of the above

8 / 25

Question 8 of 25:

8. Which keyword is used to retrieve unique values from a column?

UNIQUE

DISTINCT

ALTER

SELECT

9 / 25

Question 9 of 25:

9. Which SQL function is used to count the number of rows in a table?

UNIQUE

LAG()

SUM()

COUNT()

10 / 25

Question 10 of 25:

10. Which of the following is used to add a new column in a table?

MODIFY

ALTER TABLE

ADD COLUMN

ALTER_TABLE

11 / 25

Question 11 of 25:

11. What is the correct syntax for creating a database in SQL?

CREATE DATABASES db_name;

MAKE DATABASE db_name;

CREATE DATABASE db_name;

NEW DATABASE db_name;

12 / 25

Question 12 of 25:

12. Which of the following is the correct way to change a value in an existing table?

CHANGE

UPDATE

ALTER

MODIFY

13 / 25

Question 13 of 25:

13. What does the SQL JOIN clause do?

Inserts rows into two tables

Deletes rows from two table

Combines rows from two or more tables

None of the above

14 / 25

Question 14 of 25:

14. Which type of JOIN returns all rows when there is a match in one of the tables?

INNER JOIN

LEFT JOIN

FULL OUTER JOIN

RIGHT JOIN

15 / 25

Question 15 of 25:

15. Which of the following SQL statements is used to create a new table?

CREATE TABLE

NEW TABLE

CREATE TABLE AS

MAKE TABLE

16 / 25

Question 16 of 25:

16. What does the SQL keyword DISTINCT do?

Sorts the rows

Retrieves only the unique rows

Groups the rows

Deletes duplicate rows

17 / 25

Question 17 of 25:

17. Which SQL clause is used to group rows that have the same values into summary rows?

GROUP BY

ORDER BY

JOINS

HAVING

18 / 25

Question 18 of 25:

18. Which of the following is used to delete all the rows in a table without deleting the table structure?

DELETE

Retrieves only the unique rows

TRUNCATE

REMOVE

19 / 25

Question 19 of 25:

19. What is the SQL keyword used to sort the result set?

SORT BY

ORDERS BY

GROUP BY

ORDER BY

20 / 25

Question 20 of 25:

20. Which of the following is a correct syntax to update a record in a table named "Students"?

MODIFY Students SET age = 20 WHERE id = 1;

UPDATE Students SET age = 20;

CHANGE Students SET age = 20 WHERE id = 1;

UPDATE Students SET age = 20 WHERE id = 1;

21 / 25

Question 21 of 25:

21. What type of relationship does an SQL foreign key establish between two tables?

One-to-one

One-to-many

Many-to-Many

Many-to-one

22 / 25

Question 22 of 25:

22. Which of the following SQL clauses is used to eliminate duplicates from the result set?

DISTINCT

ORDER BY

GROUP BY

WHERE

23 / 25

Question 23 of 25:

23. Which SQL function is used to find the largest value in a column?

MIN()

MAX()

LARGE()

SUM()

24 / 25

Question 24 of 25:

24. What does the acronym SQL stand for?

Structured Query Language

Simple Query Language

Standard Query Language

Source Query Language

25 / 25

Question 25 of 25:

25. What is the primary key in a table?

A column that stores dates

A column that can have duplicate values

A column that uniquely identifies each row in the table

A column that stores encrypted data

Your score is

QUIZ Time Starts !

Question 1 of 25:

Question 2 of 25:

Question 3 of 25:

Question 4 of 25:

Question 5 of 25:

Question 6 of 25:

Question 7 of 25:

Question 8 of 25:

Question 9 of 25:

Question 10 of 25:

Question 11 of 25:

Question 12 of 25:

Question 13 of 25:

Question 14 of 25:

Question 15 of 25:

Question 16 of 25:

Question 17 of 25:

Question 18 of 25:

Question 19 of 25:

Question 20 of 25:

Question 21 of 25:

Question 22 of 25:

Question 23 of 25:

Question 24 of 25:

Question 25 of 25:

Resourses

Quick Links

Support