Oracle SQL Exam Trivia Quiz!

30 Questions | By Admissions | Updated: Mar 21, 2022 | Attempts: 135

Questions

Settings

Create your own Quiz

Questions and Answers

1.

Group functions cannot be nested
- A.
  
  True
- B.
  
  False
2.

Only two tables can be JOINed in each SELECT statement
- A.
  
  True
- B.
  
  False
3.

NONEQUIJOINS are JOINs used to SELECT data between ranges of values.
- A.
  
  True
- B.
  
  False
4.

The main query executes before the subquery.
- A.
  
  True
- B.
  
  False
5.

The expression in SELECT list may not match in number when doing operations involving SET operators.
- A.
  
  True
- B.
  
  False
6.

Duplicate rows are eliminated in UNIONALL
- A.
  
  True
- B.
  
  False
7.

In SET operations, the ORDER BY clause can appear only once at the end of compound query.
- A.
  
  True
- B.
  
  False
8.

You can remove existing rows by using DELETE statement.
- A.
  
  True
- B.
  
  False
9.

TRUNCATE statement removes all rows from a table, leaving the table empty and the table structure intact.
- A.
  
  True
- B.
  
  False
10.

An automatic rollback occurs when there is abnormal termination of SQL Developer or System failure.
- A.
  
  True
- B.
  
  False
11.

A SEQUENCE logically represents subsets of data from one or more tables
- A.
  
  False
- B.
  
  True
12.

Table and Column names must begin with a letter.
- A.
  
  True
- B.
  
  False
13.

You cannot remove a view without losing data because a view is based on underlying tables in the database.
- A.
  
  False
- B.
  
  True
14.

A unique index is created automatically when you define a PRIMARY KEY or UNIQUE KEY constraints in a table definition.
- A.
  
  True
- B.
  
  False
15.

Contraints can still be added even if the table is already created.
- A.
  
  True
- B.
  
  False
16.

Remove INDEX by using DROP INDEX command.
- A.
  
  True
- B.
  
  False
17.

A table cannot be created from the result of a subquery.
- A.
  
  False
- B.
  
  True
18.

A column can be added even the table is already created.
- A.
  
  True
- B.
  
  False
19.

Regular Expressions cannot be used on CHECK Constraints.
- A.
  
  False
- B.
  
  True
20.

SQL statements are case sensitive
- A.
  
  False
- B.
  
  True
21.

Date and character literal values should be enclose within single quotation marks
- A.
  
  True
- B.
  
  False
22.

A SELECT statement always requires the presence of WHERE clause
- A.
  
  False
- B.
  
  True
23.

The default order provided by the ORDER BY clause is descending order
- A.
  
  False
- B.
  
  True
24.

You cannot use case-conversion function on the WHERE clause
- A.
  
  False
- B.
  
  True
25.

The MOD function returns the remainder of division
- A.
  
  True
- B.
  
  False