Database Management System Questions and Answers for GATE - Set 07 - ObjectiveBooks
Database Management System Questions and Answers for GATE - Set 07

Database Management System Questions and Answers for GATE - Set 07

Practice Test: Question Set - 07

1. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
    (A) Oracle
    (B) SQL
    (C) 4GL
    (D) None of the above
2. A computer file can be best described as
    (A) A single data item
    (B) A general collection of data items
    (C) An orderly collection of data items
    (D) A random collection of data items
3. The data dictionary tells the DBMS
    (A) What files are in the database
    (B) What attribute are possessed by the data
    (C) What these files contain
    (D) All of the above
4. A form defines
    (A) Where data is placed on the screen
    (B) The width of each field
    (C) Both (a) and (b)
    (D) None of the above
5. Which command is used to select distinct subject (SUB) from the table (BOOK)?
    (A) SELECT ALL FROM BOOK
    (B) SELECT DISTINCT SUB FROM BOOK
    (C) SELECT SUB FROM BOOK
    (D) None of the above
6. One approach to standardizing storing of data
    (A) MIS
    (B) Structured programming
    (C) CODASYL specifications
    (D) All of the above
7. Queries to a database
    (A) Are written in English
    (B) Can use aggregate functions like SUM and COUNT
    (C) Both (a) and (b)
    (D) None of the above
8. Internal auditors should review data system design before they are
    (A) Developed
    (B) Implemented
    (C) Modified
    (D) All of the above
9. The language used in application programs to request data from the DBMS is referred to as the
    (A) DML
    (B) DDL
    (C) Query language
    (D) All of the above
10. Which of the following is not the responsibility of the utilities component of DBMS software?
    (A) Creating the physical and logical designs
    (B) Removing flagged records for deletion
    (C) Creating and maintaining the data dictionary
    (D) Monitoring performance
11. It is more accurate to define a _______ as a variety of different record types that are treated as a single unit
    (A) Database
    (B) Table
    (C) Record
    (D) Flat File
12. Disadvantages of File systems to store data is:
    (A) Data redundancy and inconsistency
    (B) Difficulty in accessing data
    (C) Data isolation
    (D) All of the above
13. Column header is refer as
    (A) Table
    (B) Relation
    (C) Attributes
    (D) Domain
14. Which of the following is Relation algebra Operation?
    (A) Select
    (B) Union
    (C) Rename
    (D) All of the above
15. Which of the following is not an Aggregate function?
    (A) Min
    (B) Max
    (C) Select
    (D) Avg
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: