Oracle SQL

Oracle SQL Test 1

0%

Keywords can't be split across lines or truncated.

Correct! Wrong!

Explanation:
You can't divide certain terms like Table Nam across lines or abbreviate them, thus you can't split them.

Which clause limits the query to rows that fulfill a set of criteria?

Correct! Wrong!

Explanation:
Using the WHERE clause, you can limit the number of rows returned from the query. The FROM clause is followed by the WHERE clause, which provides a condition that must be met. If the condition is true, the returned row is the one that meets the criteria.

Which of the following statements concerning Column Alias is incorrect?

Correct! Wrong!

Explanation:
A column alias is a different name for a column that is used temporarily. Aliases are used in the SELECT clause to rename or rename columns in order to make the result table more readable. A column that is the result of an arithmetic expression or a summary function is commonly referred to as an alias.

Which of the following statements about subquery operators is correct?

Correct! Wrong!

Explanation:
A subquery returns data that will be used as a condition in the main query to further limit the data that can be retrieved. Subqueries can be used with SELECT, INSERT, UPDATE, and DELETE statements, as well as operators such as =, >, >=, =, IN, BETWEEN, and others.

The columns to be shown are identified by_______, while the table containing columns is identified by _______ .

Correct! Wrong!

Explanation:
The columns to be displayed are identified by from, and the table containing the columns is identified by select.

Grant and Revoke commands are _____

Correct! Wrong!

Explanation:
The DCL commands are the Grant and Revoke commands. The GRANT command is used to grant users authorization, whereas the REVOKE command is used to revoke such authorization.

Except for the following priority areas, Oracle Database 11g has a lot of features.

Correct! Wrong!

Explanation:
Oracle Database Enterprise Edition gives mission-critical applications including high-volume online transaction processing (OLTP) applications, query-intensive data warehouses, and demanding Internet applications the performance, availability, scalability, and security they demand.

Except for the following, the relational model consists of:

Correct! Wrong!

Explanation:
A rational model database is one that allows you to organize your data into one or more separate tables that can be linked together using fields that are common to all associated tables.
Three major elements form the relational model:
1. The set of relationships and domains that define the many ways in which data can be represented (data structure).
2. Integrity rules are procedures that outline how to protect data (data integrity).
3. The kind of procedures that can be carried on on data (data manipulation).

A unique identifier for each row of data in a table is:

Correct! Wrong!

Explanation:
In a table, a primary key is a column or a collection of columns that uniquely identifies a row.