Oracle SQL Fundamentals Quiz! Test

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Everest Emenike
E
Everest Emenike
Community Contributor
Quizzes Created: 1 | Total Attempts: 691
Questions: 10 | Attempts: 691

SettingsSettingsSettings
Oracle SQL Fundamentals Quiz! Test - Quiz

.


Questions and Answers
  • 1. 

    Which operator will be evaluated first in the following SELECT statement? SELECT (2+3*4/2-5) FROM dual;

    • A.

      *

    • B.

      +

    • C.

      /

    • D.

      -

    Correct Answer
    A. *
    Explanation
    In the SQL SELECT statement, the operator '*' (multiplication) is evaluated first in the expression (2 + 3 * 4 / 2 - 5). Following the order of operations, multiplication is prioritized over addition, division, and subtraction. The result is calculated by first multiplying 3 and 4, then dividing the result by 2, and finally adding and subtracting accordingly, yielding the final value.

    Rate this question:

  • 2. 

    Oracle Database 11g offers extensive features across the following focus areas except 

    • A.

      Manageability    

    • B.

      Search Option

    • C.

      High availability    

    • D.

      Security

    Correct Answer
    C. High availability    
    Explanation
    Oracle Database 11g offers extensive features in the areas of manageability, search option, and security. However, it does not offer extensive features in the area of high availability. High availability refers to the ability of a system to remain operational and accessible even in the event of hardware or software failures. While Oracle Database 11g does offer some features for high availability, it may not provide as extensive options as it does in the other focus areas mentioned.

    Rate this question:

  • 3. 

    Each row of data in a table is uniquely identified by a:

    • A.

      Unique key

    • B.

      Foreign keys

    • C.

      Primary key

    • D.

      Universal key

    Correct Answer
    C. Primary key
    Explanation
    A primary key is a column or a set of columns in a table that uniquely identifies each row of data. It ensures that each row has a unique identifier, which helps in distinguishing between different rows. Other keys like unique keys and foreign keys may also be used in a table, but they serve different purposes. A unique key ensures that each value in a column is unique, while a foreign key establishes a relationship between two tables. However, only a primary key guarantees the uniqueness of each row in a table.

    Rate this question:

  • 4. 

    _________ identifies the columns to be displayed, and ______________ identifies the table containing columns.

    • A.

      From and select

    • B.

      Where and select

    • C.

      Select and  from

    • D.

      From and table

    Correct Answer
    C. Select and  from
    Explanation
    "select" identifies the columns to be displayed.
    "from" identifies the table containing the columns.
    So, the correct pair is:
    "select" and "from"

    Rate this question:

  • 5. 

    Which of this is not correct about Column Alias?

    • A.

      Renames a column heading

    • B.

      Is useful with calculations    

    • C.

      Requires double quotation marks if it contains spaces or special characters or if it is case-sensitive

    • D.

      Is Oracle vendor specific

    Correct Answer
    D. Is Oracle vendor specific
    Explanation
    The statement "Is Oracle vendor specific" is not correct about Column Alias. Column Alias is not specific to any particular database vendor like Oracle. It is a feature available in most relational database management systems, including Oracle, that allows users to give a temporary or alternative name to a column in a query result.

    Rate this question:

  • 6. 

    Which of the clauses restricts the query to rows that meet a condition?

    • A.

      Where    

    • B.

      Order by

    • C.

      Distinct

    • D.

      Describe

    Correct Answer
    A. Where    
    Explanation
    The clause that restricts the query to rows that meet a condition is the "Where" clause. This clause is used to specify the conditions that the rows must meet in order to be included in the query result. It allows for filtering of the data based on specific criteria, such as selecting only rows where a certain column value is equal to a certain value or falls within a certain range.

    Rate this question:

  • 7. 

    Which statement is true regarding operators used with subqueries?

    • A.

      The NOT IN operator is equivalent to IS NULL.    

    • B.

      The <ANY operator means less than the maximum.     

    • C.

      =ANY and =ALL operators have the same functionality.    

    • D.

      The IN operator cannot be used in single-row subqueries.

    Correct Answer
    B. The <ANY operator means less than the maximum.     
    Explanation
    The

    Rate this question:

  • 8. 

    The relational model consists of the following except:

    • A.

      Collection of objects or relations

    • B.

      Data integrity for accuracy and consistency

    • C.

      Coding java with Oracle easily    

    • D.

      Set of operators to act on the relations

    Correct Answer
    C. Coding java with Oracle easily    
    Explanation
    The correct answer is "Coding java with Oracle easily". This answer is correct because the relational model does not involve coding in a specific programming language such as Java. The relational model focuses on the organization and manipulation of data through relations (tables) and the use of operators to perform operations on these relations. It also emphasizes data integrity to ensure accuracy and consistency. However, coding in Java with Oracle is not a fundamental component of the relational model.

    Rate this question:

  • 9. 

    Grant and revoke belongs to?

    • A.

      Data manipulation language (DML)    

    • B.

      Data definition language (DDL)

    • C.

      Data control language (DCL)

    • D.

      Transaction control

    Correct Answer
    C. Data control language (DCL)
    Explanation
    Grant and revoke are commands used to control access and permissions in a database. These commands are used to grant or revoke privileges such as SELECT, INSERT, UPDATE, and DELETE on database objects like tables, views, and procedures. This falls under the category of Data Control Language (DCL) which is specifically designed to manage and control access to the database. DCL commands are used to grant or revoke permissions, define roles, and manage security in a database system. Therefore, the correct answer is Data Control Language (DCL).

    Rate this question:

  • 10. 

    Keywords cannot be abbreviated or split across lines.    

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    This statement means that keywords cannot be shortened or divided into multiple parts when writing code. In programming languages, keywords have specific meanings and functions, and they must be written exactly as specified. Abbreviating or splitting keywords can lead to syntax errors and make the code difficult to understand and debug. Therefore, the statement is true.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Sep 26, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 25, 2020
    Quiz Created by
    Everest Emenike
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.