You are now heading for the midterm exam and one of the topics you covered is advanced databases. How conversant are you with the new technologies involving databases and their use? Take up the quiz to ensure you do not fail that exam. All the best as you prepare for it.
SELECT
WHERE
FROM
LIKE
1
2
3
4
Format-sensitive, case-sensitive
Format-insensitive, case-insensitive
Case-sensitive, format-sensitive
Case-insensitive, format-insensitive
MM-DD-RR
DD-MON-RR
RR-MON-DD
MON-DD-RR
The SELECT statement retrieves the information of all employees who are in department 90
The SELECT statement retrieves the employee ID, name, job ID, and department number of all employees who are in department 90
The SELECT statement retrieves the employee's ID who are in department 90
The SELECT statement retrieves the values from employees table with department 90
Double quotation marks
Single quotation marks
Asterisks
AS keyword
!=
^=
*=
Logical conditions
Comparison conditions
Arithmetic conditions
Weather conditions
The SELECT statement retrieves values from EMPLOYEES table whose salary is less than or equal to 3,000.
The SELECT statement retrieves the last name and salary from the EMPLOYEES table for any employee whose salary is less than or equal to 3,000.
The SELECT statement retrieves the EMPLOYEES table for any employee whose salary is less than or equal to 3,000.
The SELECT statement retrieves the last name and salary from the EMPLOYEES table for any employee whose salary is less than 3,000.
True
False
AS
IN
BETWEEN
LIKE
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is 100, 101, or 201
It displays all the employees whose manager’s employee number is 100, 101, or 201
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is from 100 to 201
It displays employee numbers, last names, salaries, and manager’s employee numbers for all the employees whose manager’s employee number is btween 100 and 201
AS
LIKE
SAME
WHERE
%
_
*
#
%
_
*
#
/
\
*
#
NULLS?
IS NULLS
ISNULL
IS NULL
AND
OR
NOT
XOR
AND
OR
NOT
NOT OR
AND
OR
NOT
NOT OR
Relational
Test
Arithmetic
Logical
True
False
True
False
It displays the last name and job ID of all employees whose job ID is IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is not IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is not between IT_PROG, ST_CLERK, or SA_REP.
It displays the last name and job ID of all employees whose job ID is between IT_PROG, ST_CLERK, or SA_REP.
True
False
Wait!
Here's an interesting quiz for you.