Oracle 1z0-148 問題集

質問 1：
Which statement is true about internal and external LOBs?
A. An external LOB can be loaded into an internal LOB variable using the DBMS_LOB package.
B. A NOEXIST_DIRECTORY exception can be raised when using internal and external LOBs.
C. When using DBMS_LOB.INSTR for internal and external LOBs, DBMS_LOB.OPEN should be called for each LOB.
D. Internal and external LOBs can be written using DBMS_LOB.
E. After an exception transfers program control outside a PL/SQL block, all references to open external LOBs are lost.
正解：C,E

質問 2：
Which three statements are true about varrays in a database table column? (Choose three.)
A. The data in a single element of a varray can be changed through either PL/SQL or SQL.
B. A varray may be stored outside the table segment in which it is defined but still in the same tablespace.
C. A varray used as a column in a database table must be initialized to empty.
D. The data in a single element of a varray can only be changed through PL/SQL.
E. A varray's size can be increased beyond the maximum number of elements specified in the definition.
F. A varray is always stored in the same segment as the table in which it is defined.
G. A varray's size can be both increased and decreased from the maximum number of elements specified in the definition.
H. A varray used as a column in a database table must be initialized to null.
正解：A,B,G

質問 3：
Which two blocks of code execute successfully?
A. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type := tab_type(2);BEGINmy_tab(1)
:=55;END;
B. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab (1) :=1;END;
C. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab := tab_type ();my_tab (1) := 55;END;
D. DECLARETYPE tab_type IS TABLE OF NUMBER;my_tab tab_type;BEGINmy_tab. EXTEND (2);my_tab (1) := 55;END;
E. DECLARETYPE tab_type IS TABLE OF NUMBERmy_tab tab_type := tab_type (2, NULL,
50);BEGINmy_tab.EXTEND (3, 2);END;
正解：A,C

質問 4：
Which statement is correct about DBMS_LOB.SETOPTIONS and DBMS_LOB.GETOPTIONS for SecureFiles?
A. DBMS_LOB.SETOPTIONS can perform operations on individual SecureFiles but not an entire column.
B. DBMS_LOB.GETOPTIONS can only be used for BLOB data types.
C. 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.
D. DBMS_LOB. SETOPTIONS can set option types COMPRESS, DUPLICATE, and ENCRYPT.
正解：C

質問 5：
You are designing and developing a complex database application and implementing fine-grained access control using security policies.
Which statement is true with respect to attaching security policies to database objects?
A. You implement security policies through database procedures.
B. You can use different security policies for SELECT, INSERT, UPDATE, INDEX and DELETE statements.
C. You can use only one security policy per database object.
D. Column-masking policies can be applied to SELECT, INSERT, UPDATE and DELETE statements.
正解：D

質問 6：
Which two are correct when migrating BasicFile LOBs to SecureFile LOBs by DBMS_REDEFINITION?
A. Specify only BasicFiles LOB and SecureFiles LOB column names in parameter col_mapping of DBMS_REDEFINITION.START_REDEF_TABLE.
B. Set the database initialization parameter db_securefile to NEVER.
C. Online redefinition is the recommended method for migration of BasicFile LOBs to Secure LOBs.
D. During migration, specify the NOLOGGING storage parameter for any new SecureFiles LOB columns.
E. Online redefinition can be done only at the table level.
正解：A,C