databases Online Quiz - 67
|Description: databases Online Quiz - 67|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
If an application issues the same query more than once in the same unit of work,which isolation level will not permit this application to see additional rows inserted by other application?
Which of the following DB objects is executable using SQL?
Which of the following resources can be explicitly locked?
Which two statements correctly describe the features of SecureFiles? (Choose two.)
DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object. You create a table using the following command: CREATE TABLE clob_tab(col2 CLOB); View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error. What correction must be done to ensure the PL/SQL block executes successfully?
Examine the structure of the LOB_STORE table. Name Null? Type ---------------- -------- ------------ LOB_ID NUMBER VIDEO_CLIP BLOB You create a 'DATA_FILES' directory object that contains the 'IMAGE1.GIF'operating system (OS) file. View the Exhibit and examine the LOAD_LOB procedure code that you execute for reading data from the OS file into the BLOB column. It is created with compilation errors. What is the reason?
Examine the code in the following PL/SQL block: DECLARE TYPE NumList IS TABLE OF INTEGER; List1 NumList := NumList(11,22,33,44); BEGIN List1.DELETE(2); DBMS_OUTPUT.PUT_LINE ( 'The last element# in List1 is ' || List1.LAST || ' and total of elements is '||List1.COUNT); List1.EXTEND(4,3); END; / Which two statements are true about the above code? (Choose two.)
Examine the structure of the DEPARTMENTS table. Name Null? Type ----------------------------- ------------ ---------- DEPARTMENT_ID NOT NULL NUMBER(4) DEPARTMENT_NAME NOT NULL VARCHAR2(30) LOCATION_ID NUMBER(4) View the Exhibit and examine the code that you plan to use for creating a package to obtain the details of an employee using a host variable on the client side. In SQL*Plus, you plan to use the following commands: SQL> VARIABLE x REFCURSOR SQL> EXECUTE emp_data.get_emp(195,:x) SQL> PRINT x Which statement is true about the above scenario?
Which two types of query results cannot be stored in the query result cache? (Choose two.)
Which index is best suited in case of a table having redundant data
Which Command will bounce the database, that is shut down and start the database in one command