Database-Oracle [PCS Infotech Placement]: Sample Questions 1 - 2 of 2

Get unlimited access to the best preparation resource for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 1

Oracle
Edit

Statement

True-False▾

Tablespace contains physical data.

Answer

TRUE

Explanation

  • Tablespace provides independence of logical data structures such as tables, views, and indexes from physical storage structures.
  • The files in a tablespace usually share common logical characteristic.
  • Tablespaces can be created, deleted, and merged.
  • Both are physical and logical structures are separate.
  • We can manage physical storage of data without affecting logical structure.
  • Data file is created by database and contains data structure like table and index.
  • Data written to files in oracle proprietary format cannot be read by other program.

Database Can Use Tablespace To

  • Control disk space allocation for database data.
  • Specific space for database user.
  • Control availability of data through individual tablespaces.
  • Perform partial database backup or recovery operations.
  • Allocate data storage across devices to improve performance.

Question 2

Oracle
Edit

Statement

True-False▾

ROWID is a pseudocolumn of every oracle table

Answer

FALSE

Explanation

  • ROWID pseudocolumn returns the address of the row - A ROWID value uniquely identifies a row within a cluster.
  • Behaves like a table column, is not actually stored in the table.
  • Row numbers and row descriptions automatically stored and is directly accessible.
  • Information in pseudocolumn can be received in queries.
  • Rows in different tables that are stored together in the same cluster the same rowid.
  • Provides quick access to a row- fastest possible access to a row of a given table.

Developed by: