1Z0-144 Multiple Choice Questions And Answers 2022/2023

Which of the following is not one of the benefits of using PL/SQL? A. Ability to declare variables and constants. B. Support for Object-Oriented Programming. C. Capability to develop web applications. D. Mostly OS-independent. E. Tight Integration with SQL. D. You can run PL/SQL applications on any operating system and platform where Oracle Database runs. Which of the following statements about anonymous PL/SQL blocks is true? A. They are compiled only the first time the block is executed in a session. B. They can be embedded in an OCI program. C. They can only make use of bind variables. D. They can be created as either a function or a procedure. E. They can be called from other PL/SQL blocks. B. They can be embedded in an OCI program. You need a small lookup table that will be generated in memory every time a PL/SQL procedure is invoked or a package that declares it is initialized. Which of the following is the proper composite data type to use? Choose one answer: A. Nested Table B. Bulk Collection C. Associative array D. FORALL Array E. VARRAY C. Associative array Which of the following is a valid implicit cursor attribute? A. SQL%OPEN B. SQL%NODATAFOUND C. SQL%ROWTYPE D. SQL%GROUP_COUNT E. SQL%ROWCOUNT E. SQL%ROWCOUNT Other Implicit Cursor Attributes %ISOPEN, %FOUND, %NOTFOUND, Which of the following is a valid reason for deciding to create a subprogram as a function rather than as a procedure? A. It must be callable from SQL statements. B. It must be stored as a named object in the data dictionary. C. It must be callable from both named and anonymous PL/SQL blocks. D. The purpose is to accept one parameter and return multiple values. E. The subprogram will require the use of both IN and OUT parameters. A. It must be callable from SQL statements. All are lexical units except which of the following? A. Comments B. Literals C. Variables D. Identifiers E. Delimiters C. Variables From which of the following programming languages are the features of PL/SQL programming fetched? A. Ada programming B. C programming C. C++ programming D. Java programming A. Ada programming In which of the following can a subprogram NOT be created? A. Inside a package B. Inside a PL/SQL block C. At the schema level D. Inside a trigger D. Inside a trigger In which of the following places is the record variable NOT allowed? A. In a SELECT list. B. In the VALUES clause of an INSERT statement. C. On the right side of the SET clause in an UPDATE statement. D. In the INTO subclause of a RETURNING clause. A. In a SELECT list. What is the maximum size of a trigger? A. 32KB B. 64KB C. 16KB D. 8KB A. 32KB Which of the following events CANNOT cause a trigger to fire? A. DELETE B. INSERT C. UPDATE D. DROP E. SELECT F. CREATE E. SELECT Which of the following is used to map an exception to an error code? A. PRAGMA B. SQLCODE C. EXCEPTION_INIT D. RAISE_APPLICATION_ERROR function C. EXCEPTION_INIT Which of the following procedures of DBMS_SQL supports bulk DML operations? A. BIND_VARIABLE_CHAR B. BIND_VARIABLE_RAW C. BIND_ARRAY D. BIND_VARIABLE C. BIND_ARRAY Which of the following terms is given by developers to PL/SQL 2.x programming? A. White Art B. Blue Art C. Gray Art D. Black Art D. Black Art You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table. Which two statements are correct about the trigger to be created for the above requirement? (Choose two.) A. It can be a before or an after trigger. B. It should be a before trigger. C. It should be a statement-level trigger. D. It should be a row-level trigger. E. It should be an after trigger. D. It should be a row-level trigger. E. It should be an after trigger. What are the two subtypes of the IF conditional statement in PL/SQL? A. If-then-endif and if-then-else B. If-then-else and if-then-elseif C. If-then-else and if-then-elseif-endif D. If-then-else and if-then-elseif-then-else D. If-then-else and if-then-elseif-then-else What are the two variables supported by PL/SQL? A. Explicit and implicit variables B. Scalar and composite variables C. Primary and default variables D. Scalar and user-defined variables B. Scalar and composite variables Oracle supports all of the following types of collections except for which one? A. VARRAYS B. Nested array C. Nested table D. Associative array B. Nested array Which of the following identifiers can include any printable characters, including spaces? A. Quoted identifiers B. Predefined identifiers C. Valid identifiers D. Invalid identifiers A. Quoted identifiers Which of the following types of message output contains a chronological log of errors, initialization parameter settings, and administration operations, and also records values for overwritten control file records? A. RMAN messages B. alert_SID.log C. D. Oracle trace file B. alert_SID.log Which of the following statements is used to insert, update, or delete bulk data? A. FOR Loop statement B. BULK COLLECT INTO statement C. BULK statement D. FORALL statement D. FORALL statement Which of the following exceptions is raised when a user tries to divide a number by zero? A. VALUE_ERROR B. OUT_OF_RANGE C. ZERO_DIVIDE D. SELF_IS_NULL C. ZERO_DIVIDE All of the following can be the causes of raising an exception except for which one? A. A throw statement has executed. B. An asynchronous exception has occurred. C. An abnormal execution condition has been synchronously detected. D. A catch statement has executed. D. A catch statement has executed. Which of the following built-in packages supports dynamic SQL? A. DBMS_SQL B. DBMS_SCHEDULER C. DBMS_MONITOR D. DBMS_CRYPTO A. DBMS_SQL Which of the following is not true about the PL/SQL language? A. It supports embedded SQL statements. B. It has all the features of a modern structured programming language. C. It is a block-structured language. D. Applications developed using PL/SQL are not portable. D. Applications developed using PL/SQL are not portable. Which of the following is not true about the PL/SQL language? A. PL/SQL's general syntax is based on that of ADA and Pascal programming language. B. Apart from Oracle, PL/SQL is available in TimesTen in-memory database and IBM DB2. C. PL/SQL is tightly integrated with SQL. D. It does not offer error checking. D. PLSQL does offer error checking. Which of the following is true about the PL/SQL language? A. PL/SQL provides access to predefined SQL packages. B. PL/SQL provides support for Object-Oriented Programming. C. PL/SQL provides support for Developing Web Applications and Server Pages. D. All of the above. D. PL/SQL provides access to predefined SQL packages, support for Object-Oriented Programming and Developing Web Applications and Server Pages. Which of the following is not true about the declaration section of a PL/SQL block? A. This section starts with the DECLARE keyword. B. It is a mandatory section. C. It defines all variables, cursors, subprograms, and other elements to be used in the program. D. None of the above. B. The declaration section is not a mandatory section. Which of the following is true about the execution section of a PL/SQL block? A. It is enclosed between the keywords BEGIN and END. B. It is a mandatory section. C. It consists of the executable PL/SQL statements. D. All of the above. D. It is a mandatory section of executable PL/SQL statements between the BEGIN and END keywords Which of the following is not true about the execution section of a PL/SQL block? A. It should have more than one executable line of code. B. It may have just a NULL command to indicate that nothing should be executed. C. The statements must always end with a semicolon. D. The section may contain SQL commands, logical control commands, assignment commands, as well as other commands. A. Execution section of PL/SQL block needs at least 1 executable line of code Which of the following is not true about the exception handling section of a PL/SQL block? A. This section starts with the EXCEPTION keyword. B. It is a mandatory section. C. It contains exception(s) that handle errors in the program. D. None of the above. B. The exception section is not a mandatory section. Which of the following is true about comments in PL/SQL? A. Comments are explanatory statements. B. PL/SQL supports both single-line and multi-line comments. C. The PL/SQL single-line comments start with the delimiter -- (double hyphen) and multi-line comments are enclosed by / and /. D. All of the above. D. All of the above. Which of the following is not a PL/SQL unit? A. Table B. Type C. Trigger D. Package A. Table A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library Which of the following is true about data types in PL/SQL? A. Large Object or LOB data types are pointers to large objects that are stored separately from other data items, such as text, graphic images, video clips, and sound waveforms. B. The composite data types have data items that have internal components that can be accessed individually. For example, collections and records. C. References are pointers to other data items. D. All of the above. D. All of the above. Which of the following is true about character data types and subtypes in PL/SQL? A. LONG is a variable-length character string with maximum size of 32,760 bytes. B. ROWID is a physical column identifier, the address of a column in an ordinary table. C. CHAR is a variable-length character string with maximum size of 32,767 bytes. D. NCHAR is a variable-length national character string with maximum size of 32,767 bytes. A. LONG is a variable-length character data of variable length up to 2 gigabytes, or 2^31 -1 bytes Which of the following is true about scalar data types in PL/SQL? A. They hold single values with no internal components. B. Examples of scalar data types are NUMBER, DATE, or BOOLEAN. C. PL/SQL provides subtypes of data types. D. All are true. D. All are true. Which of the following is not true about large object data types and in PL/SQL? A. BFILE is used to store large binary objects in operating system files outside the database. B. BLOB is used to store character data in the database. C. CLOB is used to store large blocks of character data in the database. D. NCLOB is used to store large blocks of NCHAR data in the database. B. A BLOB (binary large object) does not store character data. It is a varying-length binary string that can be up to 2,147,483,647 digits long. What value will be assigned to the variable declared as - counter binary_integer; A. 0 B. 1 C. NULL D. None of the above. C. NULL Consider the following code ---------------------------------------------------------------------- DECLARE -- Global variables num number := 95; BEGIN dbms__line('num: ' || num1); DECLARE -- Local variables num number := 195; BEGIN dbms__line('num: ' || num1); END; END; ---------------------------------------------------------------------- What will happen when the code is executed? A. It won't execute, it has syntax error B. It will print num: 95 num: 195 C. It will print num: 95 num: 95 D. It will print num: 195 num: 195 B. It will print num: 95 num: 195 What is wrong in the following code? ---------------------------------------------------------------------- DECLARE c_id := 1; c_name %type; c_addr ss%type; BEGIN SELECT name, address INTO c_name, c_addr FROM customers WHERE id = c_id; END; ---------------------------------------------------------------------- A. You cannot use the SELECT INTO statement of SQL to assign values to PL/SQL variables. B. The SELECT INTO statement here is wrong. It should be: SELECT c_name, c_address INTO name, addr C. The WHERE statement is wrong. It should be: WHERE id := c_id; D. The variable c_id should be declared as a type-compatible variable as − c_id %type := 1; D. The variable c_id should be declared as a type-compatible variable as − c_id %type := 1; Which of the following is not true about PL/SQL constants and literals? A. A constant holds a value that once declared, does not change in the program. B. The CONSTANT declaration cannot impose the NOT NULL constraint. C. A constant is declared using the CONSTANT keyword. D. A CONSTANT declaration requires an initial value. B. The CONSTANT declaration can impose the NOT NULL constraint. What will be the output of the following code snippet? ------------------------------------------------------------- DECLARE a number (2) := 21; b number (2) := 10; BEGIN IF ( a <= b ) THEN dbms__line(a); END IF; IF ( b >= a ) THEN dbms__line(a); END IF; IF ( a <> b ) THEN dbms__line(b); END IF; END; ------------------------------------------------------------- A. 2 B. 21 C. 10 D. 21, 10 C. 10 The <> operator is the not equals operator and 21 is not equal to 10. What would be printed when the following code is executed? ------------------------------------------------------------- DECLARE x NUMBER; BEGIN x := 5; x := 10; dbms__line(-x); dbms__line(+x); x := -10; dbms__line(-x); dbms__line(+x); END; ------------------------------------------------------------- A. -10, 10, 10, -10 B. 10, -10, 10, -10 C. -10, +10, +10, -10 D. 10, -10, -10, 10 A. -10, 10, 10, -10 To get the server output result and display it into the screen, you need to write − A. set serveroutput on B. set server output on C. set dbmsoutput on D. set dbms output on A. set serveroutput on