DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q321
an RDBMS is_____________
  • A an approach intended to readily deal with many to many relationships
  • B an approach which logicaly views data as a collection of tables.
  • C an approach based on relational algebra
  • D both b & c
Answer: Option C
Q322
an RDBMS is_____________
  • A an approach intended to readily deal with many to many relationships
  • B an approach which logicaly views data as a collection of tables.
  • C an approach based on relational algebra
  • D both b & c
Answer: Option D
Q323
a two dimensional structure with data is called_____
  • A set
  • B tables
  • C group
  • D spread sheet
Answer: Option B
Q324
object types are used to create
  • A new data type
  • B data base object
  • C schema
  • D meta data
Answer: Option A
Q325
Which of the following statement(s) is (are) true with respect to data types?
  • A INTEGER data type can store decimal numbers exceeding that number 32,767.
  • B VARCHAR data type often reduces disk storage wastage when compared to CHAR data type.
  • C BLOB data is streams of bytes of fixed length.
  • D BYTE data type cannot store any type of binary data.
Answer: Option B
Q326
CLOB datatype accomodates character information upto
  • A 8 GB
  • B 2 GB
  • C 2000 bytes
  • D 4 GB
Answer: Option D
Q327
The characteristics of the database are
  • A Can be sharable
  • B related logically
  • C can be protected
  • D all the above
Answer: Option D
Q328
The functionalities of the RDBMS are
  • A Store data
  • B execute transactions
  • C Security
  • D all the above
Answer: Option D
Q329
Consider the relation R with four attributes A,B,C and D and the functional dependencies (A,B) (C,D) and C D . Which of the following statements is/are correct?
  • A ) C is a key for relation R.
  • B R is in 3NF
  • C Functional dependency C D violates 3NF
  • D ) R is in BCNF.
Answer: Option C
Q330
Consider the following relation and its sample data. (Consider that these are the only tuples for the given relation) EmpNo DeptNo ProjNo 1001 01 12 1001 01 13 1002 01 12 1003 01 14 Which of the following statements is/are correct?
  • A The functional dependency (EmpNo, DeptNo) ProjNo holds over R.
  • B The functional dependency DeptNo ProjNo holds over R.
  • C The functional dependency EmpNo DeptNo holds over R.
  • D The functional dependency ProjNo DeptNo do not holds over R.
Answer: Option C

📚 More from Database

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