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

ADVANCE RDBMS Solved MCQ 2020-21

BCA 5 semester | HNBGU

Read Also:

• PHP programming Solved MCQ 2020-21
• Compiler Design Solved MCQ 2020-21U
• Software Project Management Solved MCQ 2020-21
• Artificial Intelligence Solved MCQ 2020-21
• C Sharp Solved MCQ 2020-21
• Advance RDBMS Solved MCQ 2020-21

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:

• PHP programming Solved MCQ 2020-21
• Compiler Design Solved MCQ 2020-21U
• Software Project Management Solved MCQ 2020-21
• Artificial Intelligence Solved MCQ 2020-21
• C Sharp Solved MCQ 2020-21
• Advance RDBMS Solved MCQ 2020-21