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 all the students whose first name starts with the character ‘A’?
Q 2 - Which of the following is not a character manipulation function?
Q 3 - Which of the following is not true about the COALESCE function?
Q 4 - Which of the following is not true about SQL joins?
Q 5 - Which of the following is not true about a subquery?
Q 6 - Which of the following is true about removing rows from a table?
Q 7 - Consider the following schema −
LOCATIONS(subject_code, department_name, location_id, city);
Which code snippet will alter the table LOCATIONS and delete the column named CITY?
Q 8 - Which of the following code will remove all the rows from the table LOCATIONS?
Q 9 - Which of the following code will delete a view named all_marks_english?
Q 10 - Which of the following is not true about database synonyms?