SQL
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
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
Which SQL keyword is used to sort the result-set?
ORDER BY
ORDER
SORT BY
All of the above
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
No
{"name":"SQL", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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 questionsInstant feedback on your answersExplore various SQL topics","img":"https:/images/course7.png"}