1Z0-146 무료 덤프문제 온라인 액세스

You issue this command to create a table called LOB_STORE:
CREATE TABLE lob_store
(lob_id NUMBER(3),
photo BLOB DEFAULT EMPTY_BLOB(),
cv CLOB DEFAULT NULL,
ext_file BFILE DEFAULT NULL)
/
What is the outcome?

• A.The table is created successfully.
• B.It generates an error because DEFAULT cannot be set to EMPTY_BLOB() during table creation.
• C.It generates an error because DEFAULT cannot be set to null for a CLOB column during table creation.
• D.It generates an error because DEFAULT cannot be set to null for a BFILE column during table creation.

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

• A.They can be used as attributes of a user-defined data type.
• B.They can be stored in a tablespace that is different from the tablespace that stores the table containing the LOB column.
• C.They cannot be passed as parameters to PL/SQL subprograms.
• D.They cannot use redo logging.

The user OE is working on an application that needs to call an external C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Which statement is true about the current session by the OE user?

• A.The session can continue calling the external C program.
• B.The session can call the external C program after republishing it.
• C.The session terminates during the subsequent call to the external C program.
• D.The session receives an error for the next call to the external C program.

You issue the following command to create the PRINT_MEDIA table.
CREATE TABLE print_media
(product_id NUMBER(3),
ad_sourcetext CLOB,
ad_photo BLOB);
Evaluate the following INSERT statements:
INSERT INTO print_media VALUES (1, empty_clob(),empty_blob());
INSERT INTO print_media VALUES (2,'This is a One Line Story',null);
INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob());
INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story'));
Which of the above INSERT statements are valid?

• A.Only the first and fourth statements are valid.
• B.Only the first statement is valid.
• C.All the statements are valid.
• D.Only the first and second statements are valid.
• E.Only the first, second and third statements are valid.

View the Exhibit to examine the PL/SQL code for the GET_METADATA function. Which statement is true about the metadata gathered by the function?

• A.The end result is the creation of DDL for all tables with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
• B.The end result is the creation of DDL for all tables and associated indexes with all instances of the HR schema changed to SCOTT along with all physical, storage, logging, and other segment attributes.
• C.The end result is the creation of DDL for the TIMECARDS table with all instances of the HR
  schema changed to SCOTT.
• D.The end result is the creation of an XML document for all tables with all physical, storage, logging, and other segment attributes.