0

databases Online Quiz - 64

Description: databases Online Quiz - 64
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

Which two describe a stored procedure?

  1. A stored procedure is typically written in SQL.

  2. A stored procedure is a named PL/SQL block that can accept parameters.

  3. A stored procedure is a type of PL/SQL subprogram that performs an action.

  4. A stored procedure has three parts: the specification, the body, and the exception handler part.

  5. The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.


Correct Option: B,C
  1. Cursor table

  2. Table filter

  3. Dynamic procedure

  4. View

  5. Summary table


Correct Option: D
  1. OS requirement

  2. User analysis

  3. Performance monitoring

  4. Data dictionary specification

  5. System requirement


Correct Option: C
  1. Structure

  2. Design issue

  3. Data source

  4. Storage issue

  5. Operational process


Correct Option: B
  1. Data about data

  2. Describes a data dictionary

  3. Self-describing

  4. Includes user data

  5. Supports its own structure


Correct Option: D

Referring to the scenario above, what clause or command do you use in the query to help avoid a costly tablescan?

  1. GROUP BY clause

  2. INDEX command

  3. HAVING clause

  4. FROM clause

  5. WHERE clause


Correct Option: B
  1. Place the alias at the beginning of the statement to describe the table.

  2. Place the alias after each column, separated by white space, to describe the column

  3. Place the alias after each column, separated by a comma, to describe the column.

  4. Place the alias at the end of the statement to describe the table.

  5. Place the alias at the end of where clause to describe each table


Correct Option: B
  1. Remote DBMS

  2. Relative DBMS

  3. Relational DBMS

  4. Reliable DBMS


Correct Option: C

Indicate whether this statement is true or false. The domain of a column containing the month number of the date of birth of employees differs from the domain of a column with the day number of that date.

  1. True

  2. False


Correct Option: A

Indicate whether this statement is true or false.A view is an alternative method to store data.

  1. True

  2. False


Correct Option: A

Indicate whether this statement is true or false. A trigger can be used instead of a foreign key to implement referential integrity.

  1. True

  2. False


Correct Option: A
  1. Indexes

  2. Public synonyms

  3. Triggers

  4. Packages


Correct Option: B

RAISE_APPLICATION_ERROR is a built-in procedure in oracle which is used to display the user-defined error messages along with the error number. What is the range of the error number for user defined error messages:

  1. Between -20000 and -20999

  2. Between -200000 and -209999

  3. Between -20001 and -20999

  4. Between -200001 and -209999


Correct Option: A
- Hide questions