Oracle 1Z0-148 Online Practice Questions and Exam Preparation

Oracle 1Z0-148 Online Questions & Answers

• Question 121:

  Examine the EMP table:

  CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10));

  Examine this PL/SQL procedure:

  

  Which is the correct replacement for the assignment to variable l_sql to avoid SQL injection?

  A. l_sql := 'SELECT empno FROM emp WHERE ename = ''' || SYS.DBMS_ASSERT.NOOP (p_ename) || '''';
  B. l_sql := 'SELECT empno FROM emp WHERE ename = ' || SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename);
  C. l_sql := 'SELECT empno FROM emp WHERE ename = ' || SYS.DBMS_ASSERT.SIMPLE_SQL_NAME (p_ename);
  D. l_sql := 'SELECT empno FROM emp WHERE ename = ' || SYS.DBMS_ASSERT.ENQUOTE_LITERAL (p_ename);
  E. l_sql := 'SELECT empno FROM emp WHERE ename = ''' || SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename) || '''';
  D. l_sql := 'SELECT empno FROM emp WHERE ename = ' || SYS.DBMS_ASSERT.ENQUOTE_LITERAL (p_ename);

• Question 122:

  The EMPLOYEES table exists in your schema and has columns LAST_NAME of data type VARCHAR2 and DEPARTMENT_ID of data type NUMBER.

  There are six employees in DEPARTMENT_ID, 20.

  Examine this code:

  

  What will be the outcome on execution?

  A. The execution of this code will fail with an invalid cursor error and not display either output message.
  B. The number of employees will be displayed as six for both output messages.
  C. The number of employees will be displayed as six for the first output message and zero for the second output message.
  D. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.
  D. The number of employees will be displayed as six for the first output message and an invalid cursor error will be thrown instead of displaying the second output message.

• Question 123:

  Examine these statements:

  

  Which two corrections will allow this anonymous block to execute successfully?

  A. Add wk# .NEXT; before the 7thline.
  B. Add i PLS_INTEGER; before the 3rdline.
  C. Add wk#. EXTEND (1); before the 5thline.
  D. Change line #2 to wk# tp_test# := tp_test# (tp_rec# ());
  E. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);
  C. Add wk#. EXTEND (1); before the 5thline.
  E. Replace lines 5 and 6 with wk# (i) := tp_rec# (i, i);

• Question 124:

  Which two statements are correct in Oracle Database 12c?

  A. For native compilation, PLSQL_OPTIMIZE_LEWVEL should be set to 2.
  B. Native compilation is the default compilation method
  C. Native compilation should be used during development.
  D. Natively compiles code is stored in the SYSTEM tablespace.
  E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.
  D. Natively compiles code is stored in the SYSTEM tablespace.
  E. To change a PL/SQL object from interpreted to native code, set the PLSQL_CODE_TYPE to NATIVE and recompile it.

  ---

  Reference: https://www.google.com/url?sa=tandrct=jandq=andesrc=sandsource=webandcd=2andcad=rjaanduact=8andved=0ahUKEwiW9-2j66rYAhUBORQKHaKOAnsQFggtMAEandurl=http%3A%2F%2Fwww.oracle.com%2Ftechnetwork%2Fdatabase% 2Ffeatures%2Fplsql%2Fncomp-faq-087606.htmlandusg=AOvVaw3H2JhdwNaDzp-Jly5-wtTk

• Question 125:

  Which two statements will raise an exception? (Choose two.)

  A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual;
  B. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@my_dblink') FROM dual;
  C. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME (' Emp_Dept_information_table ') FROM dual;
  D. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employee_Department_information_table') FROM dual;
  E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual;
  A. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('"10_Employees"') FROM dual;
  E. SELECT DBMS_ASSERT.SIMPLE_SQL_NAME ('Employees@') FROM dual;

  ---

  Reference: http://psoug.org/reference/dbms_assert.html

• Question 126:

  Which two statements are true about associative arrays and nested tables? (Choose two.)

  A. Only associative arrays can hold an arbitrary number of elements.
  B. Only associative arrays can use numbers and strings for subscripts.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.
  D. Both associative arrays and nested tables can use numbers and strings for subscripts.
  B. Only associative arrays can use numbers and strings for subscripts.
  C. Both associative arrays and nested tables can hold an arbitrary number of elements.

• Question 127:

  Which three statements are correct when using collections? (Choose three.)

  A. Associative arrays may be used when you need to process information of unknown volume.
  B. Nested tables should be used when the index values are non-sequential.
  C. Use associative arrays when you need numeric and string indices.
  D. Varrays should be used when you need to pass the collection as a parameter.
  E. Do not use nested tables when you need to delete elements.
  F. Nested tables may be used when there is no predefined upper bound for index values.
  D. Varrays should be used when you need to pass the collection as a parameter.
  E. Do not use nested tables when you need to delete elements.
  F. Nested tables may be used when there is no predefined upper bound for index values.

  ---

  Reference: https://docs.oracle.com/cd/B14117_01/appdev.101/b10807/05_colls.htm

• Question 128:

  You execute the following command in the user session: SQL> ALTER SESSION SET PLSQL_DEBUG=true; Which statement is true about the effect of the command?

  A. All PL/SQL blocks that are executed subsequently in the session are traced.
  B. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.
  C. Only anonymous PL/SQL blocks that are executed subsequently in the session are traced.
  D. It enables only named PL/SQL blocks that are executed subsequently in the session for tracing.
  B. It enables all PL/SQL blocks that are compiled subsequently in the session for tracing.

• Question 129:

  Which statements are true about temporary LOBs? (Choose all that apply.)

  A. They can be created only for CLOB and NCLOB data.
  B. They can be accessed only by the user who creates them.
  C. They generate more redo information than persistent LOBs.
  D. They exist for the duration of the session in which they are created.
  E. They are stored temporarily in the default tablespace of the user who creates them.
  B. They can be accessed only by the user who creates them.
  D. They exist for the duration of the session in which they are created.

• Question 130:

  Which two blocks of code execute successfully?

  A. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab (1) :=1; END;
  B. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2); BEGIN my_tab(1) :=55; END;
  C. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab. EXTEND (2); my_tab (1) := 55; END;
  D. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type (); my_tab (1) := 55; END;
  E. DECLARE TYPE tab_type IS TABLE OF NUMBER my_tab tab_type := tab_type (2, NULL, 50); BEGIN my_tab.EXTEND (3, 2); END;
  B. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type := tab_type(2); BEGIN my_tab(1) :=55; END;
  D. DECLARE TYPE tab_type IS TABLE OF NUMBER; my_tab tab_type; BEGIN my_tab := tab_type (); my_tab (1) := 55; END;