Following quiz provides Multiple Choice Questions (MCQs) related to SQL. You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz.
Q 1 - Consider the following schema −
STUDENTS(student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);
Which of the following query would display names of all the students whose honours subject is English, or honours subject is Spanish and percentage of marks more than 80?
Q 3 - For some particular assignment, you need to compare two values, if both are equal, the result would be null, and if the values are not equal then the first value should be returned. Which function should you use?
Q 4 - Which of the following is not true about SQL joins?
Q 5 - Which of the following is true about subqueries?
Q 6 - Which of the following comparison operators could be used in a multiple row query?
Q 7 - Which of the following is true about the SQL transaction control statements?
Q 8 - Which of the following is not true about simple views?
Q 9 - Which of the following is not true about a sequence?
Q 10 - Which of the following is not true about database synonyms?