Prev Next Question 17/75 - 1Z0-148.v2018-05-05

Which two are correct when migrating BasicFile LOBs to SecureFile LOBs by DBMS_REDEFINITION?

Comments (The most recent comments are at the top.)

- Apr 22, 2019

Answer : C, E
Table redefinition cannot be done NOLOGGING. --D
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables007.htm#ADMIN11675

- Apr 13, 2019

Correct C,D
You can perform online redefinition at the table or partition level. –A

- Jan 27, 2019

Answer A, C

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (75q)
4 commentQuestion 1: Examine this code: (Exhibit) Which two corrections must be a...
Question 2: Examine the test_tbl table and its contents: (Exhibit) Exami...
3 commentQuestion 3: Examine this code: (Exhibit) What is the correct statement t...
2 commentQuestion 4: Examine this function call: cur_num := DBMS_SQL.TO_CURSOR_NU...
Question 5: Which two can be used to find details of parameters for over...
Question 6: Examine this code executed as SYS: (Exhibit) Examine this co...
1 commentQuestion 7: Examine the structure and data in the CUSTOMERS table: (Exhi...
1 commentQuestion 8: In your schema, the DEPARTMENTS table contains the columns D...
2 commentQuestion 9: Examine this PL/SQL function: (Exhibit) What happens when th...
Question 10: Select a valid reason for using VARRAYS....
Question 11: Examine this code: (Exhibit) Users of this function may set ...
Question 12: Which PRAGMA statement may enable associated PL/SQL function...
1 commentQuestion 13: (Exhibit) Which two statements are correct about the collect...
1 commentQuestion 14: Examine this code: (Exhibit) Which two are valid correlation...
1 commentQuestion 15: In which situation will cached results become invalid?...
3 commentQuestion 16: Which two PL/SQL blocks give the output “this is a test mes...
3 commentQuestion 17: Which two are correct when migrating BasicFile LOBs to Secur...
1 commentQuestion 18: Refer to the Exhibit. (Exhibit) Examine this procedure creat...
1 commentQuestion 19: Examine the code: (Exhibit) Which two subprograms will be cr...
2 commentQuestion 20: Which two statements are true with respect to fine-grained a...
Question 21: Which three statements are correct with reference to intra u...
1 commentQuestion 22: Examine this query executed as SYS and its output: (Exhibit)...
1 commentQuestion 23: You are logged on to the SCOTT schema and the schema has EMP...
2 commentQuestion 24: Which two statements are true regarding edition-based redefi...
Question 25: Which two statements about the PL/SQL hierarchical profiler ...
2 commentQuestion 26: Which three commands can be used to set PL/SQL conditional c...
Question 27: Select the correct statement regarding BEQUEATH CURRENT_USER...
1 commentQuestion 28: Examine this block: (Exhibit) Which two will be correct afte...
Question 29: Which two statements describe actions developers can take to...
2 commentQuestion 30: Examine this Java method in class Employee, loaded into the ...
Question 31: Which two statements are correct in Oracle Database 12c?...
Question 32: Examine this function: (Exhibit) Execute the query: SELECT r...
2 commentQuestion 33: Which two blocks of code execute successfully?...
1 commentQuestion 34: Examine this code (all compiled into schema HR): (Exhibit) E...
2 commentQuestion 35: Examine this code: CREATE TYPE list_typ IS TABLE OF NUMBER; ...
1 commentQuestion 36: You execute this PL/SQL block: (Exhibit) What will be the ou...
1 commentQuestion 37: Examine this code: (Exhibit) The anonymous block fails with:...
2 commentQuestion 38: Examine this declaration section: (Exhibit) Which two execut...
2 commentQuestion 39: You are designing and developing a complex database applicat...
Question 40: Which two statements are true about the DBMS_ LOB package?...
2 commentQuestion 41: Which must be true in order to add RESULT_CACHE to a functio...
1 commentQuestion 42: This result cache is enabled for the database instance. Exam...
Question 43: Examine this external function declaration: (Exhibit) Which ...
2 commentQuestion 44: Which two blocks of code execute successfully?...
1 commentQuestion 45: Your company decided to update its employees’ contact infor...
1 commentQuestion 46: Examine this function header: FUNCTION calc_new_sal (emp_id ...
1 commentQuestion 47: Examine the structure of the DEPT table which exists in both...
1 commentQuestion 48: Examine this code: (Exhibit) The anonymous block fails this ...
3 commentQuestion 49: Examine this block of code used to calculate the price incre...
1 commentQuestion 50: Examine this code: (Exhibit) Examine this DML statement exec...
2 commentQuestion 51: Which statement is correct about DBMS_LOB.SETOPTIONS and DBM...
2 commentQuestion 52: The STUDENTS table with column LAST_NAME of data type VARCHA...
1 commentQuestion 53: Examine this function body: (Exhibit) Which two headers will...
1 commentQuestion 54: You created a PL/SQL function with the RESULT_CACHE clause, ...
Question 55: Identify the two correct scenarios where a function can be o...
1 commentQuestion 56: Examine this code executed in the ORA1 schema: (Exhibit) Exa...
1 commentQuestion 57: A products TABLE exists with a PROD_ID column. Examine this ...
Question 58: Which statement is true about the DBMS_PARALLEL_EXECUTE pack...
1 commentQuestion 59: Examine the EMPLOYEE_IDS table its data: (Exhibit) Examine t...
1 commentQuestion 60: Examine the section of code taken from a PL/SQL program: (Ex...
1 commentQuestion 61: Examine the incomplete code: (Exhibit) Which three lines of ...
Question 62: Which tablespace is used to store the data collected by PL/S...
Question 63: Which statement is true about internal and external LOBs?...
1 commentQuestion 64: Examine the following SQL statement: ALTER SESSION SET PLSQL...
1 commentQuestion 65: You are designing and developing a complex database applicat...
Question 66: Which two statements are correct for collecting data about i...
Question 67: Examine these statements: (Exhibit) Which two corrections wi...
5 commentQuestion 68: Examine the structure of the EMP table: Name Null? Type ----...
1 commentQuestion 69: Examine these program units: (Exhibit) Which two blocks will...
Question 70: Which data dictionary view contains the list of procedures a...
Question 71: Which two statements are true about PL/SQL AOIs for SecureFi...
1 commentQuestion 72: Consider a function totalEmp () which takes a number as an i...
1 commentQuestion 73: The STUDENTS table exists in your schema. Examine the DECLAR...
1 commentQuestion 74: (Exhibit) Examine this code: (Exhibit) You want to display t...
1 commentQuestion 75: Which codes executes successfully?...