SQL Test

Question 1 of 9

1

Which of the following code would grant the role student_admin to a user named william?

Select one of the following:

A - grant student_admin to william;
B - grant to william student_admin;
C - grant william student_admin;
D - None of the above.

Explanation

Question 2 of 9

1

Select 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);

Select one of the following:

A - 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);
B - select h.subject_name, l.department_name, h.department_head, l.city from honours_subject h outer join location l on(subject_code);
C - 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);
D - None of the above.

Explanation

Question 3 of 9

1

Q - Which of the following code will remove all the rows from the table LOCATIONS?

Select one of the following:

A - DROP TABLE locations;
B - DELETE TABLE locations;
C - TRUNCATE TABLE locations;
D - None of the above.

Explanation

Question 4 of 9

1

Which of the following is not true about modifying rows in a table?

Select one of the following:

A - Existing rows in a table are modified using the UPDATE statement.
B - You can update more than one row at a time.
C - All the rows in a table are modified if you omit the WHERE clause.
D - None of the above.

Explanation

Question 5 of 9

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 the distinct honours subjects in the STUDENTS table?

Select one of the following:

A - select honours_subject from students;
B - select distinct honours_subject from students;
C - select all honours_subject from students;
D - select * from students;

Explanation

Question 6 of 9

1

Q 12 - Which of the following is not a character manipulation function?

Select one of the following:

A - concat
B - substr
C - instr
D - coalesce

Explanation

Question 7 of 9

1

Q 14 - Which of the following is true about inserting news rows to a table?

Select one of the following:

A - You must list values in the default order of the columns in the table.
B - You can also list the columns in the INSERT clause.
C - You can use the INSERT statement to add rows from one table to another.
D - All of the above.

Explanation

Question 8 of 9

1

Given the following data definition, select all queries that return a list of employees who are not managers.
TABLE emp
id INTEGER NOT NULL PRIMARY KEY
mgrId INTEGER REFERENCES emp (id)
name VARCHAR(30) NOT NULL

Select one of the following:

A SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT DISTINCT m.mgrId FROM emp m)
B SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT DISTINCT m.mgrId FROM emp m WHERE m.mgrId IS NOT NULL)
C SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT m.mgrId FROM emp m)
D SELECT e.name FROM emp e
WHERE e.id NOT IN (
SELECT m.mgrId FROM emp m WHERE m.mgrId IS NOT NULL)

Basic SQL Test

Question 1 of 9

Which of the following code would grant the role student_admin to a user named william?

Select one of the following:

Explanation

Question 2 of 9

Select 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);

Select one of the following:

Explanation

Question 3 of 9

Q - Which of the following code will remove all the rows from the table LOCATIONS?

Select one of the following:

Explanation

Question 4 of 9

Which of the following is not true about modifying rows in a table?

Select one of the following:

Explanation

Question 5 of 9

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?

Select one of the following:

Explanation

Question 6 of 9

Q 12 - Which of the following is not a character manipulation function?

Select one of the following:

Explanation

Question 7 of 9

Q 14 - Which of the following is true about inserting news rows to a table?

Select one of the following:

Explanation

Question 8 of 9

Given the following data definition, select all queries that return a list of employees who are not managers.
TABLE emp
id INTEGER NOT NULL PRIMARY KEY
mgrId INTEGER REFERENCES emp (id)
name VARCHAR(30) NOT NULL

Select one of the following:

Explanation

Question 9 of 9

9. Which of the follwing statements is/are not true for SQL profiler?

Select one of the following:

Explanation

	Created by rahim.ali over 8 years ago

Basic SQL Test

SQL Test

Question 1 of 9

Which of the following code would grant the role student_admin to a user named william?

Select one of the following:

Explanation

Question 2 of 9

Select 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);

Select one of the following:

Explanation

Question 3 of 9

Q - Which of the following code will remove all the rows from the table LOCATIONS?

Select one of the following:

Explanation

Question 4 of 9

Which of the following is not true about modifying rows in a table?

Select one of the following:

Explanation

Question 5 of 9

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?

Select one of the following:

Explanation

Question 6 of 9

Q 12 - Which of the following is not a character manipulation function?

Select one of the following:

Explanation

Question 7 of 9

Q 14 - Which of the following is true about inserting news rows to a table?

Select one of the following:

Explanation

Question 8 of 9

Given the following data definition, select all queries that return a list of employees who are not managers. TABLE emp id INTEGER NOT NULL PRIMARY KEY mgrId INTEGER REFERENCES emp (id) name VARCHAR(30) NOT NULL

Select one of the following:

Explanation

Question 9 of 9

9. Which of the follwing statements is/are not true for SQL profiler?

Select one of the following:

Explanation

Select 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);

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?

Given the following data definition, select all queries that return a list of employees who are not managers.
TABLE emp
id INTEGER NOT NULL PRIMARY KEY
mgrId INTEGER REFERENCES emp (id)
name VARCHAR(30) NOT NULL