Tag: databases

Quizzes (243) Questions (4862)

Questions Related to databases

Multiple choice technology databases

Which two statements are true about the working of fine-grained access? (Choose two.)

  1. Security policies can be associated only with tables, but not with views.

  2. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.

  3. User statements are dynamically modified by the Oracle server through a security policy function.

  4. Fine-grained access control policies always remain in effect until they are dropped from a table or view.
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Full explanation
Multiple choice technology databases

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.)

  1. LAST and COUNT give different values.

  2. LAST and COUNT give the same values.

  3. The four new elements that are added contain the value 33.

  4. The four new elements that are added contain the value 44.
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Full explanation
Multiple choice technology databases

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?

  1. The package executes successfully and passes the required data to the host variable.

  2. The package specification gives an error on compilation because cursor variable types cannot be defined in the specification.

  3. The package specification gives an error on compilation because the cursor variable parameter was specified before you defined it.

  4. The package executes successfully, but does not pass the required data to the host variable because the cursor is closed before the
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation