Database Management System Set 48
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
On This Page
This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 48
Q1 | Which of the following is an advantage of a database?
- Reduction in Redundancy
- Avoidance of inconsistency
- Security enforcement
- All of the above
Q2 | Which of the following is an example of a database application?
- Computerized library systems
- ATMs
- Flight reservation systems
- All of the above
Q3 | DBMS stands for________________?
- Data blocking and Management Systems
- Database Management Systems
- Database Business Management Systems
- None of the above
Q4 | What is the name of the system database that contains descriptions of the data in thedatabase?
- Metadata
- Data dictionary
- Table
- None of the above
Q5 | IMS stands for ___________
- Information Management System
- Internal Mechanical Security
- International Managers Society
- None of the above
Q6 | Which of the following is the oldest database model?
- Hierarchical
- Network
- Relational
- Object Oriented
Q7 | Which category of users need not be aware of the presence of the database system?
- DBA
- Naive
- Casual
- Application Programmers
Q8 | Database __________ , which is the logical design of the database, and the database _______,which is a snapshot of the data in the database at a given instant in time.
- Instance, Schema
- Relation, Schema
- Relation, Domain
- Schema, Instance
Q9 | Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________ .
- Relations, Attribute
- Attributes, Relation
- Tuple, Relation
- Tuple, Attributes
Q10 | Department (dept name, building, budget) and Employee (employee_id , name, deptname,salary) Here the dept_name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ___________ relations.
- Attributes of common
- Tuple of common
- Tuple of distinct
- Attributes of distinct
Q11 | A domain is atomic if elements of the domain are considered to be ____________units.
- Different
- Indivisbile
- Constant
- Divisible
Q12 | Which of the following products was an early implementation of the relational modeldeveloped by E.F. Codd of IBM?
- IDMS
- DB2
- dBase-II
- R:base
Q13 | The following are components of a database except ________
- user data
- Metadata
- Reports
- Indexes
Q14 | An application where only one user accesses the database at a given time is an exampleof a(n) ________ .
- single-user database application
- multiuser database application
- e-commerce database application
- data mining database application
Q15 | An on-line commercial site such as Amazon.com is an example of a(n) ________ .
- single-user database application
- multiuser database application
- e-commerce database application
- data mining database application
Q16 | SQL stands for ________ .
- Structured Query Language
- Sequential Query Language
- Structured Question Language
- Sequential Question Language
Q17 | Because it contains a description of its own structure, a database is considered to be ________
- Described
- metadata compatible
- self-describing
- an application program
Q18 | The following are functions of a DBMS except ________ .
- creating and processing forms
- creating databases
- processing data
- administrating databases
Q19 | Helping people keep track of things is the purpose of a(n) ________ .
- Database
- Table
- Instance
- Relationship
Q20 | A DBMS that combines a DBMS and an application generator is ________ .
- Microsoft's SQL Server
- Microsoft's Access
- IBM's DB2
- Oracle Corporation's Oracle
Q21 | Let us consider phone_number ,which can take single or several values . Treating phone_numberasan _________ permits instructors to have several phone numbers (including zero) associated with them.
- Entity
- Attribute
- Relation
- Value
Q22 | Given the basic ER and relational models, which of the following is INCORRECT?
- An attribute of an entity can have more than one value
- An attribute of an entity can be composite
- In a row of a relational table, an attribute can have more than one value
- In a row of a relational table, an attribute can have exactly one value or a NULL value
Q23 | In an object-oriented model, one object can access data of another object by passing:
- Instance variable
- Message
- Variable
- None of these
Q24 | A view of database that appears to an application program is known as:
- Schema
- Subschema
- virtual table
- none of the above
Q25 | An abstraction concept for building composite object from their component object is called:
- Specialization
- Normalization
- Generalization
- Aggregation