MCQ Questions on Database Management System with Answers - Set 12 - ObjectiveBooks
MCQ Questions on Database Management System with Answers - Set 12

MCQ Questions on Database Management System with Answers - Set 12

Practice Test: Question Set - 12

1. What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
    (A) Special purpose packages
    (B) Custom made programs
    (C) Single function application packages
    (D) Data management packages
2. A number of related records that are treated as a unit is called
    (A) File
    (B) Field
    (C) Data
    (D) Batch
3. A _______ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
    (A) Network
    (B) Hierarchical
    (C) Relational
    (D) Object-Oriented
4. Which two files are used during operation of the DBMS?
    (A) Query language and utilities
    (B) Data manipulation language and query language
    (C) Data dictionary and transaction log
    (D) Data dictionary and query language
5. In SQL, which command(s) is(are) used to create a synonym for a schema object?
    (A) CREATE SCHEMA
    (B) CREATE SYNONYM
    (C) CREATE SAME
    (D) None of the above
6. Periodically adding, changing and deleting file records is called file
    (A) Updating
    (B) Upgrading
    (C) Restructuring
    (D) Renewing
7. In a _______ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
    (A) Network database
    (B) Relational database
    (C) Distributed database
    (D) Hierarchical database
8. In mathematical term Row is referred as
    (A) Relation
    (B) Attribute
    (C) Tuple
    (D) Domain
9. Which of the following is not Unary operation?
    (A) Select
    (B) Project
    (C) Rename
    (D) Union
10. ODBC stands for _________
    (A) Offline database connection
    (B) Oriented database connection
    (C) Open database connection
    (D) None of above
11. A transaction completes its execution is said to be
    (A) Saved
    (B) Loaded
    (C) Rolled
    (D) Committed
12. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
    (A) Tables
    (B) Relations
    (C) Tuple
    (D) Both (a) and (b)
13. In SQL, which of the following is not a data definition language commands?
    (A) RENAME
    (B) REVOKE
    (C) GRANT
    (D) UPDATE
14. A _________ DBMS distributes data processing tasks between the workstation and a network server.
    (A) Network
    (B) Relational
    (C) Client Server
    (D) Hierarchical
15. Long-range planning report produced in an MIS are primarily designed for
    (A) Top management
    (B) Middle management
    (C) Lower management
    (D) None of the above
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: