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

Kostenlos registrieren

Quiz

QUIZ 4

Claudia Piscociu 15 Fragen

Quiz starten

Fragen in diesem Quiz (15)

  1. 1Which query selects the first names of the DJ On Demand clients who have a first name beginning with "A"?
    1. ASELECT UPPER(first_name)
      FROM d_clients
      WHERE first_name LIKE '%a%'
    2. BSELECT UPPER(first_name)
      FROM d_clients
      WHERE first_name LIKE 'a%'
    3. CSELECT UPPER(first_name)
      FROM d_clients
      WHERE first_name LIKE %a%
    4. DSELECT UPPER(first_name)
      FROM d_clients
      WHERE LOWER(first_name) LIKE 'a%'
  2. 2What will the following SQL statemtent display?
    SELECT last_name, LPAD(salary, 15, '$')SALARY
    FROM employees;
    1. AThe query will result in an error: "ORA-00923: FROM keyword not found where expected."
    2. BThe last name of employees that have a salary that includes a $ in the value, size of 15 and the column labeled SALARY.
    3. CThe last name and salary for all employees with the format of the salary 15 characters long, left-padded with the $ and the column labeled SALARY.
    4. DThe last name and the format of the salary limited to 15 digits to the left of the decimal and the column labeled SALARY.
  3. 3Which query would return a user password combining the ID of an employee and the first 4 digits of the last name?
    1. ASELECT CONCAT (employee_id, INSTR(last_name,4,1))
      AS "User Passwords"
      FROM employees
    2. BSELECT CONCAT (employee_id, SUBSTR(last_name,4,1))
      AS "User Passwords"
      FROM employees
    3. CSELECT CONCAT (employee_id, INSTR(last_name,1,4))
      AS "User Passwords"
      FROM employees
    4. DSELECT CONCAT (employee_id, SUBSTR(last_name,1,4))
      AS "User Passwords"
      FROM employees
  4. 4Which of the following SQL statements would correctly return a song title identified in the database as "All These Years"?
    1. AWHERE title IN('All','These','Years');
    2. BWHERE title LIKE INITCAP('%all these years');
    3. CWHERE title LIKE LOWER('all these years');
    4. DWHERE title CONTAINS 'Years';
  5. 5 Which of the following are types of SQL functions? (Choose two correct answers.)

    1. AColumn-Row Functions
    2. BMany-to-Many Functions
    3. CMulti-Row Functions
    4. DSingle-Row Functions
  6. 6You need to display the current year as a character value (for example: Two Thousand and One). Which element would you use?
    1. ARR
    2. BYEAR
    3. CYY
    4. DYYYY
  7. 7Evaluate this SELECT statement:
    SELECT SYSDATE + 30
    FROM dual;

    Which value is returned by the query?
    1. AThe current date plus 30 days.
    2. BNo value is returned because the SELECT statement generates an error.
    3. CThe current date plus 30 months.
    4. DThe current date plus 30 hours.
  8. 8You need to subtract three months from the current date. Which function should you use?
    1. ATO_DATE
    2. BADD_MONTHS
    3. CROUND
    4. DMONTHS_BETWEEN
  9. 9The EMPLOYEES table contains these columns:
    LAST_NAME VARCHAR2(20)
    FIRST_NAME VARCHAR2(20)
    HIRE_DATE DATE
    EVAL_MONTHS NUMBER(3)

    Evaluate this SELECT statement:

    SELECT hire_date + eval_months
    FROM employees;

    The values returned by this SELECT statement will be of which data type?
    1. ADATETIME
    2. BINTEGER
    3. CNUMBER
    4. DDATE
  10. 10What is the result of the following query?
    SELECT ADD_MONTHS ('11-Jan-1994',6)
    FROM dual;
    1. A11-Jul-1994
    2. B11-Jan-1995
    3. C17-Jul-1994
    4. D17-Jan-1994

Informationen

Beschreibung
Quiz am QUIZ 4, erstellt von Claudia Piscociu am 14/01/2017.
Sprache
English
Aufrufe
12
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck