QUIZ

Description

database
Jairo Jairo
Quiz by Jairo Jairo, updated more than 1 year ago
Jairo Jairo
Created by Jairo Jairo about 9 years ago
178
0

Resource summary

Question 1

Question
Identify the SELECT statements that execute successfully.
Answer
  • SELECT first_name, last_name, job_id, salary*12 AS Yearly Sal FROM employees;
  • SELECT first_name, last_name, job_id, salary*12 "yearly sal" FROM employees;
  • SELECT first_name, last_name, job_id, salary AS "yearly sal" FROM employees;
  • SELECT first_name+last_name AS name, job_Id, salary*12 yearly sal FROM employees;

Question 2

Question
Which of the following are valid operators for the WHERE clause?
Answer
  • >=
  • IS NULL
  • !=
  • IS LIKE
  • IN BETWEEN
  • <>

Question 3

Question
Which of the following statements are true about single-row functions?
Answer
  • Manipulate data items
  • Accept arguments and return one value per argument
  • Act on each row that is returned
  • Return one result per set of rows
  • May not modify the data type
  • Can be nested
  • Accept arguments that can be a column or an expression

Question 4

Question
The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
Answer
  • True
  • False

Question 5

Question
Identify the guidelines for group functions and the GROUP BY clause.
Answer
  • You cannot use a column alias in the GROUP BY clause.
  • The GROUP BY column must be in the SELECT clause.
  • By using a WHERE clause, you can exclude rows before dividing them into groups.
  • The GROUP BY clause groups rows and ensures order of the result set.
  • If you include a group function in a SELECT clause, you cannot select individual results as well.

Question 6

Question
The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax support?
Answer
  • Equijoins
  • Nonequijoins
  • Left OUTER join
  • Right OUTER join
  • Full OUTER join
  • Self joins
  • Natural joins
  • Cartesian products

Question 7

Question
Using 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.
Answer
  • True
  • False

Question 8

Question
Identify the set operator guidelines.
Answer
  • The expressions in the SELECT lists must match in number.
  • Parentheses may not be used to alter the sequence of execution.
  • The data type of each column in the second query must match the data type of its corresponding column in the first query.
  • The ORDER BY clause can be used only once in a compound query, unless a UNION ALL operator is used.

Question 9

Question
The following statements produce the same results:
Answer
  • True
  • False

Question 10

Question
You can use constraints to do the following:
Answer
  • Enforce rules on the data in a table whenever a row is inserted, updated, or deleted.
  • Prevent the deletion of a table.
  • Prevent the creation of a table.
  • Prevent the creation of data in a table.

Question 11

Question
To do which three of the following can you use constraints?
Answer
  • Enforce rules on the data in a table whenever a row is inserted, updated, or deleted.
  • Prevent the dropping of a table.
  • Prevent the creation of a table.
  • Prevent the creation of data in a table.

Question 12

Question
Indexes must be created manually and serve to speed up access to rows in a table.
Answer
  • True
  • False
Show full summary Hide full summary

Similar

Práctica de Biología para la Prepa 1
Raúl Fox
Quiz de articulaciones y múculos
Paola Mendoza
Práctica de Biología para la Prepa 2
Raúl Fox
Mantenimiento preventivo y predictivo de computadores
David Rojas
¿Cuánto sabes sobre la Población Mundial?
crisferroeldeluna
Certificación Java 8 - Oracle Certified Associate - Tema 1 - Estructura de Clases
Miguel Gómez Cuesta
Quizz MIembro Superior
Alfredo HC
EXAMEN EXTRAORDINARIO QUIMICA II 2016
Juan Gaudencio Gutiérrez Ruiz
Top 10 Motivos para Estudiar en el Extranjero
Diego Santos
AXIS QUIZ
Luis Guzmán