Theory of database (Meirzhan)

Question 1

A DISTINCT must always be user in the top-most SELECT statement of a set operation

Accepted Answer

false

Answer

true

Question 2

A parent table referenced by a child table may not be dropped

Accepted Answer

true

Question 3

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 4

A subquery must be enclosed in _________ .

Accepted Answer

Parantheses

Answer

Double quotes

Answer

Single quotes

Answer

Braces

Question 5

A table can be created with or without data

Accepted Answer

true

Question 6

Any user can grant or revoke ant type of system privileges to or from another user.

Accepted Answer

false

Answer

true

Question 7

Both object and system privileges can be granted through a single role to a user.

Accepted Answer

true

Question 8

By default, the foreign key restricts deletes of any parent row that has a corresponding child row(s).

Accepted Answer

true

Question 9

Comparison conditions fall into two classes:

Accepted Answer

Single-row operators (>, \=, >\=, <, <>,<\=) and multiple-row operators (IN,ANY,ALL)

Answer

Single-column operators (>, \=, >\=, <, <>,<\=) and multiple-column operators (IN, ANT, ALL)

Answer

Single-row operators (>, \=, >\=, <, <>,<\=) and multiple-column operators (IN,ANY,ALL)

Answer

Multiple-row operators (>, \=, >\=, <, <>,<\=) and single-row operators (IN,ANY,ALL)

Question 10

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 AND job_id \= "IT_PROG"

Answer

WHERE salary>5000 AND job_id \= IT_PROG

Answer

WHERE salary>5000 OR job_id \= 'IT_PROG'

Question 11

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000?

Accepted Answer

WHERE salary > 5000 AND salary < 18000

Answer

WHERE salary > 5000 OR salary < 18000

Answer

WHERE salary < 5000 AND salary > 18000

Answer

WHERE salary >5000 AND salary > 18000

Question 12

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose last name and first name starts with the letter 'K'?

Accepted Answer

WHERE last_name LIKE 'K%' and first_name LIKE 'K%'

Answer

WHERE last_name \= 'K%' and first_name \= 'K%'

Answer

WHERE last_name LIKE 'K_' and first_name LIKE 'K_'

Answer

WHERE last_name and first_name \= 'K%'

Question 13

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

Accepted Answer

WHERE department_id NOT IN (90,60)

Answer

WHERE department_id \= 90 AND department_id \= 60

Answer

WHERE department_id IN (90,60)

Answer

WHERE department_id \=90 PR department_id \= 60

Question 14

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the department prompted by the user?

Accepted Answer

WHERE department_id \= '&amp;Department'

Answer

WHERE department_id \= '%Department'

Answer

WHERE department_id LIKE '%Department'

Answer

WHERE department_id like '_Department'

Question 15

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,'fmMON, DD YEAR') FROM employees

Answer

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

Question 16

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

Accepted Answer

SELECT job_id, SUM(salary) FROM employees GROUP BY '&amp;Column'

Answer

SELECT * FROM employees WHERE last_name\='&amp;Name'

Answer

SELECT * FROM &amp;Table

Answer

SELECT &amp;Column FROM employees

Question 17

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 18

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" with "Employee Information" alias?

Accepted Answer

SELECT last_name ||'has been working since' || hire_date "Employee Information" 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 "Employee Information" FROM employees;

Answer

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

Question 19

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, COUNT(last_name) FROM departments GROUP_BY last_name

Answer

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

Question 20

Consider the following SQL statement. What will be the result? SELECT e.last_name, e.salary, d.department_name FROM employees e, departments d WHERE e.department_id \= d.department_id

Accepted Answer

The last names of the employees and their salaries will be displayed along with the departments names where the employees work

Answer

An error will occur since none of the JOIN operations is used

Answer

An error will occur since in the SELECT clause a column thet is used to join the tables is missing

Answer

The Cartesian product of the two tables based on the department_id column will be displayed

Question 21

Consider the SQL statement. Which of the following clauses does not sort the result rows by the salary values in the ascending order? SELECT last_name "Employee", salary "Salary" FROM employees

Accepted Answer

ORDER BY Salary DESC;

Answer

ORDER BY salary;

Answer

ORDER BY 2;

Answer

ORDER BY "Salary" ASC;

Question 22

Consider the SQL statement. Which of the following clauses does not sort the result rows by salary value in the ascending order?
SELECT last_name "Employee", salary "Salary"
FROM employees

Accepted Answer

ORDER BY salary;

Answer

ORDER BY 2;

Answer

ORDER BY "Salary" ASC;

Answer

ORDER BY Salary DESC;

Question 23

Delete the zip codes 02199 and 43011 from the ZIPCODE table. Make the change permanent.

Accepted Answer

DELETE FROM zipcode WHERE zip IN ('02199','43011') COMMIT

Answer

DELETE FROM zipcode WHERE zip ANY ('02199','43011') COMMIT

Answer

DELETE FROM zipcode WHERE zip ANY ('02199','43011')

Answer

DELETE FROM zipcode WHERE zip ALL ('02199','43011') COMMIT

Question 24

Constraints always have a name.

Accepted Answer

true

Question 25

DML statement such as INSERT, UPDATE, DELETE, and MERGE obtain a lock on the row(s), so other users cannot manipulate it.

Accepted Answer

true

Question 26

If there are schemas named USERA and USERB, and both have an EMPLOYEES table, then if USERA wants to access the EMPLOYEES table that belongs to USERB, USERA must write select statement as follows:

Accepted Answer

SELECT * FROM userb.employees;

Answer

SELECT * FROM employees;

Answer

SELECT * FROM usera.employees;

Answer

SELECT * FROM employees.userb;

Question 27

It is possible to combine from two tables that do not have a primary key/foreign key relationship into one result using a set operation.

Accepted Answer

true

Question 28

Privileges, roles, and synonyms are all used to implement security in an Oracle Database.

Accepted Answer

true

Question 29

Queries containing set operators are called ______ .

Accepted Answer

Compound queries

Answer

Subqueries

Answer

Inner queries

Answer

Outer queries

Question 30

Queries that return more than one row from the inner SELECT statement are called

Accepted Answer

Multiple-row subqueries

Answer

Multiple-column subqueries

Answer

Sing-column subqueries

Answer

Single-row subqueries

Question 31

Queries that return only one row from the inner SELECT statement are called

Accepted Answer

Single-row subqueries

Answer

Multiple-column subqueries

Answer

Single-column subqueries

Answer

Multiple-row subqueries

Question 32

What will be the result of the following SQL statement?
SELECT INITCAP(SUBSTR(CONCAT('Hello',world),4,3)) FROM DUAL;

Accepted Answer

Low

Answer

LLO

Answer

Llo

Answer

LOW

Question 33

What will be the result of the following SQL statement?
SELECT count(d.department_name), l.city
FROM departments d NATURAL JOIN locations l
GROUP BY l.city

Accepted Answer

The number of departments in EACH city is shown.

Answer

The number of department in all cities is shown

Answer

An error will occur since the GROUP BY clause cannot be used with NATURAL JOIN

Answer

The number if departments in one particular city is shown

Question 34

What will be the result of the following query?
SELECT ROUND (63.548, -1) FROM DUAL;

Accepted Answer

60

Answer

64

Answer

63

Answer

70

Question 35

What will be the result of the following SQL statement?
SELECT SUBSTR ('Hello,World!!!',13) FROM DUAL

Accepted Answer

!!!

Answer

An error will occur, since SUBSTR function need to take 3 parameters

Answer

Hello,World!!!13

Answer

Hello, World!

Question 36

The  ______ operator compares a value to every value returned by a subquery.

Accepted Answer

ALL

Answer

NOT

Answer

SOME

Answer

ANY

Question 37

The condition INSERT FIRST command evaluates the WHEN condition in order. For all conditions that are true a row is inserted into the appropriate table.

Accepted Answer

false

Answer

true

Question 38

The data dictionary view USER_TAB_PRIVS_MADE lists details of table privilege grants performed by the current user.

Accepted Answer

true

Question 39

The data of a temporary table is visible to all session.

Accepted Answer

false

Answer

true

Question 40

The NUMBER data types is usually the best choice for a primary key.

Accepted Answer

true

Question 41

The subquery generally executes ______ , and its output is used to complete the query condition for the main (or ____ ) query.{

Accepted Answer

First, outer

Answer

Last, outer

Answer

Last, inner

Answer

First, inner

Question 42

The TRANCATE command and the TRUNC function can be used interchangeably.

Accepted Answer

false

Answer

true

Question 43

The TRUNCATE command removes all data permanently from a table.

Accepted Answer

true

Question 44

The UNION and UNION ALL set operator have the opposite effect other.

Accepted Answer

false

Answer

true

Question 45

The ____ operator compares a value to EACH value returned by a subquery

Accepted Answer

ANY

Answer

NOT

Answer

SOME

Answer

ALL

Question 46

The ____ operator returns all rows that are selected by either query

Accepted Answer

UNION ALL

Answer

INTERSECT

Answer

UNION

Answer

MINUS

Question 47

The ______ constraint defines a condition that each row must satisfy.

Accepted Answer

CHECK

Answer

PRIMARY KEY

Answer

UNIQUE

Answer

FOREIGN KEY

Question 48

To obtain a list of last names that students and instructors share, you use the MINUS set operator

Accepted Answer

false

Answer

true

Question 49

Transaction control determines when data manipulates becomes permanent in a database.

Accepted Answer

true

Question 50

Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows.

Accepted Answer

UNION

Answer

MINUS

Answer

UNION ALL

Answer

INTERSECT

Question 51

What will be the result of the following SQL statement? (SYSDATE is a date of your exam)
SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual;

Accepted Answer

Friday

Answer

31.05.2013

Answer

31

Answer

31-05.2013

Question 52

What will be the result of the following SQL statement? (SYSDATE is a date of your exam)
SELECT TO_CHAR(SYSDATE, 'DD.MM.YY') FROM Dual;{

Accepted Answer

31.05.13

Answer

31.May.2013

Answer

An error will occur

Answer

31.05.2013

Question 53

When executed, this statement cannot be rolled back

Accepted Answer

DROP TABLE

Answer

ALTER TABLE

Answer

REMOVE TABLE

Answer

DELETE TABLE

Question 54

When inserting data into a table form another table, the table names and columns must be the same.

Accepted Answer

false

Answer

true

Question 55

When using LIKE condition which symbol is used to denote one character?

Accepted Answer

_

Answer

+

Answer

%

Answer

*

Question 56

When using LIKE conditions which symbol is used to denote zero or many characters?

Accepted Answer

%

Answer

+

Answer

*

Answer

_

Question 57

Which command is used to view the structure of the table LOCATIONS?

Accepted Answer

DESCRIBE LOCATIONS

Answer

SHOW STRUCTURE LOCATIONS

Answer

SELECT * FROM LOCATIONS

Answer

PRINT LOCATIONS

Question 58

Which is right of the following clauses?

Accepted Answer

SELECT...FROM...WHERE...GROUP BY...ORDER BY

Answer

SELECT... WHERE ... ORDER BY ... GROUP BY

Answer

SELECT ... FROM	... GROUP BY ... ORDER BY ... WHERE

Answer

SELECT ... FROM ... WHERE ... ORDER BY ... GROUP BY

Question 59

Which keyword is used to eliminate duplicate rows in the result?

Accepted Answer

DISTINCT

Answer

DESCRIBE

Answer

HAVING

Answer

GROUP BY

Question 60

Which keyword is used to provide an alias to a column?

Accepted Answer

AS

Answer

COLUMN

Answer

ALIAS

Answer

IS

Question 61

Which of the following clauses is used to limit the rows that are retrieved by the query?

Accepted Answer

WHERE

Answer

ORDER BY

Answer

FROM

Answer

GROUP BY

Question 62

Which of the following functions finds the numeric position of a named character?

Accepted Answer

INSTR

Answer

CONCAT

Answer

TRIM

Answer

SUBSTR

Question 63

Which of the following functions is not single-row function?

Accepted Answer

SUM

Answer

CONCAT

Answer

UPPER

Answer

ROUND

Question 64

Which of the following functions joins two strings together?

Accepted Answer

CONCAT

Answer

TRIM

Answer

INSTR

Answer

SUBSTR

Theory of database (Meirzhan)

Perguntas do quiz (81)

Informações

Fale Conosco

O que você acha do novo visual?