Tag: databases

Questions Related to databases

To use a FETCH staement with a cursor you always have to supply an explicit direction such next or prior.

technology databases

  1. TRUE

  2. FALSE

  3. BOTH

  4. NONE

Show answer
Correct Option: B

Which of the following is non-PL/SQL variable?
technology databases

  1. Scalar

  2. LOB

  3. Reference

  4. host

Show answer
Correct Option: D

PL/SQL does not support boolean variables
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which four are valid Oracle constraint types?
technology databases

  1. CASCADE

  2. UNIQUE

  3. NONUNIQUE

  4. CHECK

  5. PRIMARY KEY

  6. NOT NULL

Show answer
Correct Option: B,D,E,F

Which is an iSQL*PLUS command?
technology databases

  1. INSERT

  2. UPDATE

  3. SELECT

  4. DESCRIBE

  5. DELETE

  6. RENAME

Show answer
Correct Option: D

Top N analysis requires _____ and ______?(Choose two)
technology databases

  1. the use of rowed

  2. a GROUP BY clause

  3. an ORDER BY clause

  4. only an inline view

  5. an inline view and an outer query

Show answer
Correct Option: C,E

Which constraint can be defined only at the column level?
technology databases

  1. UNIQUE

  2. NOT NULL

  3. CHECK

  4. PRIMARY KEY

  5. FOREIGN KEY

Show answer
Correct Option: B

What does the FORCE option for creating a view do?
technology databases

  1. creates a view with constraints

  2. creates a view even if the underlying parent table has constraints

  3. creates a view in another schema even if you don't have privileges

  4. creates a view regardless of whether or not the base tables exist

Show answer
Correct Option: D

The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this?
technology databases

  1. GRANT select ON dept TO ALL USERS;

  2. GRANT select ON dept TO ALL;

  3. GRANT QUERY ON dept TO ALL USERS;

  4. GRANT select ON dept TO PUBLIC;

Show answer
Correct Option: D
Explanation:

To solve this question, the user needs to know the SQL syntax for granting privileges to users and the difference between "ALL USERS" and "PUBLIC".

Now, let's go through each option and explain why it is right or wrong:

A. GRANT select ON dept TO ALL USERS; This option is incorrect because the correct keyword to grant privileges to all users is "PUBLIC" instead of "ALL USERS". Also, "QUERY" is not a valid keyword, and the correct keyword to grant query privileges is "SELECT". Therefore, option A is incorrect.

B. GRANT select ON dept TO ALL; This option is incorrect because the correct keyword to grant query privileges is "SELECT" instead of "QUERY". Also, "ALL" is not a valid keyword to grant privileges to all users, and the correct keyword is "PUBLIC". Therefore, option B is incorrect.

C. GRANT QUERY ON dept TO ALL USERS; This option is incorrect because "QUERY" is not a valid keyword to grant privileges, and the correct keyword is "SELECT". Also, "ALL USERS" is not a valid keyword to grant privileges to all users, and the correct keyword is "PUBLIC". Therefore, option C is incorrect.

D. GRANT select ON dept TO PUBLIC; This option is correct. The correct keyword to grant select (query) privileges is "SELECT". The keyword "PUBLIC" is used to grant privileges to all users. Therefore, option D is the correct answer.

The Answer is: D

Which three are true?(Choose three)

technology databases

  1. A MERGE statement is used to merge the data of one table with data from another

  2. A MERGE statement replaces the data of one table with that of another

  3. A MERGE statement can be used to insert new rows into a table

  4. A MERGE statement can be used to update existing rows in a table

Show answer
Correct Option: A,B,C