Halaman

Sunday, August 11, 2019

Answer Section 1 Quiz Database Programming with PL/SQL 2019 Learner - English


Section 1


Which sections of a PL/SQL block are optional?  
                                                                               
                                               
                Exception only


                                              
                Executable only

                                               
                Declaration and Exception (*)

                                               
                Declaration and Executable

                                                                               
                                                               
Errors are handled in the Exception part of the PL/SQL block. True or False?        
                                                                               
                                               
                True (*)

                                               
                False

                                                                               
In which part of the PL/SQL block are declarations of variables defined? 
                                                                               
                                               
                Declarative (*)

                                               
                Definition

                                               
                Executable

                                               
                Exception

                                                                               
Which of the following is NOT a PL/SQL programming environment?       
                                                                               
                                               
                SQL Workshop in Application Express

                                               
                Oracle jDeveloper

                                               
                SQL*Plus

                                               
                gSQL*Plus (*)

                                                                               
Which lines of code will correctly display the message "Hello World" ? (Choose two.)      
                                                                               
                                               
                DBMS_OUTPUT('Hello World');

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

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

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


Which of the following statements is true?          
                                                                               
                                               
                None of these are correct.

                                               
                You can embed procedural constructs within SQL code.

                                               
                You can embed SQL statements within PL/SQL code. (*)

                                               
                You can embed PL/SQL statements within SQL code.

                                                                               
                                                               
PL/SQL is an Oracle proprietary, procedural, fourth-generation programming language. True or False?              
                                                                               
                                               
                True

                                               
                False (*)

                                                                               
                                                               
Which of the following statements about PL/SQL and SQL is true?            
                                                                               
                                               
                PL/SQL and SQL are both ANSI-compliant.

                                               
                PL/SQL and SQL are both Oracle proprietary programming languages.

                                               
                PL/SQL allows basic program logic and control flow to be combined with SQL statements. (*)

                                               
                PL/SQL and SQL can be used with many types of databases, including Oracle.

                                                                               
                                                               
Which of the following statements is true?         
                                                                               
                                               
                PL/SQL is an Oracle proprietary, procedural, fourth-generation programming language.

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

                                               
                SQL is an ANSI-compliant, nonprocedural, fourth-generation programming language. (*)

                                               
                PL/SQL is an Oracle proprietary, procedural, third-generation programming language. (*)

                                                                               
                                                               
PL/SQL extends SQL by including all of the following except:        

                                               
                conditional statements

                                               
                constants

                                               
                variables

                                               
                nonprocedural constructs (*)

                                               
                reusable program units

Which of the following statements about exception handling in PL/SQL is false? 
                                                                               
                                               
                Exception handling code tells your program what to do when an error is encountered.

                                               
                You can prepare for application exceptions by creating exception handlers.

                                               
                You can prepare for database exceptions by creating exception handlers.

                                               
                None of these are false (*)

                                               
                All of these are false

                                                                               
                                                               
Which of the following can be done using PL/SQL?          
                                                                               
                                               
                Create custom reports

                                               
                Create complex applications

                                               
                All of these can be done (*)

                                               
                Manage database tasks such as security

                                               
                Retrieve and modify data in Oracle database tables

                                                                               
                                                               
PL/SQL differs from C and Java in which of the following ways? (Choose two.)    
                                                                               
                                                                               
                                               
                It is the most efficient language to use with an Oracle database. (*)

                                               
                It requires an Oracle database or tool. (*)

                                               
                It does not support object-oriented programming.

                                               
                It is the most complex programming language to learn.

                                               
                It is not portable to other operating systems.

                                                                               

Procedural constructs give you better control of your SQL statements and their execution. True or False?    
                                                                               
                                               
                True (*)

                                               
                False

                                                                               
                                                               
Using Oracle Application Express, you can create Web applications that include PL/SQL. True or False?      
                                                                               
                                               
                TRUE (*)

                                               
                FALSE

1 comment:

Final Exam Java Programming 2019 Learner - English

Final Exam