Java SQL CRUD Quiz 1 – SQL Online Test | Online Quiz | Mock Exam

Which of the following is used to find the maximum value in a column?

Sometimes the expression “select count(*)” will return fewer rows than the expression “select count(value)”.

Which of the following SQL statement is used to remove rows from a table?

The only way to join two tables is by using standard, ANSI syntax.

With SQL, how can you return the number of records in the “Persons” table?

A NULL value is treated as a blank or 0.

With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

Given an employees table as follows:
empid name managerid
——————————————-
a1 bob NULL

b1 jim a1

B2 tom a1

What value will select count(*) from employees return?

What type of lock will deny users any access to a table?

The result of a SELECT statement can contain duplicate rows.

List all Employees including their First and Last names, Departments and Posts only?

What would you add to a select query to arrange the list by FirstName in descending alphabetical order?

In “Select e.EmpID, e.FirstName, h.NormalHours *2 from Employee as e inner join HoursWorked as h on Employee.EmpID = HoursWorked.EmpID where e.EmpID = 10001”, the word “as” is optional in the query?

The main MySQL program that does all the data handling is called?

What type of query can add new information into the database?

Removing the word “inner” from the join statement in “Select e.EmpID, e.FirstName, h.NormalHours *2 from Employee as e inner join HoursWorked as h on Employee.EmpID = HoursWorked.EmpID where e.EmpID = 10001” query will have no effect on the results?

What keyword wraps the data that you would like to insert in an INSERT query?

The result of a SELECT statement can contain duplicate rows.

What will be the result of: Select e.Department, sum(h.NormalHours) from Employee as e inner join HoursWorked as h on e.EmpID = h.EmpID where e.Department like ´Proje%´ Group by e.Department

In the query “SELECT address FROM users”, what is the column being selected?