PL/SQL Questions Exam Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By CHN11AJ115
C
CHN11AJ115
Community Contributor
Quizzes Created: 1 | Total Attempts: 4,758
| Attempts: 4,758
SettingsSettings
Please wait...
  • 1/10 Questions

    Assuming today is Monday, 21 NOV 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;  

    • 03-NOV-00
    • 10-NOV-00
    • 28-NOV-00
    • 17-NOV-00
Please wait...
About This Quiz

The 'PL\/SQL Questions Exam Quiz!' assesses knowledge in PL\/SQL, covering topics from basic syntax to advanced database functions. It evaluates understanding of SQL functions, exception handling, and date manipulation, crucial for database management and programming roles.

PL/SQL Questions Exam Quiz! - Quiz

Quiz Preview

  • 2. 

    How many tables may be included with a join?

    • One

    • Two

    • Three

    • All the above

    Correct Answer
    A. All the above
    Explanation
    A join operation combines rows from two or more tables based on a related column between them. In this case, the question is asking how many tables can be included in a join. The correct answer is "all the above" because a join can involve one table, two tables, or even three tables depending on the specific query and the relationships between the tables. Therefore, the answer encompasses all the possible scenarios for joining tables.

    Rate this question:

  • 3. 

    Functions for error trapping are contained in which section of a PL/SQL block?

    • Header

    • Declarative

    • Executable

    • Exception

    Correct Answer
    A. Exception
    Explanation
    The functions for error trapping are contained in the Exception section of a PL/SQL block. This section is used to handle any exceptions or errors that may occur during the execution of the block. It allows the programmer to specify what actions should be taken when a specific error occurs, such as logging the error, displaying a message, or rolling back a transaction. By including error trapping functions in the Exception section, the programmer can ensure that their code handles errors gracefully and continues to execute without crashing.

    Rate this question:

  • 4. 

    Which of the following is true concerning triggers?

    • You do not create them with SQL

    • They execute against only some applications that access a database

    • They have an event, condition, and action

    • They cannot cascade (cause another trigger to fire).

    Correct Answer
    A. They have an event, condition, and action
    Explanation
    Triggers are database objects that are created with SQL and are used to automatically execute a set of actions when a specific event occurs in a database. These events can include insertions, updates, or deletions of data. Triggers also have conditions, which determine when the trigger should be executed, and actions, which specify what actions should be performed when the trigger is fired. Therefore, the statement "They have an event, condition, and action" is true concerning triggers.

    Rate this question:

  • 5. 

    In a PL/SQL block, a variable is declared as NUMBER without an initial value. What will its value be when it is first used in the executable section of the PL/SQL block?

    • NULL

    • 0

    • Results in a compilation error

    • An exception will be raised

    Correct Answer
    A. NULL
    Explanation
    When a variable is declared as NUMBER without an initial value in a PL/SQL block, its value will be NULL when it is first used in the executable section of the block.

    Rate this question:

  • 6. 

    The SQL WHERE clause

    • Limits the column data that are returned

    • Limits the row data are returned

    • Both A and B are correct.

    • Neither a or b is correct

    Correct Answer
    A. Limits the row data are returned
    Explanation
    The correct answer is "limits the row data that are returned." The SQL WHERE clause is used to filter the rows in a table based on a specified condition. It allows you to specify a condition that must be met for a row to be included in the result set. By using the WHERE clause, you can limit the rows that are returned from a query based on specific criteria, such as filtering rows with a certain value in a particular column. Therefore, the WHERE clause limits the row data that are returned.

    Rate this question:

  • 7. 

    What is the result if two NULL values are compared to each other?

    • True

    • False

    • Undefined

    • Null

    Correct Answer
    A. Null
    Explanation
    When two NULL values are compared to each other, the result is NULL. This is because NULL represents an unknown or missing value, so the comparison cannot determine a definite result. Therefore, the answer is Null.

    Rate this question:

  • 8. 

    In this PL/SQL statement, which of the following lines will produce an error?

    • Cursor CAPITALS is

    • Select CITY, STATE

    • Into my_city, my_state

    • From CITIES

    • Where CAPITAL = 'Y'

    • There are no errors in these statements

    Correct Answer
    A. Into my_city, my_state
    Explanation
    The line "into my_city, my_state" will produce an error because the INTO clause is used to fetch data from the cursor into variables, but the variables my_city and my_state have not been declared or defined in this PL/SQL statement.

    Rate this question:

  • 9. 

    PL/SQL raises an exception, in which TWO of the following cases:

    • When a SELECT statement returns no rows

    • When a SELECT statement returns more than one row

    • When the datatypes of SELECT clause and INTO clause do not match

    Correct Answer(s)
    A. When a SELECT statement returns no rows
    A. When a SELECT statement returns more than one row
    Explanation
    PL/SQL raises an exception when a SELECT statement returns no rows because it is expecting at least one row to be returned. This can occur when the conditions in the WHERE clause are not met or when the table being queried is empty. PL/SQL also raises an exception when a SELECT statement returns more than one row because it is expecting only a single row to be returned. This can occur when the conditions in the WHERE clause are not specific enough or when there are duplicate records in the table.

    Rate this question:

  • 10. 

    Which of the following SQL functions can operate on any data type?

    • TO_CHAR

    • LOWER

    • LPAD

    • CEIL

    Correct Answer
    A. CEIL
    Explanation
    The CEIL function in SQL is used to round a number up to the nearest integer. It can operate on any data type, whether it is a numeric or non-numeric data type. This makes it a versatile function that can be used in various scenarios regardless of the data type being used.

    Rate this question:

Quiz Review Timeline (Updated): Apr 20, 2023 +

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

  • Current Version
  • Apr 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 21, 2011
    Quiz Created by
    CHN11AJ115
Back to Top Back to top
Advertisement