GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

QUIZ 2

Claudia Piscociu 15 questions Updated 17 Jan 2017

Take the quiz

Questions in this quiz (15)

  1. 1The concatenation operator ...
    1. AAll of the above
    2. BBrings together columns or character strings into other columns
    3. CCreates a resultant column that is a character expression
    4. DIs represented by two vertical bars ( || )
  2. 2The following is a valid SQL SELECT statement. True or False?
    SELECT first_name || ' ' || last_name alias AS Employee_Name
    FROM employees:
    1. ATrue
    2. BFalse
  3. 3Which comparison condition would you use to select rows that match a character pattern?
    1. ALIKE
    2. BSIMILAR
    3. CIN
    4. DALMOST
  4. 4Which statement best describes how column headings are displayed by default in Oracle Application Express:
    1. AColumn headings are displayed left-justified and in lowercase.
    2. BColumn headings are displayed centered and in uppercase.
    3. CColumn headings are displayed left-justified and in uppercase.
    4. DColumn headings are displayed centered and in mixed case.
  5. 5You need to display only unique combinations of the LAST_NAME and MANAGER_ID columns in the EMPLOYEES table. Which keyword should you include in the SELECT clause?
    1. ADISTINCT
    2. BONLY
    3. CUNIQUEONE
    4. DDISTINCTROW
  6. 6You want to retrieve a list of customers whose last names begin with the letters 'Fr' . Which keyword should you include in the WHERE clause of your SELECT statement to achieve the desired result?
    1. AAND
    2. BLIKE
    3. CIN
    4. DBETWEEN
  7. 7If the EMPLOYEES table has the following columns, and you want to write a SELECT statement to return the employee last name and department number for employee number 176, which of the following SQL statements should you use?Image for question 7
    1. ASELECT last_name, department_id
      FROM employees
      WHERE employee_id = 176;
      (*)
    2. BSELECT first_name, employee_id
      FROM employees
      WHERE employee_id = 176;
    3. CSELECT last_name, department_id
      FROM employees
      WHERE employee_id equals 176;


      SELECT last_name, department_id
      FROM employees
      WHERE employee_id equals 176;
      ;


      SELECT last_name, department_id
      FROM employees
      WHERE employee_id equals 176;


      SELECT last_name, employee_id
      FROM employees
      WHERE employee_id equals 176;
    4. DSELECT last_name, employee_id
      FROM employees
      WHERE employee_id equals 176;
  8. 8Which example would limit the number of rows returned?
    1. ASELECT title FROM d_songs WHERE type_code = 88;
    2. BSELECT title FROM d_songs WHEN type_code = = 88;
    3. CSELECT title FROM d_songs WHERE type_code = = 88;
    4. DSELECT title FROM d_songs WHEN type_code = 88;
  9. 9You want to retrieve a list of customers whose last names begin with the letters 'Fr' . Which symbol should you include in the WHERE clause of your SELECT statement to achieve the desired result?
    1. A*
    2. B#
    3. C%
    4. D~
  10. 10Evaluate this SELECT statement:
    SELECT *
    FROM employees
    WHERE department_id IN(10, 20, 30)
    AND salary > 20000;

    Which values would cause the logical condition to return TRUE?
    1. ADEPARTMENT_ID = 10 and SALARY = 20001
    2. BDEPARTMENT_ID = null and SALARY = 20001
    3. CDEPARTMENT_ID = 10 and SALARY = 20000
    4. DDEPARTMENT_ID = 20 and SALARY = 20000

Information

Description
Quiz on QUIZ 2, created by Claudia Piscociu on 14/01/2017.
Language
English
Views
12
History
Created on 14 Jan 2017 · updated on 17 Jan 2017
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?