Tag: databases

Questions Related to databases

Which of the following are system privileges? (Choose two)
technology databases

  1. DELETE

  2. SELECT

  3. CREATE TABLE

  4. UPDATE

  5. DROP TABLE

Show answer
Correct Option: C,E

Which of the following data dictionary views displays the objects owned by the user?
technology databases

  1. DICTIONARY

  2. TABLE_PRIVILEGES

  3. ALL_VIEWS

  4. USER_OBJECTS

Show answer
Correct Option: D

Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. What will be the initial value of the variable when the block is executed?
technology databases

  1. 0

  2. NULL

  3. Depends on the scale and precision of the datatype.

  4. Without initialization, a variable cannot be used in the executable section of the block.

Show answer
Correct Option: B

A user executes a PL/SQL block containing complex data with several update and insert statements using multiple row subqueries and complex inline view. Under which of the following conditions will the database save the change after executing one or more PL/SQL blocks? (Choose two)
technology databases

  1. When you disconnect from your session abnormally

  2. After PL/SQL block is executed successfully

  3. When you issue TRUNCATE command at SQL prompt

  4. When COMMIT command is issued

  5. When each UPDATE statement is executed

Show answer
Correct Option: C,D

For an unconditional approach to a particular part of a complex PL/SQL block, which of the following control structures can be used?
technology databases

  1. If-Then-Else

  2. While loop

  3. GOTO

  4. DECODE

Show answer
Correct Option: C

You are declaring a variable of data type NUMBER in a PL/SQL block. During the execution of the PL/SQL block, a query returns seven rows, and the next FETCH statement is issued. If the variable was assigned a value by using %ROWCOUNT attribute, which of the following values will be stored in it?
technology databases

  1. 0

  2. 8

  3. 7

  4. NULL

Show answer
Correct Option: C

Which of the following statements about an SQL statement are not correct? (Choose two)
technology databases

  1. SQL statements can be on one or more lines.

  2. Keywords cannot be split across lines.

  3. SQL statements are not case-sensitive, unless indicated.

  4. Keywords can be abbreviated.

  5. Place a slash on the last line in the buffer.

  6. You can use arithmetic operators in any clause of a SQL statement.

Show answer
Correct Option: C,D

Suppose you have to remove a table. There are several indexes associated with this table. Which among the following would remove all the indexes associated with the table?
technology databases

  1. DROP INDEX

  2. ALTER TABLE ....... DROP PRIMARY KEY CASCADE

  3. ALTER TABLE ....... DROP CONSTRAINT

  4. DROP TABLE

Show answer
Correct Option: D

Which of the following are not legal?
technology databases

  1. DECLARE V_Destination_India Number;

  2. DECLARE V_123, V_213, V_132 Varchar2(10);

  3. DECLARE V_sys Boolean := 1;

  4. DECLARE V_destination_India Number(4);

  5. DECLARE V_Hiredate NOT NULL DATE := '01-JAN-00';

Show answer
Correct Option: B,C,E

Which three of the following methods make PL/SQL tables easier to use? (Choose three)
technology databases

  1. EXISTS

  2. SUBSTR

  3. TRIM

  4. FLOOR

  5. COUNT

  6. UPPER

Show answer
Correct Option: A,C,E