Database-Oracle [3i Infotech Placement]: Sample Questions 81 - 82 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 81

Oracle
Edit

Statement

True-False▾

Multiple Tablespaces can share a single datafile

Answer

FALSE

Explanation

Understanding of Data Storage with Table Space
  • Tablespaces can however be split across multiple files- improve concurrency of multiple sort operation- reduce and avoid oracle database space management operation.
  • Tablespace can be assigned to users with the create user or alter user statement and shared by multiple users.

When a database has multiple tablespaces:

  • Separate user data from data dictionary data to reduce I/O contention.
  • Store the datafiles of different tablespaces on different disk drives to reduce I/O contention.
  • Take individual tablespaces offline while others remain online, providing better availability.
  • Back up individual tablespaces.

Advantages of multiple tablespace for a single application:

  • Deciding the space allocation of each tablespace
  • Managing what is created in which tablespace
  • Multiple tablespaces of similar size, promote parallelization.

Question 82

Oracle

Question

MCQ▾

GET_BLOCK property is a

Choices

Choice (4)

a.

Library function

b.

Restricted procedure

c.

Unrestricted procedure

d.

None of the above

Answer

d.

Explanation

Define Query Info a Runtime
  • GET_BLOCK property returns information of a specific block
  • Must issue a call to the built-in once for all property value to retrieve.

Syntax

FUNCTION GET_BLOCK_PROPERTY

(block_id Block, Property NUMBER) ;

FUNCTION GET_BLOCK_PROPERTY

(block_name VARCHAR2,

property NUMBER) ;

Where,

block_id: The unique ID from builder assigned to the block during creation.

block_name: The name block during creation.

Property: Specifies various constants to return information about given block.

Developed by: