1z0-148 Dumps – Pass with 100% Updated (2020) 1z0-148

Demo Questions:

Question: 1

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

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

Answer: B

Reference:
https://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_parallel_ex.htm#ARPLS67331(security
model)

Question: 2

Which two statements are true regarding edition-based redefinition (EBR)?

A. There is no default edition defined in the database.
B. EBR does not let you upgrade the database components of an application while in use.
C. You never use EBR to copy the database objects and redefine the copied objects in isolation.
D. Editions are non-schema objects.
E. When you change an editioned object, all of its dependents remain valid.
F. Tables are not editionable objects.

Answer: E,F

Question: 3

Which two blocks of code execute successfully?

A. DECLARESUBTYPE new_one IS BINARY_INTERGER RANGE 0..9;my_val new_one;BEGINmy_val
:=0;END;
B. DECLARESUBTYPE new_string IS VARCHAR2 (5) NOT NULL;my_str_new_string;BEGINmy_str :=
‘abc’;END;
C. DECLARESUBTYPE new_one IS NUMBER (2, 1);my_val new_one;BEGINmy_val :=12.5;END;
D. DECLARESUBTYPE new_one IS INTEGER RANGE 1..10 NOT NULL;my_val new_one;BEGINmy_val
:=2;END;
E. DECLARESUBTYPE new_one IS NUMBER (1, 0);my_val new_one;BEGINmy_val := -1;END;

Answer: A,D 

Question: 4

Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for
SecureFiles?

A. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
B. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
C. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
D. If a table was not created with compression specified in the store as securefile clause then
DBMS_LOB.SETOPTIONS can be used to enable it later.

Answer: D

Question: 5

You are designing and developing a complex database application built using many dynamic SQL
statements. Which option could expose your code to SQL injection attacks?

A. Using bind variables instead of directly concatenating parameters into dynamic SQL statements
B. Using automated tools to generate code
C. Not validating parameters which are concatenated into dynamic SQL statements
D. Validating parameters before concatenating them into dynamic SQL statements
E. Having excess database privileges

Answer: A 

Related Links : https://www.dumps4download.com/1z0-148-dumps.html