Transcription of SQL Mock Test I - Tutorialspoint
{{id}} {{{paragraph}}}
Example: marketing
SQL Mock Test I - Tutorialspoint
mock TESTSQL mock TESTThis section presents you various set of mock tests related to SQL. You can download thesesample mock tests at your local machine and solve offline at your convenience. Every mock test issupplied with a mock test key to let you verify the final score and grade mock TEST ISQL mock TEST IQ 1 - Which of the following is not true about SQL statements?A - SQL statements are not case - SQL statements can be written on one or more - Keywords cannot be split across - Clauses must be written on separate 2 - 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 the full name of a student, with a columnheading "Name"A - select first_name, last_name as Name from students;B - select Name from students;C - select first_name || last_name as Name from students;D - select first_name, last_name from students;Q 3 - 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 the distinct honours subjects in theSTUDENTS table?
Every mock test is supplied with a mock test key to let you verify the final score and grade yourself. ... subject is English and percentage of marks more than 80, or honours subject is Spanish and percentage of marks more than 80? A - select first_name, last …
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: