GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

QUIZ 2

Claudia Piscociu 15 Fragen Aktualisiert am 17 Jan 2017

Quiz starten

Fragen in diesem 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. ARichtig
    2. BFalsch
  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?Bild zu Frage 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

Informationen

Beschreibung
Quiz am QUIZ 2, erstellt von Claudia Piscociu am 14/01/2017.
Sprache
English
Aufrufe
12
Verlauf
Erstellt am 14 Jan 2017 · aktualisiert am 17 Jan 2017
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck