SQL

Question 1

You can not order the results of a set operation

Answer

true

Question 2

A table can be created with or without data.

Answer

true

Question 3

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

Answer

true

Question 4

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 5

You can rename a table with the RENAME or the ALTER TABLE command.

Answer

true

Question 6

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

Accepted Answer

SUM

Answer

CONCAT

Answer

UPPER

Answer

ROUND

Question 7

Write SQL statement for display the department numbers with more than employees in each dept.

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 8

You cannot drop a user if objects exist in the user’s schema.

Answer

true

Question 9

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 10

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

Accepted Answer

UNION

Answer

UNION ALL

Answer

MINUS

Answer

INTERSECT

Question 11

Which statement discards all pending data changes

Accepted Answer

ROLLBACK

Answer

SAVEPOINT

Answer

COMMIT

Answer

DISCARD

Question 12

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

Answer

true

Question 13

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

Accepted Answer

UNOIN ALL

Answer

INTERSECT

Answer

UNION

Question 14

You can update only a single column at a time in a table.

Answer

true

Question 15

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

Answer

true

Question 16

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

Answer

true

Question 17

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

Answer

true

Question 18

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

Answer

true

Question 19

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

Answer

true

Question 20

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

Answer

true

Question 21

Any user can grant or revoke any type of system privilege to or from another user

Answer

true

Question 22

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

Answer

true

Question 23

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 24

The TRUNCATE command removes all data permanently from a table.

Answer

true

Question 25

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

Answer

true

Question 26

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

Accepted Answer

ALL

Answer

NOT

Answer

SOME

Answer

ANY

Question 27

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

Answer

true

Question 28

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

Answer

true

Question 29

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.

Answer

true

Question 30

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

Accepted Answer

ANY

Answer

NOT

Answer

ALL

Question 31

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

Answer

true

Question 32

You cannot drop a user if objects exist in the user’s schema.

Answer

true

Question 33

You can nor selectively delete rows a table.

Answer

true

Question 34

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

Answer

true

Question 35

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

Accepted Answer

INSTR

Answer

CONCAT

Answer

TRIM

Answer

SUBSTR

Question 36

Which of the following functions joins two strings together?

Accepted Answer

CONCAT

Answer

TRIM

Answer

INSTR

Answer

SUBSTR

Question 37

You can nor selectively delete rows a table.

Answer

true

Question 38

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

Accepted Answer

UNION

Answer

MINUS

Answer

UNION ALL

SQL

Create a free account to finish this quiz

Questions in this quiz (38)

Information

Feedback

What do you think of the new look?