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

Sign up free

Quiz

QUIZ 4

Claudia Piscociu 15 questions

Take the quiz

Questions in this 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

Information

Description
Quiz on QUIZ 4, created by Claudia Piscociu on 14/01/2017.
Language
English
Views
12
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?