DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q1
What does the abbreviation DBMS stand for?
  • A Database Manipulation Software.
  • B Database Management System.
  • C Data Borrowing and Movement Software.
  • D Digital Base Mapping System.
Answer: Option B
Q2
ORACLE database is comprised of
  • A Data files
  • B Redo Log files
  • C Control files
  • D All the above
Answer: Option D
Q3
The components of Physical database structure of Oracle Database is
  • A Data files
  • B Redo Log files
  • C Control files
  • D Table Space
Answer: Option C
Q4
The components of logical database structure of Oracle Database is
  • A Data files
  • B Data base Schema Objects
  • C Control files
  • D Table Space
Answer: Option B
Q5
A database is divided into Logical Storage Unit called
  • A Data files
  • B Redo Log files
  • C Control files
  • D tablespaces
Answer: Option D
Q6
SYSTEM TABLESPASCE is
  • A Which is automatically created when the database is created
  • B Which is installed with oracle
  • C There is no SYSTEM TABLESPASCE
  • D None of the above
Answer: Option A
Q7
SYSTEM tablespace always contains
  • A The data dictionary tables for the entire database.
  • B The programs
  • C All the redolog and control files
  • D None of the above
Answer: Option A
Q8
The relationship among Database, Tablespace
  • A Both are related to physical database
  • B Both are related to logical database
  • C There is no relation ship at all
  • D Each databases logically divided into one or more tablespaces
Answer: Option D
Q9
The relationship among Tablespace and datafile
  • A Both are related to physical database
  • B Both are related to logical database
  • C There is no relation ship at all
  • D One or more data files are explicitly created for each tablespace.
Answer: Option D
Q10
what is schema
  • A A schema is collection of database objects of a User.
  • B Collection of files
  • C Collection databases
  • D All the above
Answer: Option A

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test