Test Flashcards

Keywords can't be split across lines or truncated.

Answer: True

In Oracle SQL, keywords are reserved words that have specific meanings and functions within the language. These keywords must be written as complete, unbroken units and cannot be split across multiple lines or truncated. This rule ensures that the SQL parser can correctly interpret the commands and execute the query as intended.

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

Answer: Where

The `WHERE` clause in SQL is specifically used to filter the rows returned by a query, limiting the result set to only those rows that satisfy a specified condition or set of criteria. It evaluates a boolean expression for each row and includes only the rows for which the expression is true. Other clauses like `ORDER BY` sort the results, and `DISTINCT` removes duplicates, but `WHERE` is for row-level filtering.

Which of the following statements concerning Column Alias is incorrect?

Answer: Is Oracle vendor specific

Column aliases are a standard feature in SQL, used to rename a column heading in the query's output for better readability, especially when dealing with complex expressions or calculations. They are not Oracle vendor-specific but are part of the ANSI SQL standard. If an alias contains spaces, special characters, or needs to be case-sensitive, it must be enclosed in double quotation marks.

Which of the following statements about subquery operators is correct?

Answer: The <ANY operator means less than the maximum.

The `<ANY` operator in SQL subqueries means that the value being compared is less than at least one of the values returned by the subquery. This effectively means the value is less than the maximum value present in the subquery's result set. For example, `salary < ANY (SELECT salary FROM employees WHERE department_id = 10)` would return employees whose salary is less than the highest salary in department 10.

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

Answer: From and select

In a standard SQL `SELECT` statement, the `SELECT` clause is used to identify the specific columns that you want to display in your query's output. Conversely, the `FROM` clause is used to specify the table or tables from which these columns and their corresponding data should be retrieved. This fundamental structure dictates what data is shown and where it originates.

Grant and Revoke commands are _____

Answer: Data control language (DCL)

`GRANT` and `REVOKE` commands fall under Data Control Language (DCL) in SQL. DCL commands are used to manage permissions and access rights to the database objects. `GRANT` is used to give specific privileges to users, while `REVOKE` is used to remove those privileges, ensuring data security and integrity.

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

Answer: High availability

Oracle Database 11g, like many enterprise database systems, prioritizes features related to high availability, manageability, and security to ensure robust and reliable operations. These are fundamental aspects of a production-grade database. While a 'Search Option' might be a feature within the database or an application built on it, it is not considered one of the core, overarching priority areas for the database's architecture and development in the same vein as the others.

Except for the following, the relational model consists of:

Answer: Coding java with Oracle easily

The relational model, a foundational concept in database management, primarily consists of a collection of objects (relations or tables), a set of operators to manipulate these relations (like relational algebra), and data integrity rules to ensure accuracy and consistency. 'Coding Java with Oracle easily' refers to application development and connectivity, which is external to the fundamental definition and components of the relational model itself.

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

Answer: Primary key

A primary key is a crucial constraint in a relational database that uniquely identifies each individual row of data within a table. It ensures that every record can be distinctly referenced and serves as the main identifier for that entity. Primary keys must contain unique values and cannot have NULL values.