ADVANCE RDBMS Solved MCQ 2020-21 | BCA 5 semester | HNBGU

Admin - April 17, 2021

ADVANCE RDBMS Solved MCQ 2020-21

BCA 5 semester | HNBGU

hnbgu bca solved mcq papar

Read Also:

  1. A relational algebra operation annotated with instructions on how to evaluate it is called_______
    1. Evaluation algebra
    2. Evaluation plan
    3. Evaluation primitive
    4. Evaluation engine


  2. A sequence of primitive operations that can be used to evaluate a query are called as_______.
    1. Query evaluation algebra
    2. Query evaluation plan
    3. Query evaluation primitive
    4. Query evaluation engine


  3. The lowest level operator to access data in query processing is_______
    1. File scan
    2. File manipulation
    3. File handling
    4. File organization


  4. Search algorithms that use an index are referred to as_______
    1. Index scans
    2. Search scans
    3. Primary scans
    4. Equality scans


  5. Sorting of relations that do not fit in memory is called as_______
    1. Internal sorting
    2. External sorting
    3. Overflow sorting
    4. Overload sorting


  6. A relational database consists of a collection of:
    1. Tables
    2. Fields
    3. Records
    4. Keys


  7. A_______ in a table represents a relationship among a set of values.
    1. Column
    2. Key
    3. Row
    4. Entry


  8. The relational model is concerned with :
    1. Data structure and Data integrity
    2. Data manipulation
    3. Both (A) and (B)
    4. None of the above


  9. Which key provides the basic tuple-level addressing mechanism in a relational System ?
    1. Candidate Key
    2. Alternative Key
    3. Primary Key
    4. None of the above


  10. The union of Primary keys of the related entity sets becomes a_______ of the relation.
    1. Super Key
    2. Candidate Key
    3. Foreign Key
    4. Primary Key


  11. A host language is :
    1. Query Language
    2. Storage Definition Language
    3. DML embedded in the general purpose language
    4. None of the above


  12. A primary key :
    1. is also referred to as a composite key
    2. is a unique identifier in a column
    3. uniquely identities the data in row
    4. must be accompanied by a corresponding foreign key


  13. Duplicate data is referred to as:
    1. accurate data
    2. redundant data
    3. storage data
    4. None of the above


  14. A relation in third normal form is:
    1. in first normal form also
    2. in second normal form also
    3. from transitive dependencies
    4. All of the above


  15. Which command is used to remove all rows from a table ?
    1. Delete
    2. Remove
    3. Truncate
    4. Both (A) and (B)


  16. What is the language used by most of the DBMS for helping their users to access data ?
    1. High level language
    2. Query language
    3. SQL
    4. 4GL


  17. A command that lets you change one or more fields in a record is :
    1. Insert
    2. Modify
    3. Look-up
    4. All of the above


  18. The modify operation is likely to be done after:
    1. Delete
    2. Look-up
    3. Insert
    4. None of the above


  19. Which of the following is an aggregate function in SQL.?
    1. Union
    2. Like
    3. Group
    4. Min


  20. Which one of these is an aggregate function in SQL ?
    1. AVG
    2. SELECT
    3. ORDER BY
    4. None of the above


  21. Transactions are Initiated by BEGIN TRANSACTION and terminated:
    1. by COMMIT TRANSACTION
    2. by ROLL BACK TRANSACTION
    3. either by COMMIT TRANSACTION or by ROLL BACK TRANSACTION
    4. None of the above


  22. iterative execution of a statement block :
    1. IF statement
    2. WHILE statement
    3. BREAK statement
    4. None of the above


  23. The statement in SQL which allows changing the definition of a table is:
    1. Alter
    2. Update
    3. Create
    4. Select


  24. E-R model uses this symbol to represent a weak entity set:
    1. Dotted rectangle
    2. Diamond
    3. Doubly outlined rectangle
    4. Nọne of the above


  25. _______ produces the relation that has attributes of R1 and R2.
    1. Cartesian product
    2. Difference
    3. Intersection
    4. Product


  26. It is better to use files than a DBMS when there are :
    1. Stringent real-time requirements
    2. Multiple users wish to access the data
    3. Complex relationships among data
    4. All of the above


  27. What is a relationship called when it is maintained between two entities ?
    1. Unary
    2. Binary
    3. Ternary
    4. Quaternary


  28. Which of the following is a valid SQL type?
    1. CHARACTER
    2. NUMERIC
    3. FLOAT
    4. All of the above


  29. The RDBMS terminology for a row is:
    1. tuple
    2. relation
    3. attribute
    4. degree


  30. Which database level is closest to the users ?
    1. External
    2. Internal
    3. Physical
    4. Conceptual


  31. Which of the following is a comparison operator in SQL ?
    1. =
    2. LIKE
    3. BETWEEN
    4. All of the above


  32. NULL is :
    1. the same as 0 for integer
    2. the same as blank for character
    3. the same as 0 for integer and blank for character
    4. not a value


  33. A primary key is combined with a foreign key creates :
    1. Parent-Child relationship between the tables that connect them.
    2. Many many relationships to between the tables that connect them.
    3. Network model between the tables that connect them.
    4. None of the above


  34. In E-R Diagram relationship type is represented by:
    1. Ellipse
    2. Dashed ellipse
    3. Rectangle
    4. Diamond


  35. To delete a particular column in a relation the command used is:
    1. UPDATE
    2. DROP
    3. ALTER
    4. DELETE

Read Also:

Tags: