Quiz on Operators and SQL Statements

What is the function of != operator?

• Less than

• Greater than

• Equal to

• Not equal to

Which of the following statement is used to display all the fields of a table?

• SELECT * FROM table_name

• CREATE * FROM table_name

• DISPLAY * FROM table_name

• None of the above

Which of the following are Boolean operators?

• AND, OR and NOT

• ADD, SUB, MULT and DIV

• ORDER BY and WHERE

• None of the above

Which of the following clauses is used to select records while displaying results using a SELECT statement?

• UPDATE

• ORDER BY

• WHERE

• WHICH

Which of the following operator is used with wildcard characters?

• BETWEEN ... AND ...

• IN

• LIKE

• IS NULL

Complete this query to display records in alphabetical order of field ‘StudentName’ from the table ‘StudentDetails’: SELECT * FROM StudentDetails .......................

• ORDER BY StudentName

• ORDER BY StudentName Desc

• WHERE StudentName = Asc

• WHERE StudentName = Desc

Which of the following is used to combine rows from two or more tables based on a field that is common to the tables?

• SELECT & JOIN

• SELECT & COMBINE

• MERGE

• SELECT & MERGE

What does the number in brackets of a data type represent?

• Maximum number of bytes the data type can hold

• Maximum number of bits the variable can hold

• Maximum number of characters the variable can hold

The receptionist of the hospital wants to display the PatientID and PatientName of all patients residing in Ward number 15. Which of the following is the correct statement?

• SELECT * FROM PatientDetails WHERE WardNo=15;

• SELECT Patientdetails.PatientID FROM Patientdetails WHERE WardNo=15;

• SELECT PatientID, Name FROM Patientdetails WHERE WardNo=15;

• SELECT PatientID and Name FROM Patientdetails WHERE WardNo=15;

A new patient is admitted to WardNo=20 and his details are to be entered. Which of the following represents the correct statement?

• INSERT INTO PatientDetails (PatientID, PatientName, WardNo, DateOfBirth) VALUES (“45”, “Alan Williams”,#10/08/2010#, “20”);

• INSERT INTO PatientDetails (PatientID, PatientName, DateOfBirth, WardNo) VALUES (“45”, “Alan Williams”,#10/08/2010#, “20”);

• INSERT INTO PatientDetails VALUES (“45”, “Alan Williams”,#10/08/2010#, “20”);

• Both B and C