O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

QUIZ 2

Claudia Piscociu 15 perguntas Atualizado em 17 jan 2017

Fazer o quiz

Perguntas do 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. AVerdadeiro
    2. BFalso
  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?Imagem da pergunta 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

Informações

Descrição
Quiz sobre QUIZ 2, criado por Claudia Piscociu em 14-01-2017.
Idioma
English
Visualizações
12
Histórico
Criado em 14 jan 2017 · atualizado em 17 jan 2017
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?