PL/SQL Oracle 1z0-144: Actual Exam Practice – COMPLETE SOLUTION
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. - 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? - 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? - A. if-then-endif and if-thenelse 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? - A. Explicit and implicit variables B. Scalar and composite variables C. Primary and default variables D. Scalar and user-defined variables Answer: B
Información del documento
- Subido en
- 4 de septiembre de 2022
- Número de páginas
- 81
- Escrito en
- 2022/2023
- Tipo
- Examen
- Contiene
- Preguntas y respuestas