Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 358 views

    Teste PL SQL

    Uploaded by

    Sandru Oana
    The document contains questions about PL/SQL and SQL. It tests knowledge of key characteristics of PL/SQL including: you can embed SQL within PL/SQL code; PL/SQL adds procedural, iterative, and conditional control to SQL; and PL/SQL blocks require DECLARE, BEGIN, and END sections but the exception section is optional. It also covers using DBMS_OUTPUT.PUT_LINE to display results in PL/SQL blocks.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as RTF, PDF, TXT or read online from Scribd

    Teste PL SQL

    Uploaded by

    Sandru Oana
    358 views12 pages
    The document contains questions about PL/SQL and SQL. It tests knowledge of key characteristics of PL/SQL including: you can embed SQL within PL/SQL code; PL/SQL adds procedural, iterative, and conditional control to SQL; and PL/SQL blocks require DECLARE, BEGIN, and END sections but the exception section is optional. It also covers using DBMS_OUTPUT.PUT_LINE to display results in PL/SQL blocks.

    Original Description:

    xcvxcvxc

    Original Title

    Teste Pl SQL

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    RTF, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains questions about PL/SQL and SQL. It tests knowledge of key characteristics of PL/SQL including: you can embed SQL within PL/SQL code; PL/SQL adds procedural, iterative, and conditional control to SQL; and PL/SQL blocks require DECLARE, BEGIN, and END sections but the exception section is optional. It also covers using DBMS_OUTPUT.PUT_LINE to display results in PL/SQL blocks.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    358 views12 pages

    Teste PL SQL

    Uploaded by

    Sandru Oana
    The document contains questions about PL/SQL and SQL. It tests knowledge of key characteristics of PL/SQL including: you can embed SQL within PL/SQL code; PL/SQL adds procedural, iterative, and conditional control to SQL; and PL/SQL blocks require DECLARE, BEGIN, and END sections but the exception section is optional. It also covers using DBMS_OUTPUT.PUT_LINE to display results in PL/SQL blocks.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as RTF, PDF, TXT or read online from Scribd
    Download as rtf, pdf, or txt
    You are on page 1of 12

    1.

    Which of the following statements is true?

    Mark for Review

    You can embed PL/SQL statements within SQL code.

    You can embed SQL statements within PL/SQL code.

    You can embed procedural constructs within SQL code.

    None.

    2. Nonprocedural languages allow the programmer to produce a result when a series of steps are followed. True or False? Mark for Review (1) Points

    True

    False

    3. Which of the following statements about SQL is true? Mark for Review (1) Points

    SQL is an Oracle proprietary, nonprocedural, 4GL programming language.

    SQL is an Oracle proprietary, procedural, 3GL programming language.

    SQL is an ANSI-compliant, nonprocedural, 4GL programming language.

    SQL is an ANSI-compliant, procedural, 4GL programming language.

    4. (1) Points

    PL/SQL stands for: Mark for Review

    Processing Language for SQL.

    Procedural Language extension for SQL.

    Primary Language for SQL.

    Proprietary Language for SQL.

    5.

    Which of the following statements is true?

    Mark for

    Review (1) Points

    PL/SQL is an Oracle proprietary, procedural, 3GL programming language.

    PL/SQL is an Oracle proprietary, procedural, 4GL programming language.

    PL/SQL is an Oracle proprietary, nonprocedural, 3GL programming language.

    PL/SQL is an ANSI-compliant, procedural programming language.

    6. In which three ways does PL/SQL extend the SQL programming language? Mark for Review (1) Points

    (Choose all correct answers)

    By adding procedural constructs.

    By adding compound constructs.

    By adding iterative control.

    By adding conditional control. test2 1. You can create a Web site application written entirely in PL/SQL. True or False? Mark for Review (1) Points

    True

    False

    2. for Review (1) Points

    Which of the following can be done using PL/SQL? Mark

    Create complex applications.

    Retrieve and modify data in Oracle database tables.

    Manage database tasks such as security.

    Create custom reports.

    All of the above

    3. Procedural constructs give you better control of your SQL statements and their execution. True or False? Mark for Review (1) Points

    True

    False

    4. When multiple SQL statements are combined into PL/SQL blocks, performance improves. True or False? Mark for Review (1) Points

    True

    False

    5. PL/SQL differs from C and Java in which of the following ways? (Choose two.) Mark for Review (1) Points

    (Choose all correct answers)

    It requires an Oracle database or tool.

    It does not support object-oriented programming.

    It is the most efficient language to use with an Oracle database.

    It is the most complex programming language to learn.

    It is not portable to other operating systems.

    6. Which of the following can be compiled as a standalone program outside the database? Mark for Review (1) Points

    A program developed in PL/SQL

    A program developed in Java

    A program developed in C

    All the above

    Programs developed in Java or C, but not in PL/SQL

    test 3 1. Which statements are mandatory in a PL/SQL block? (Choose two.) Mark for Review

    (1) Points

    (Choose all correct answers)

    DECLARE

    BEGIN

    EXCEPTION

    END;

    2.

    Which sections of a PL/SQL block are optional? for Review (1) Points

    Mark

    Declaration and Executable

    Declaration and Exception

    Exception only

    Executable only

    3.

    Which of the following is NOT a PL/SQL programming

    environment?

    Mark for Review

    (1) Points

    Oracle jDeveloper

    SQL*Plus

    gSQL*Plus

    SQL Workshop in Application Express

    4.

    Which of the following is a PL/SQL programming environment? Mark for Review (1) Points

    Oracle Cdeveloper

    Java*Plus

    PL/SQL Express

    SQL*Workshop in Application Express

    5.

    What are the characteristics of an anonymous block? (Choose two.) Mark for Review

    (1) Points

    (Choose all correct answers)

    Unnamed

    Stored in the database

    Compiled each time the application is executed

    Can be declared as procedures or as functions

    6.

    This PL/SQL anonymous block will execute successfully. True or False?

    DECLARE v_date DATE := SYSDATE; DBMS_OUTPUT.PUT_LINE(v_date); END; Mark for Review (1) Points

    True

    False

    7.

    How can you display results to check that a PL/SQL block is working correctly? Mark for Review (1) Points

    You don't need to do anything, the results will display automatically.

    Use an Exception section

    Use DBMS_OUTPUT.PUT_LINE

    Write a C or Java program to display the results

    8. What are the characteristics of a PL/SQL stored subprogram? (Choose two.) Mark for Review (1) Points

    (Choose all correct answers)

    Named

    Not stored in the database

    Can be invoked at any time

    Do not exist after they are executed

    9.

    What is wrong with this PL/SQL anonymous block?

    BEGIN DBMS_OUTPUT.PUT_LINE('Hello'); DBMS_OUTPUT.PUT_LINE(' and Goodbye'); (1) Points Mark for Review

    The Declaration section is missing

    The Exception section is missing

    There is nothing wrong with the block, it will work fine.

    The END; statement is missing

    10. Which lines of code will correctly display the message "Hello World" ? (Choose two.) Mark for Review (1) Points

    (Choose all correct answers)

    DBMS_OUTPUT('Hello World');

    DBMS_OUTPUT.PUT_LINE('Hello World');

    DBMS_OUTPUT.PUT_LINE('Hello' || 'World');

    DBMS_OUTPUT.PUT_LINE('Hello' || ' ' || 'World');

    11. In a PL/SQL block, which of the following should not be followed by a semicolon? Mark for Review (1) Points

    DECLARE

    END

    All SQL statements

    All PL/SQL statements

    You might also like