Database Management System Objective Type Questions and Answers

Dbms Mock Test | Online mock test for Dbms MCQ | Dbms Free Mock Test | Dbms questions and answers pdf, Dbms Mock Test 2022 ”is being published, which is very useful for upcoming competitive exams.

Photo 1638376522703 compress75
1. Sophisticated report generators can
    (A) Print row-oriented reports
    (B) Perform arithmetic operations
    (C) Selectively retrieve and print portions of a list
    (D) All of the above

2. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
    (A) Record
    (B) Field
    (C) File
    (D) Data base

3. Which of the following is a Data Model?
    (A) Entity-Relationship model
    (B) Relational data model
    (C) Object-Based data model
    (D) All of the above

4. UML is stands for
    (A) Universal Modeling Language
    (B) Unified Modeling Language
    (C) United Modeling Language
    (D) Uni Modeling Language

5. Report generators are used to
    (A) Store data input by a user
    (B) Retrieve information from files
    (C) Answer queries
    (D) Both (b) and (c)

6. In a large DBMS
    (A) Each user can “see” only a small part of the entire database
    (B) Each user can access every sub-schema
    (C) Each subschema contains every field in the logical schema
    (D) All of the above

7. Information can be transferred between the DBMS and a
    (A) Spreadsheet program
    (B) Word processor program
    (C) Graphics program
    (D) All of the above

8. In SQL, which command(s) is(are) used to enable/disable a database trigger?
    (A) Modify User
    (B) Change User
    (C) Alter Trigger
    (D) None of the above

9. Which of the following is a type of DBMS software?
    (A) Database manipulation language
    (B) Query language
    (C) Utilities
    (D) Report writer

10. Snapshot of the data in the database at a given instant of time is called
    (A) Database Schema
    (B) Database Instance
    (C) Database Snapshot
    (D) All of the above

11. A functional dependency between two or more non-key attributes is called
    (A) Transitive dependency
    (B) Partial transitive dependency
    (C) Functional dependency
    (D) Partial functional dependency

12. Sort/report generators
    (A) Are faster than index/report generators
    (B) Require more disk space than index/report generators
    (C) Do not need to sort before generating a report
    (D) Both (a) and (b)

13. Which of the following is not a logical data-base structure?
    (A) Tree
    (B) Relational
    (C) Network
    (D) Chain

14. Which of the following is not an advantage of the data-base approach?
    (A) Elimination of the data redundancy
    (B) Ability to associate related data
    (C) Increased security
    (D) All of the above are advantages

15. The highest level in the hierarchy of data organization is called
    (A) Data bank
    (B) Database
    (C) Data file
    (D) Data record

Show and hide multiple DIV using JavaScript View All Answers

Practice Test: Question Set - 13


1. If the record management system allows you to edit values before they are recorded on disk, you can
    (A) Correct spelling changes before they are recorded
    (B) Change the name of a field
    (C) Change the width of a field
    (D) All of the above

2. Two files may be joined into a third file if
    (A) They have a row in common
    (B) They have a field in common
    (C) They have no records with the same value in the common field
    (D) Both (b) and (c)

3. A list in alphabetical order
    (A) Is in descending order
    (B) Is in ascending order
    (C) Is the result of a sort operation
    (D) Both (b) and (c)

4. A race condition occurs when
    (A) Two concurrent activities interact to cause a processing error
    (B) Two users of the DBMS are interacting with different files at the same time
    (C) Both (a) and (b)
    (D) None of the above

5. Which of the following command(s) is(are) used to recompile a stored procedure in SQL?
    (A) COMPILE PROCEDURE
    (B) ALTER PROCEDURE
    (C) MODIFY PROCEDURE
    (D) None of the above

6. Data items grouped together for storage purposes are called a
    (A) Record
    (B) Title
    (C) List
    (D) String

7. _______ allow us to identify uniquely a tuple in the relation.
    (A) Superkey
    (B) Domain
    (C) Attribute
    (D) Schema

8. If every non-key attribute is functionally dependent on the primary key, the relation will be in
    (A) First Normal Form
    (B) Second Normal Form
    (C) Third Normal Form
    (D) Fourth Formal Form

9. A logical description of some portion of database that is required by a user to perform task is called as
    (A) System View
    (B) User View
    (C) Logical View
    (D) Data View

10. A ________ means that one record in a particular record type is related to only one record of another record type.
    (A) One-to-one relationship
    (B) One-to-many relationship
    (C) Many-to-one relationship
    (D) Many-to-many relationship

11. If you want to organize a file in multiple ways, it is better to ________ the data rather than to sort it.
    (A) Delete
    (B) Update
    (C) Sort Key
    (D) Index

12. Goals for the design of the logical schema include
    (A) Avoiding data inconsistency
    (B) Being able to construct queries easily
    (C) Being able to access data efficiently
    (D) All of the above

13. If you want your database to include methods, you should use a _______ database.
    (A) Network
    (B) Distributed
    (C) Hierarchical
    (D) Object-Oriented

14. In SQL, the CREATE VIEW command is used
    (A) To recompile view
    (B) To define a view of one or more tables or views
    (C) To recompile a table
    (D) To create a trigger

15. Updating a database means
    (A) Revising the file structure
    (B) Reorganizing the database
    (C) Modifying or adding record occurrences
    (D) None of the above

Show and hide multiple DIV using JavaScript View All Answers

search keywords and tags :-

  • dbms multiple choice questions with answers for gate pdf
  • mcq on dbms with answers doc
  • dbms multiple choice questions with answers
  • introduction to database questions and answers pdf
  • advanced dbms mcq questions and answers pdf
  • dbms mcq pdf download
  • introduction to dbms mcq pdf
  • dbms mcq pdf mcq
  • mcq on dbms with answers doc
  • dbms multiple choice questions with answers 50
  • dbms mcq pdf download
  • dbms mcq pdf mcq
  • introduction to dbms mcq pdf
  • advanced dbms mcq questions and answers pdf

Leave a Comment

close