Online Access Free 1z0-148 Practice Test

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

• A.Only DBAs can create or run parallel execution tasks.
• B.Users with CREATE TASK privilege can create or run parallel execution tasks.
• C.To execute chunks in parallel, users must have CREATE JOB system privilege.
• D.DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.
• E.No specific system privileges are required to create or run parallel execution tasks.

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.ENQUOTE_LITERAL (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.QUALIFIED_SQL_NAME (p_ename);
• E.l_sql := 'SELECT empno FROM emp WHERE ename = ''' ||
  SYS.DBMS_ASSERT.QUALIFIED_SQL_NAME (p_ename) || '''';

Which tablespace is used to store the data collected by PL/Scope?

• A.USERS
• B.SYSTEM
• C.TEMP
• D.SYSAUX
• E.UNDOTBS1

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.
Examine this PL/SQL package AS

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

• A.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• B.CREATE FUNCTION totalEmp (sal IN PLS_INTEGER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• C.CREATE FUNCTION totalEmp (sal IN NUMBER) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• D.CREATE FUNCTION totalEmp (sal IN POSITIVEN) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/
• E.CREATE FUNCTION totalEmp (sal IN BINARY_FLOAT) RETURN NUMBER IStotal NUMBER
  :=0;BEGIN...RETUNRN total;END;/

Examine this code:

Examine this query:
SELECT ename, d.dname, job, sal, comm FROM emp e, dept d WHERE d.deptno = e.deptno; Which statement is correct regarding the execution of this SQL query?

• A.The query will only fetch records pertaining to department 30 with SAL and COMM values displayed as NULL.
• B.The query will only fetch records pertaining to department 30 with SAL and COMM displaying the actual data from the table.
• C.The query will only fetch records pertaining to department 30 with SAL and COMM data replaced by
  "xxxxx".
• D.The query will fetch records from all departments with SAL and COMM values displayed as NULL for all records other than department 30.