dbms-mcqs - Set (6)

Correct Answer: Orange && Worng Answer: Red

1. Which is not the relational Algebra operators

  • (A). Set Difference
  • (B). Cartesian Product
  • (C). Rename
  • (D). Join
    • View Answer

    Explanation: Not Avilable

    2. How is specialization denoted in ER diagram ?

  • (A). Triangle labeled IS A
  • (B). Rectangle labeled IS A
  • (C). Rectangle labeled HAS A
  • (D). Triangle labeled HAS A
    • View Answer

    Explanation: Not Avilable

    3. Which of the following is open source DBMS ?

  • (A). MySQL
  • (B). SQL Server
  • (C). Microsoft Access
  • (D). Oracle
    • View Answer

    Explanation: Not Avilable

    4. Which SQL keyword is used to remove the duplication of rows from the result set?

  • (A). DELETE
  • (B). SELECT
  • (C). DISTINCT
  • (D). UNIQUE
    • View Answer

    Explanation: Not Avilable

    5. What is the highest level in a hierarchy of data organisation

  • (A). Data Record
  • (B). Data File
  • (C). Data Base
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    6. Which of the following is known as minimal super key

  • (A). Primary Key
  • (B). Foreign Key
  • (C). Unique Key
  • (D). Candidate Key
    • View Answer

    Explanation: Not Avilable

    7. Which command allow the users to change multiple data fields ?

  • (A). Modify
  • (B). Look Up
  • (C). Update
  • (D). Change
    • View Answer

    Explanation: Not Avilable

    8. Which of the following language is used to define the integrity constraint

  • (A). DCL
  • (B). DML
  • (C). DDL
  • (D). All of these
    • View Answer

    Explanation: Not Avilable

    9. In an ER diagram Attributes are represented as :

  • (A). Rectangle
  • (B). Square
  • (C). Ellipse
  • (D). Triangle
    • View Answer

    Explanation: Not Avilable

    10. Architecture of database can be Viewed as

  • (A). Two levels
  • (B). Four levels
  • (C). Three levels
  • (D). One level
    • View Answer

    Explanation: Not Avilable

    11. In relational model, relations are termed as

  • (A). Tuples
  • (B). Attributes
  • (C). Table
  • (D). Rows
    • View Answer

    Explanation: Not Avilable

    12. A cartesian product in relational algebra is

  • (A). Unary Operator
  • (B). Binary Operator
  • (C). Ternary Operator
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    13. SQL stands for –

  • (A). Structured Query language
  • (B). Sequential Query language
  • (C). Structured Question language
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    14. The following are component of a database except

  • (A). User Data
  • (B). Meta Data
  • (C). Reports
  • (D). Indexes
    • View Answer

    Explanation: Not Avilable

    15. A set of possible data values is ?

  • (A). Attributes
  • (B). Degree
  • (C). Tuple
  • (D). Domain
    • View Answer

    Explanation: Not Avilable

    16. Which of the following data base object does not physically exist?

  • (A). Base table
  • (B). Index
  • (C). View
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    17. Cross product is a

  • (A). Unary operator
  • (B). Ternary operator
  • (C). Binary operator
  • (D). None of these
    • View Answer

    Explanation: Not Avilable

    18. In ER diagram relationship is represented by

  • (A). Ellipse
  • (B). Dashed line
  • (C). Rectangle
  • (D). Diamond
    • View Answer

    Explanation: Not Avilable

    19. To delete a particular column in a relation the command used is ?

  • (A). UPDATE
  • (B). DROP
  • (C). ALTER
  • (D). DELETE
    • View Answer

    Explanation: Not Avilable

    20. A table joined with itself is called

  • (A). Join
  • (B). Self join
  • (C). Quter join
  • (D). Equi join
    • View Answer

    Explanation: Not Avilable

    Categories

    C Programming MCQsC++ Programming MCQsJAVA MCQsVisual Basic MCQsData Structure MCQsSoftware Package MCQsComputer Organization and Architecture MCQsOperating System MCQsDigital Electronics MCQsDBMS MCQsSystem Analysis and Management Information System MCQsSystem Maintenance MCQsData Communication and Networking MCQsInternet & Web Technology MCQsSoftware Engineering MCQsManagement (Common) MCQsSystem Software MCQsComputer Graphics MCQsArtificial Intelligence & Expert System MCQsE-Commerce MCQsMultimedia MCQsPower Electronics MCQsTesting & Maintenance Electrical Machine MCQsAutomatic Control System MCQsAdvance Communication System MCQsDigital Electronics MCQs