DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q121
Oracle 8i Here
  • A Interface
  • B Interaction
  • C Internet
  • D none of the above
Answer: Option C
Q122
Locks can be applicable for __________
  • A views
  • B indices
  • C triggers
  • D All of the above
Answer: Option C
Q123
RDMS is based on
  • A Hierarchical model
  • B ) relational
  • C Network
  • D none of these
Answer: Option B
Q124
How does you represent a
  • A Solid line
  • B Dashed line
  • C ellipse
  • D none
Answer: Option B
Q125
which character function is used to return a specified portion of a character string
  • A Initcap
  • B Concat
  • C Substring
  • D Length
Answer: Option C
Q126
Which dictionary view gives the information of the tables of user
  • A All tables
  • B User tables
  • C DBA tables
  • D All the above
Answer: Option B
Q127
What is default length of the CHAR datatype
  • A 256
  • B 122
  • C 1
  • D 64
Answer: Option C
Q128
Which of the following statements from database
  • A set of tables & views
  • B set of clusters
  • C set of synonyms
  • D none of the above
Answer: Option A
Q129
When a user creates an object with out giving table-space then where it will stored
  • A system table-space
  • B Oracle table-space
  • C Oracle Error
  • D Default Table-space
Answer: Option D
Q130
Which character is used to continue the SQL* plus
  • A *
  • B /
  • C +
  • D -
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