SQL

A visually engaging image featuring elements of SQL, such as database icons, coding symbols, and a quiz theme, in a modern and colorful style.

SQL Mastery Quiz

Test your knowledge of SQL with our engaging and informative quiz designed for database enthusiasts! Whether you're a beginner or an experienced developer, this quiz offers a chance to assess your skills and learn new concepts.

Multiple-choice questions
Instant feedback on your answers
Explore various SQL topics

12 Questions3 MinutesCreated by QueryMaster507

Which of the following is not true about USING clause?

When more than one column has the same name, USING clause is used for specifying the column to be joined by equijoin.

It is used for matching one column only

You can use a table name or alias in the referenced columns.

The NATURAL JOIN and the USING clauses are mutually exclusive.

You want to calculate the sum of commissions earned by the employees of an organisation. If an employee doesn’t receive any commission, it should be calculated as zero. Which will be the right query to achieve this?

Select sum(nvl(commission, 0)) from employees;

No rows are deleted if you omit the WHERE clause

You cannot delete rows based on values from another table.

All of the above.

A transaction starts when

A COMMIT statement is issued

A ROLLBACK statement is issued

A CREATE statement is used

All of the above

Which of the following is true about deleting a table from the database?

All the data in the table are deleted

The table structure is removed

The indexes in the table are deleted

All of the above.

Which of the following code will create an index named stu_marks_ind on the columns student_code and percentage_of_marks of the STUDENTS table?

It’s not possible to create an index on two columns.

Create index stu_marks_ind from students(student_code, percentage_of_marks);

Create index stu_marks_ind on students(student_code, percentage_of_marks);

Create index stu_marks_ind (student_code, percentage_of_marks) on students;

Which of the following is true about a role?

A role is a named group of related privileges.

It can be created and assigned to a user.

It can be revoked from a user.

All of the above

Which SQL statement inserts data into a table called Projects?

INSERT INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

SAVE INTO Projects (ProjectName, ProjectDescription) VALUES ('Content Development', 'Website content development project')

INSERT Projects VALUES ('Content Development', 'Website content development project')

INSERT Projects ('Content Development', 'Website content development project')

Which of the following SQL statements is correct?

SELECT CustomerName, COUNT(CustomerName) FROM Orders

SELECT CustomerName, COUNT(CustomerName) FROM Orders GROUP BY CustomerName

SELECT CustomerName, COUNT(CustomerName) FROM Orders ORDER BY CustomerName

None of the above

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are

False

True

If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:

ASC

DESC

There is no default value

Random

When inserting data in a table do you always have to specify a list of all column names you are inserting values for?

Yes

SQL Mastery Quiz

More Quizzes