Advanced Database Midterm Exam

50 Questions | By Jhaicee | Updated: Mar 22, 2022 | Attempts: 2495

Questions

Settings

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.

Questions and Answers

1.

Restrict the rows that are returned by using the _________ clause
- A.
  
  SELECT
- B.
  
  WHERE
- C.
  
  FROM
- D.
  
  LIKE
2.

How many columns are presented after executing this query:SELECT address1||','||address2||','||address2 "Adress" FROM employee;
- A.
  
  1
- B.
  
  2
- C.
  
  3
- D.
  
  4
3.

Character values are ______________, and datevalues are _____________.
- A.
  
  Format-sensitive, case-sensitive
- B.
  
  Format-insensitive, case-insensitive
- C.
  
  Case-sensitive, format-sensitive
- D.
  
  Case-insensitive, format-insensitive
4.

The default date format is
- A.
  
  MM-DD-RR
- B.
  
  DD-MON-RR
- C.
  
  RR-MON-DD
- D.
  
  MON-DD-RR
5.

Which of the following BEST describes the sql statements:SELECT employee_id, last_name, job_id, department_idFROM employeesWHERE department_id = 90
- A.
  
  The SELECT statement retrieves the information of all employees who are in department 90
- B.
  
  The SELECT statement retrieves the employee ID, name, job ID, and department number of all employees who are in department 90
- C.
  
  The SELECT statement retrieves the employee's ID who are in department 90
- D.
  
  The SELECT statement retrieves the values from employees table with department 90
6.

Character strings and date values are enclosed by _____________.
- A.
  
  Double quotation marks
- B.
  
  Single quotation marks
- C.
  
  Asterisks
- D.
  
  AS keyword
7.

Which of the following operator does NOT represent the NOT EQUAL expression:
- A.
  
  !=
- B.
  
  ^=
- C.
- D.
  
  *=
8.

These are used in conditions that compare one expression to another value or expression.
- A.
  
  Logical conditions
- B.
  
  Comparison conditions
- C.
  
  Arithmetic conditions
- D.
  
  Weather conditions
9.

Which of the following BEST describes the sql statements:SELECT last_name, salaryFROM employeesWHERE salary <= 3000 ;
- A.
  
  The SELECT statement retrieves values from EMPLOYEES table whose salary is less than or equal to 3,000.
- B.
  
  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.
- C.
  
  The SELECT statement retrieves the EMPLOYEES table for any employee whose salary is less than or equal to 3,000.
- D.
  
  The SELECT statement retrieves the last name and salary from the EMPLOYEES table for any employee whose salary is less than 3,000.
10.

Values that are specified with the BETWEEN condition are inclusive.
- A.
  
  True
- B.
  
  False
11.

This condition is used to test for values in a specified set of values.
- A.
  
  AS
- B.
  
  IN
- C.
  
  BETWEEN
- D.
  
  LIKE
12.

Which of the following BEST describes the sql statements:SELECT employee_id, last_name, salary, manager_idFROM employeesWHERE manager_id IN (100, 101, 201) ;
- A.
  
  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
- B.
  
  It displays all the employees whose manager’s employee number is 100, 101, or 201
- C.
  
  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
- D.
  
  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
13.

Use the _________ condition to perform wildcard searches of valid search string values.
- A.
  
  AS
- B.
  
  LIKE
- C.
  
  SAME
- D.
  
  WHERE
14.

This symbol represents any sequence of zero or more characters for wildcard search.
- A.
  
  %
- B.
  
  _
- C.
  
  *
- D.
  
  #
15.

This symbol represents any single character for wildcard search.
- A.
  
  %
- B.
  
  _
- C.
  
  *
- D.
  
  #
16.

The ESCAPE option identifies the _______________ as the escape character.
- A.
  
  /
- B.
  
  \
- C.
  
  *
- D.
  
  #
17.

The ___________ condition tests for nulls.
- A.
  
  NULLS?
- B.
  
  IS NULLS
- C.
  
  ISNULL
- D.
  
  IS NULL
18.

This returns TRUE if both component conditions are true
- A.
  
  AND
- B.
  
  OR
- C.
  
  NOT
- D.
  
  XOR
19.

This returns TRUE if either component condition is true
- A.
  
  AND
- B.
  
  OR
- C.
  
  NOT
- D.
  
  NOT OR
20.

This returns TRUE if the following condition is false
- A.
  
  AND
- B.
  
  OR
- C.
  
  NOT
- D.
  
  NOT OR
21.

A _________condition combines the result of two component conditions to produce a single result based on those conditions, or it inverts the result of a single condition.
- A.
  
  Relational
- B.
  
  Test
- C.
  
  Arithmetic
- D.
  
  Logical
22.

You can use several conditions in one WHERE clause using the AND and OR operators.
- A.
  
  True
- B.
  
  False
23.

All character searches are case-insensitive.
- A.
  
  True
- B.
  
  False
24.

Which of the following BEST describes the sql statements:SELECT last_name, job_idFROM employeesWHERE job_idNOT IN ('IT_PROG', 'ST_CLERK', 'SA_REP') ;
- A.
  
  It displays the last name and job ID of all employees whose job ID is IT_PROG, ST_CLERK, or SA_REP.
- B.
  
  It displays the last name and job ID of all employees whose job ID is not IT_PROG, ST_CLERK, or SA_REP.
- C.
  
  It displays the last name and job ID of all employees whose job ID is not between IT_PROG, ST_CLERK, or SA_REP.
- D.
  
  It displays the last name and job ID of all employees whose job ID is between IT_PROG, ST_CLERK, or SA_REP.
25.

The rules of precedence determine the order in which expressions are evaluated and calculated
- A.
  
  True
- B.
  
  False