DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q351
the data dictionary resides in the _____________table space
  • A system
  • B scott
  • C user
  • D mdsys
Answer: Option A
Q352
a data base on relational model developed by
  • A james goosing
  • B kim thomson
  • C codd
  • D berkely
Answer: Option C
Q353
Which of the following statement(s) can be considered as a part of data dictionary?
  • A metadata
  • B The complete set of data records.
  • C data flow diagram of the system
  • D none
Answer: Option A
Q354
The data model in which data is represented by collection of records and relationships among data are represented by links is (are) called?
  • A Hierarchical
  • B Network
  • C Relational
  • D both a & b
Answer: Option D
Q355
a relation ( from relational data model) consists of set of tuples which explains that
  • A all tuples in a relation must be distinct.
  • B relational model supports multi-valued attributes whose values can be represented in
  • C for any two tuples, the values associated with one or more of their attributes must differ.
  • D both a & c
Answer: Option D
Q356
__________ is the implementation specific design details of indexes, files, disks, blocks, etc where the database is actually stored.
  • A logical design
  • B physical design
  • C conceptual design
  • D none
Answer: Option B
Q357
_____________ is the implementation independant list of database objects (tables) that represents the Conceptual model
  • A logical design
  • B physical design
  • C conceptual design
  • D none.
Answer: Option A
Q358
_________ is used to assign a value to a variable.
  • A select
  • B set
  • C assign
  • D none
Answer: Option B
Q359
Which one of the following is NOT a characteristic of metadata?
  • A data about data
  • B self describing
  • C includes user data
  • D none
Answer: Option D
Q360
Which of the following statements is true?
  • A a) The relationship attribute
  • B a) The relationship attribute
  • C a) The relationship attribute
  • D The relationship attribute
Answer: Option B

📚 More from Database

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