DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q11
Can a Tablespace hold objects from different Schemes
  • A yes
  • B no
  • C can
  • D none
Answer: Option A
Q12
Can objects of the same Schema reside in different tablespaces
  • A yes
  • B no
  • C can
  • D none
Answer: Option A
Q13
Does the Schema objects directly refer to the database's data?
  • A yes
  • B no
  • C can
  • D none
Answer: Option A
Q14
Schema objects include i)tables ii)views iii)sequences iv)synonyms v)indexes
  • A i) , ii) only
  • B i) and iv) and v) only
  • C i),ii) and iii) only
  • D i),ii), iii), iv) and v)
Answer: Option D
Q15
Which generates a serial list of unique numbers for numerical columns of a database's tables
  • A Sequence
  • B Synonym
  • C Degree
  • D Order
Answer: Option A
Q16
Alias for a table, view, sequence or program unit is
  • A Sequence
  • B Synonym
  • C Degree
  • D Order
Answer: Option B
Q17
What are the type of Synonyms i) Public ii) Private iii) Constant
  • A i) only
  • B ii) only
  • C i) and ii)
  • D none
Answer: Option C
Q18
public synonym
  • A can be accessed only by the owner on the database
  • B can be accessed by any user on the database
  • C can be accessed only by the DBA
  • D none
Answer: Option B
Q19
Private Synonym
  • A can be accessed only by the owner on the database
  • B can be accessed by any user on the database
  • C can be accessed only by the DBA
  • D none
Answer: Option A
Q20
What are the types of Database Links
  • A Private Database Link
  • B Public Database Link
  • C Network database Link.
  • D All the above
Answer: Option D

📚 More from Database

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