Database Management System (DBMS) GATE Questions and Answers pdf - Set 13 - ObjectiveBooks

Database Management System (DBMS) GATE Questions and Answers pdf - Set 13

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?
    (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

 Next Tests:

    Blogger Comment
    Facebook Comment