• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 4 fuera de 82 páginas
Examen

PL/SQL Oracle 1z0-144: Practice Exam 2022 with complete solution. RATED A+

Document preview thumbnail
Vista previa 4 fuera de 82 páginas

PL/SQL Oracle 1z0-144: Practice Exam 2022 with complete solution. RATED A+ Document Content and Description Below You work as a Database Administrator for Hitech Inc. The company uses Oracle as its database. The database contains a table named Employee, which in turn have a view named ename. There is some issue with the ename view. As a DBA, you need to repair and compile the view. You issue the ALTER view ename COMPILE statement, however, the compilation failed. Which of the following will you use to accomplish the task? Each correct answer represents a part of the solution. Choose two. - ANSWER-A. The SHOW ERROR command B. The DESC command C. The DBA_OBJECTS view D. The DBA_DEPENDENCIES view Answer: B,D One of the users creates the following PL/SQL object. What type of PL/SQL object is this considered as? - ANSWER-A. A package body B. A trigger C. A type specification D. A package specification Answer: D QUESTION NO: 1 What are the two subtypes of the IF conditional statement in PL/SQL? - ANSWER-A. if-then-endif and if-then-else B. if-then-else and if-then-elseif C. if-then-else and if-then-elseif-endifD. if-then-else and if-then-elseif-then-else Answer: D QUESTION NO: 2 What are the two variables supported by PL/SQL? - ANSWER-A. Explicit and implicit variables B. Scalar and composite variables C. Primary and default variables D. Scalar and user-defined variables Answer: BQUESTION NO: 3 Oracle supports all of the following types of collections except for which one? - ANSWER-A. VARRAYS B. Nested array C. Nested table D. Associative array Answer: B QUESTION NO: 4 Which of the following identifiers can include any printable characters, including spaces? - ANSWER-A. Quoted identifiers B. Predefined identifiers C. Valid identifiers D. Invalid identifiers Answer: A QUESTION NO: 5 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? - ANSWER-A. RMAN messages B. alert_SID.log C. D. Oracle trace file Answer: B QUESTION NO: 6 Which of the following statements is used to insert, update, or delete bulk data? - ANSWER-A. FOR Loop statement B. BULK COLLECT INTO statementC. BULK statement D. FORALL statement Answer: D QUESTION NO: 7 Which of the following exceptions is raised when a user tries to divide a number by zero? - ANSWER-A. VALUE_ERROR B. OUT_OF_RANGE C. ZERO_DIVIDE D. SELF_IS_NULL Answer: C QUESTION NO: 8 All of the following can be the causes of raising an exception except for which one? - ANSWER-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. Answer: D QUESTION NO: 9 Which of the following built-in packages supports dynamic SQL? - ANSWER-A. DBMS_SQL B. DBMS_SCHEDULER C. DBMS_MONITOR D. DBMS_CRYPTO Answer: A QUESTION NO: 10 From which of the following programming languages are the features of PL/SQL programming fetched? - ANSWER-A. C++ programmingB. Java programming C. C programming D. Ada programming Answer: D QUESTION NO: 11 Which of the following is ideal for querying a database table or view? - ANSWER-A. Range FOR Loop statement B. Cursor FOR Loop statement C. While Loop statement D. Simple Loop statement Answer: B QUESTION NO: 12 Which of the following errors maps to the INVALID_CURSOR predefined exception in PL/SQL? - ANSWER-A. ORA-10100 B. ORA-10001 C. ORA-01000 D. ORA-01001 Answer: D QUESTION NO: 13 Which of the following is a sequentially control statement? - ANSWER-A. GOTO B. LOOP C. EXIT D. CASE Answer: A QUESTION NO: 14Which of the following cannot be created and stored in the database? - ANSWER-A. NESTED TABLE B. VARRAY C. RECORD D. ASSOCIATIVE ARRAY Answer: C QUESTION NO: 15 In which of the following naming methods are the connect identifiers stored in a localized configuration file named ? - ANSWER-A. Oracle Names B. Directory naming C. Local naming D. External naming E. Host naming Answer: C QUESTION NO: 16 Which of the following correctly represents floating point number literals? - ANSWER-A. F6.34 B. 6.34 C. 6.F34 D. 6.34F Answer: D QUESTION NO: 17 Which of the following clauses indicates that a function is cached only once in the SGA and is available across sessions? - ANSWER-A. PIPELINED B. PARALLEL_ENABLE C. RESULT_CACHE D. DETERMINISTIC Answer: CQUESTION NO: 18 Which of the following is another name for bind variable? - ANSWER-A. User-defined variable B. System variable C. Session-level variable D. Default variable Answer: C QUESTION NO: 19 Which of the following exceptions is raised when the value of amount plus the offset exceeds the maximum size of LOB allowed by the database? - ANSWER-A. Procedure B. Function C. Cursor D. Access Answer: D QUESTION NO: 20 Which of the following terms is used for the declaration section of the named-block programs? - ANSWER-A. Wrapper B. Header C. Declarer D. Cursor Answer: B QUESTION NO: 21 All of the following statements about a named system exception are true except for which one? - ANSWER-A. These exceptions are caught by referencing the standard name within an exceptionhandling routine. B. These exceptions are declared explicitly. C. These exceptions are raised when a predefined Oracle error occurs.D. NO_DATA_FOUND is an example of a named system exception. Answer: B QUESTION NO: 22 All of the following statements are true about an explicit cursor except for which one? A. An explicit cursor can be declared in any declaration section of a PL/SQL block. - ANSWER-B. A cursor name is not a PL/SQL variable. C. The name of an explicit cursor can be up to 30 characters in length. D. Values can be assigned to a cursor. Answer: D Show


Información del documento

Subido en
4 de junio de 2023
Número de páginas
82
Escrito en
2022/2023
Tipo
Examen
Contiene
Preguntas y respuestas
$11.99

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
Savior
3.6
(24)
Vendido
97
Seguidores
70
Artículos
3383
Última venta
6 días hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes

Ups! No podemos cargar tu documento ahora. Inténtalo de nuevo o contacta con soporte.