Quiz
SQL Test
This quiz has a time limit, so it opens in the usual player.
Questions in this quiz (7)
1Which of the following code would grant the role student_admin to a user named william?
- AA - grant student_admin to william;
- BB - grant to william student_admin;
- CC - grant william student_admin;
- DD - None of the above.
2Select the right query for retrieving records from the tables HONOURS_SUBJECT and LOCATIONS with a right outer join
HONOURS_SUBJECT(subject_code, subject_name, department_head);
LOCATIONS(subject_code, department_name, location_id, city);- AA - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h on right outer join location l where(h.subject_code = l.subject_code);
- BB - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h outer join location l on(subject_code);
- CC - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h right outer join location l on(h.subject_code = l.subject_code);
- DD - None of the above.
3Q - Which of the following code will remove all the rows from the table LOCATIONS?
- AA - DROP TABLE locations;
- BB - DELETE TABLE locations;
- CC - TRUNCATE TABLE locations;
- DD - None of the above.
4Which of the following is not true about modifying rows in a table?
- AA - Existing rows in a table are modified using the UPDATE statement.
- BB - You can update more than one row at a time.
- CC - All the rows in a table are modified if you omit the WHERE clause.
- DD - None of the above.
5Q 11 - 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 the STUDENTS table?- AA - select honours_subject from students;
- BB - select distinct honours_subject from students;
- CC - select all honours_subject from students;
- DD - select * from students;
6Q 12 - Which of the following is not a character manipulation function?
- AA - concat
- BB - substr
- CC - instr
- DD - coalesce
7Q 14 - Which of the following is true about inserting news rows to a table?
- AA - You must list values in the default order of the columns in the table.
- BB - You can also list the columns in the INSERT clause.
- CC - You can use the INSERT statement to add rows from one table to another.
- DD - All of the above.
Information
- Description
- Basic SQL Test
- Author
- lorraine.charles
- Language
- English
- Views
- 0
- Rating
- No ratings yet Rate this quiz