Database Management System (DBMS) Solved MCQs - Set 05 - ObjectiveBooks
Database Management System (DBMS) Solved MCQs - Set 05

Database Management System (DBMS) Solved MCQs - Set 05

Practice Test: Question Set - 05

1. In SQL, which command is used to add new rows to a table?
    (A) ALTER TABLE
    (B) ADD ROW
    (C) INSERT
    (D) APPEND
2. Which command is used to remove an index from the database in SQL?
    (A) DELETE INDEX
    (B) DROP INDEX
    (C) REMOVE INDEX
    (D) ROLL BACK INDEX
3. A _______ means that one record in a particular record type can be related to many records in another record type and vice-versa.
    (A) One-to-one relationship
    (B) One-to-many relationship
    (C) Many-to-one relationship
    (D) Many-to-many relationship
4. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
    (A) Full media
    (B) Graphics media
    (C) Multimedia
    (D) Hypertext
5. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
    (A) ZIP
    (B) PACK
    (C) COMMIT
    (D) SAVE
6. In the DBM approach, application programs perform the
    (A) Storage function
    (B) Processing functions
    (C) Access control
    (D) None of the above
7. The _________ command is used to allocates an extent for the table in SQL
    (A) MODIFY ALLOCATES
    (B) MODIFY TABLE
    (C) ALTER TABLE
    (D) REDEFINE TABLE
8. The designer of a form includes
    (A) Filed designators
    (B) Prompts
    (C) Data
    (D) Both (a) and (b)
9. An-owner-member set in the CODASYL specifications may have
    (A) Only one owner but many owner occurrences
    (B) Only one member but many member occurrence
    (C) More than one member but only one occurrence per member
    (D) All of the above
10. In SQL, which command is used to create a database user?
    (A) ADD USER TO DATABASE
    (B) MK USER
    (C) CREATE USER
    (D) All of the above
11. Which of the following is not a level of data abstraction?
    (A) Physical Level
    (B) Critical Level
    (C) Logical Level
    (D) View Level
12. Which of the following is Database Language?
    (A) Data Definition Language
    (B) Data Manipulation Language
    (C) Query Language
    (D) All of the above
13. In mathematical term Table is referred as
    (A) Relation
    (B) Attribute
    (C) Tuple
    (D) Domain
14. Which of the following in not Outer join?
    (A) Left outer join
    (B) Right outer join
    (C) Full outer join
    (D) All of the above
15. Which of the following is not binary operation?
    (A) Union
    (B) Project
    (C) Set Difference
    (D) Cartesian Product
Show and hide multiple DIV using JavaScript View All Answers
 Next Tests: