sql 122-181

Question 1

Consider the EMPLOYEES table. When condition in the WHERE clause limit the employees to IT Programmers with salary greater than 5000?

Accepted Answer

WHERE salary>5000 AND job_id = 'IT_PROG'

Answer

WHERE salary>5000 OR job_id = "IT_PROG"

Answer

WHERE salary>5000 AND job_id = IT_PROG

Answer

WHERE salary>5000 OR job_id = 'IT_PROG'

Question 2

Consider the EMPLOYEES table. Which of the following statements displays the date in the 'January, 19 1998'?

Accepted Answer

SELECT TO_CHAR(hire_date,'fmMonth, DD YYYY') FROM employees

Answer

SELECT TO_DATE(hire_date,'fmMONTH, DD YYYY') FROM employees

Answer

SELECT TO_DATE(hire_date,'fmMonth, DD YYYY') FROM employees

Answer

SELECT TO_DATE(hire_date,'fmMON, DD YEAR') FROM employees

Question 3

Consider the EMPLOYEES table. Which of the following will generate an error?

Accepted Answer

SELECT job_id, SUM(salary) FROM employees GROUP BY employees

Answer

SELECT * FROM employees

Answer

SELECT job_id FROM employees

Answer

SELECT name FROM employees WHERE name LIKE ‘A%’

Question 4

Consider the EMPLOYEES table. Which of the following displays the maximum average salary for each department?

Accepted Answer

SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id

Answer

SELECT MAX(AVG(salary)) FROM employees

Answer

SELECT department_id, MAX(AVG(salary)) FROM employees GROUP BY department_id

Answer

SELECT AVG(MAX(salary)) FROM employees GROUP BY department_id

Question 5

Consider the TABLE table. Which of the following conditions in the WHERE clause will generate an error?

Accepted Answer

SELECT name FROM table WHERE COUNT(*) > 5;

Answer

SELECT name FROM table WHERE name LIKE ‘A%’;

Answer

SELECT name FROM table WHERE name LIKE ‘__A’;

Answer

SELECT name FROM table WHERE name LIKE ‘A__%’;

Question 6

Constraints always have a name.

Answer

true

Question 7

How to select a top

Accepted Answer

TOP or LIMIT

Answer

MAX

Answer

MIN

Answer

AVG

Question 8

Combining rows from two or more tables

Accepted Answer

JOIN

Answer

UNION

Answer

ORDER BY

Answer

GROUP BY

Question 9

Combining the result-set of two or more SELECT statements

Accepted Answer

UNION

Answer

JOIN

Answer

GROUP BY

Answer

ORDER BY

Question 10

GROUP BY is often used with aggregate functions

Answer

true

Question 11

COUNT, SUM, AVG, MAX, MIN are aggregate functions

Answer

true

Question 12

COUNT, SUM, TRIM, CONCAT are aggregate functions

Answer

true

Question 13

WHERE keyword could not be used with aggregate functions

Answer

true

Question 14

_________ operator is used to test for the existence of any record in a subquery

Accepted Answer

EXISTS

Answer

UNIQIE

Answer

IF

Answer

CASE

Question 15

Single line comments start with

Accepted Answer

--

Answer

/*

Answer

//

Answer

$$

Question 16

_________ statement is used to speed up searches/queries

Accepted Answer

INDEX

Answer

AUTO INCREMENT

Answer

DEFAULT

Answer

SEARCH

Question 17

Write SQL statement for display the department numbers wich more than 5

Accepted Answer

Select deptno, count(deptno) from emp group by deptno having count(*)>5;

Answer

Select deptno, count (deptno) from emp group by deptno having count(*)>5;

Answer

Select deptno, count (emp) from deptno group by emp having count(*)>5;

Answer

Select deptno, count(deptno) from deptno group by emp having count(*)>5;

Question 18

Delete the zip codes 050035 and 050042 from the ZIPCODE table.

Accepted Answer

DELETE FROM zipcode WHERE zip IN ('050035','050042')

Answer

DELETE FROM zipcode WHERE zip IN ('050000','050000')

Answer

DELETE FROM zipcode WHERE zip NOT ('050035','050042')

Answer

DELETE FROM zipcode WHERE zip ANY ('050030','050001')

Question 19

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true

Answer

true

Question 20

Which SQL keyword is used to sort the result-set?

Accepted Answer

ORDER BY

Answer

ORDER

Answer

SORT

Answer

SORT BY

Question 21

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

Accepted Answer

SELECT * FROM Persons ORDER BY FirstName DESC

Answer

SELECT * FROM Persons ORDER FirstName DESC

Answer

SELECT * FROM Persons SORT 'FirstName' DESC

Answer

SELECT * FROM Persons SORT BY 'FirstName' DESC

Question 22

With SQL, how can you delete the records where the "FirstName" is "Oleg" in the Persons Table?

Accepted Answer

DELETE FROM Persons WHERE FirstName = 'Oleg'

Answer

DELETE ROW FirstName='Oleg' FROM Persons

Answer

DELETE FirstName='Oleg' FROM Persons

Question 23

With SQL, how can you return the number of records in the "Persons" table?

Accepted Answer

SELECT COUNT(*) FROM Persons

Answer

SELECT LEN(*) FROM Persons

Answer

SELECT COLUMNS(*) FROM Persons

Answer

SELECT NO(*) FROM Persons

Question 24

The NOT NULL constraint enforces a column to not accept null values.

Answer

true

Question 25

______ clause can be used and is required in the subquery to perform Top-N analysis.

Accepted Answer

ORDER BY

Answer

HAVING

Answer

GROUP BY

Answer

WHERE

Question 26

Consider the EMPLOYEES table. Which of the following statements count the number of employees within each department?

Accepted Answer

SELECT department_id, COUNT(last_name) FROM employees GROUP BY department_id

Answer

SELECT department_name, COUNT(last_name) FROM employees GROUP BY department_id

Answer

SELECT department_id, department_name, COUNT(last_name) FROM employees GROUP BY department_id

Answer

SELECT department_id, COUNT(last_name) FROM departments GROUP_BY last_name

Question 27

Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987"?

Accepted Answer

SELECT last_name ||'has been working since' || hire_date FROM employees;

Answer

SELECT last_name ||'has been working since' || hire_date "Employee Information" FROM employees;

Answer

SELECT last_name |'has been working since' | hire_date FROM employees;

Answer

SELECT last_name // ”has been working since” // hire_date FROM employees;

Question 28

A SELECT statement that is embedded in a clause of another SELECT statement is called

Accepted Answer

Subquery

Answer

Main query

Answer

Inner query

Answer

Outer query

Question 29

A subquery must be enclosed in _________ .

Accepted Answer

Parantheses

Answer

Braces

Answer

Double quotes

Answer

Single quotes

Question 30

A table can be created with or without data

Answer

true

sql 122-181

Crea una cuenta gratis para terminar este test

Preguntas del test (30)

Información

Escríbenos

¿Qué te parece el nuevo diseño?