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

Sign up free

Quiz

QUIZ

Jairo 12 questions

Take the quiz

Questions in this quiz (12)

  1. 1Identify the SELECT statements that execute successfully.
    1. ASELECT first_name, last_name, job_id, salary*12
      AS Yearly Sal
      FROM employees;
    2. BSELECT first_name, last_name, job_id, salary*12
      "yearly sal"
      FROM employees;
    3. CSELECT first_name, last_name, job_id, salary AS
      "yearly sal"
      FROM employees;
    4. DSELECT first_name+last_name AS name, job_Id,
      salary*12 yearly sal
      FROM employees;
  2. 2Which of the following are valid operators for the WHERE clause?
    1. A>=
    2. BIS NULL
    3. C!=
    4. DIS LIKE
    5. EIN BETWEEN
    6. F<>
  3. 3Which of the following statements are true about single-row
    functions?
    1. AManipulate data items
    2. BAccept arguments and return one value per argument
    3. CAct on each row that is returned
    4. DReturn one result per set of rows
    5. EMay not modify the data type
    6. FCan be nested
    7. GAccept arguments that can be a column or an expression
  4. 4The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
    1. ATrue
    2. BFalse
  5. 5Identify the guidelines for group functions and the GROUP BY clause.
    1. AYou cannot use a column alias in the GROUP BY clause.
    2. BThe GROUP BY column must be in the SELECT clause.
    3. CBy using a WHERE clause, you can exclude rows before dividing them into groups.
    4. DThe GROUP BY clause groups rows and ensures order of the result set.
    5. EIf you include a group function in a SELECT clause, you cannot select individual results as well.
  6. 6The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax
    support?
    1. AEquijoins
    2. BNonequijoins
    3. CLeft OUTER join
    4. DRight OUTER join
    5. EFull OUTER join
    6. FSelf joins
    7. GNatural joins
    8. HCartesian products
  7. 7Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search
    value(s) in the second query.
    1. ATrue
    2. BFalse
  8. 8Identify the set operator guidelines.
    1. AThe expressions in the SELECT lists must match in number.
    2. BParentheses may not be used to alter the sequence of execution.
    3. CThe data type of each column in the second query must match the data type of its corresponding column in the first query.
    4. DThe ORDER BY clause can be used only once in a compound query, unless a UNION ALL operator is used.
  9. 9The following statements produce the same results:Image for question 9
    1. ATrue
    2. BFalse
  10. 10You can use constraints to do the following:
    1. AEnforce rules on the data in a table whenever a row is inserted, updated, or deleted.
    2. BPrevent the deletion of a table.
    3. CPrevent the creation of a table.
    4. DPrevent the creation of data in a table.

Information

Description
database
Language
Español
Views
225
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?