Database-Oracle [3i Infotech Placement]: Sample Questions 69 - 70 of 132

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 69

Oracle

Question

MCQ▾

Which of the following is not correct about User_Defined Exceptions?

Choices

Choice (4)

a.

Raised automatically in response to an Oracle error

b.

Must be declared

c.

Must be raised explicitly

d.

Question does not provide sufficient data or is vague

Answer

a.

Explanation

Define User Define Exception
  • That is specifically associated with the program.
  • Must be declared which effectively creates them.
  • Must be raised within context of the program.
  • Handle in the same manner a system generated exception.
  • Raised using the oracle supplied RAISE_APPLICATION_ERROR stored procedure.

3 Steps to Handle the User Exception

  • Define Exception
    • Define the exception before we raise and handle.
  • Raise Exception
    • Ones exceptions are defined, they need to be raised anywhere in the body.
    • Raised using the keyword RAISE
  • Handle the exception
    • The same way predefined exceptions are handled.
3 Steps to Handle the User Exception

Question 70

Oracle
Edit

Statement

True-False▾

Data dictionary can span across multiple Tablespaces

Answer

FALSE

Explanation

  • Data dictionary cannot span multiple Tablespaces
  • The most important parts oracle database is its data directory
  • The data directory is a read-only set of table providing information about database

Data Directory Contains

  • The definition of all objects in the database.
  • Default values for columns
  • Integrity constrain information
  • Privileges and roles each user granted
  • The data dictionary is structured in tables and views, like other database data.
  • All data directory table and view for a database that is store system tablespace.
  • SQL statement to access the data directory.

Tablespace

  • A table space is a logical group of data files in a database.
  • Indicate the database storage location, not the logical database structure or schema
  • Using table space admin can control the disk layout of an installation.
  • DB contains at least one table space and usually two or more.
  • Database program automatically create a table space- SYSTEM.
  • A table space is made one or more data files.

Developed by: