DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q231
A _____________is a data repository along with a user interface providing for the manipulation and administration of a database.
  • A DBMS
  • B TBMS
  • C SDMs
  • D Nothing
Answer: Option A
Q232
A specific example where physical data independence would hold is when data file is changed from an unordered file to a sorted file. when an additional access structure, (e.g. an index) is created for a relation. when DBA decides to store the data in a B+ tree. when the user retrieves data from the database. when the user writes an application program to join tables.
  • A i,ii and iii
  • B I,ii,ii and iv
  • C iv and v
  • D none
Answer: Option A
Q233
A relation (from the relational database model) consists of a set of tuples, which implies that
  • A relational model supports multi-valued attributes whose values can be represented in sets
  • B for any two tuples, the values associated with all of their attributes may be the same.
  • C for any two tuples, the values associated with one or more of their attributes must differ.
  • D all tuples in a particular relation may have different attributes.
Answer: Option C
Q234
If K is a foreign key in relation R1, then
  • A every tuple of R1 has a distinct value for K.
  • B K cannot have a null value for tuples in R1
  • C K is a key for some other relation
  • D K is a composite key for R1.
Answer: Option C
Q235
Practitioners and Users are involved with database systems. Which of the statements below is/are true regarding them?
  • A Systems Designer is a user
  • B Departmental Heads are users.
  • C Information Systems Manager is a user.
  • D Clerical staff are practitioners.
Answer: Option A
Q236
Which of the following statements is a/are characteristic(s) of
  • A a,b and c
  • B a,c and e
  • C a,b,c and e
  • D a,b,c,d and e
Answer: Option B
Q237
Components of a DBMS includes
  • A a user query and reporting facility
  • B a database access sub system
  • C a security and integrity sub system
  • D All the above
Answer: Option D
Q238
The blanks of the following three statements have to be filled. The (i) level provides the physical view of the database. The (ii) level gives a user oriented description of the data elements and relationships. The (iii) level provides all users information needs and definition of data items needs to meet them. Which of the following will correctly fill the blanks?
  • A (i) conceptual (ii) external (iii) internal
  • B (i) internal (ii) external (iii) conceptual
  • C (i) external (ii) conceptual (iii) internal
  • D (i) internal (ii) conceptual (iii) external
Answer: Option B
Q239
Protecting a database from unauthorized or malicious use is termed
  • A data integrity.
  • B concurrent processing.
  • C data security.
  • D data recovery.
Answer: Option A
Q240
Which of the following closely resemble(s) an
  • A A large health care Organization that operates a group of hospitals.
  • B A software development team maintaining a list of software components.
  • C A student
  • D A salesman
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