MCQS Database Systems- for educator job IT – Set 8

By: Prof. Fazal Rehman Shamil
Last modified on September 23rd, 2020

MCQS Database Systems- for educator job IT – Set 8

Multiple Choice Questions

Set 8

  • What is the compassion operator in the  SQL
  1. ==
  2. +
  3. ++
  4. AND or OR
    Answer - Click Here:
    1
  • In which type of operator Venn diagram are possible to be used____
  1. Relation operator
  2. Comparison operator
  3. Xor or AND operator
  4. Boolean
    Answer - Click Here:
    1
  • What is possible output of the query SELECT PRODUCT FROM PRODUCT WHERE STANDARD PRICE>199 AND STANDARD_PRICE<301_______
  1. Coffee table 980 , computer desk 350
  2. Coffee table 400 , computer desk 150
  3. Coffee table 900 , computer desk 250
  4. Coffee table 200 , computer desk 250
    Answer - Click Here:
    4
  • Which type of table are not possible to maintain____
  1. Virtual table
  2. Real data
  3. Real table
  4. Virtual data
    Answer - Click Here:
    1
  • The single value returned by the previous aggregate function is called______
  1. Vector aggregate
  2. Query aggregate
  3. Scalar aggregate
  4. Qualifier aggregate
    Answer - Click Here:
    3
  • What is the purpose of the primary key_____
  1. To show uniqueness of the row/column
  2. To show same things of the row/column
  3. To show contract between and same attributes.
  4. Both a and b
    Answer - Click Here:
    4
  • Application moved from machine to machine when each machine uses SQL
  1. Application portability
  2. Application longevity
  3. Application productivity
  4. Application reduced training cost
    Answer - Click Here:
    1
  • Different DBMS and application programs can more easily communicate and cooprate in managing data and processing user programs are called___
  1. Reduced dependence
  2. Cross system communication
  3. Productivity
  4. Professionalism
    Answer - Click Here:
    1
  • A large pool of IS professional trained in a common language reduce retraining when hiring new employs ______
  1. Reduced training cost
  2. Productivity
  3. Longevity
  4. System communication
    Answer - Click Here:
    1
  • What is FIPS stand for______
  1. Fundamental information processing standard
  2. Fetch information processing standard
  3. Federal information processing standard
  4. French information processing standard
    Answer - Click Here:
    3
  5. More MCQs Of Database Systems

    1. SET 1: database design mcqs (database design mcqs )
    2. SET 2: database mcqs with answers pdf (database mcqs with answers pdf )
    3. SET 3: modern database management 12th edition mcqs (modern database management 12th edition mcqs)
    4. SET 4: database systems mcqs (database systems mcqs)
    5. SET 5: dbms mcqs (dbms mcqs )
    6. SET 6: dbms mcqs with answers (dbms mcqs with answers)
    7. SET 7: solved mcqs of dbms (solved mcqs of dbms)
    8. SET 8: dbms mcqs with answers pdf(dbms mcqs with answers pdf)
    9. SET 9: relational database management system mcqs(relational database management system mcqs)
    10. SET 10: solved mcqs of database management system(solved mcqs of database management system)
    11. SET 11: basic database mcqs pdf (basic database mcqs pdf)
    12. SET 12: relational database management system mcqs (relational database management system mcqs )
    13. SET 13: database mcqs online test (database mcqs online test)
    14. SET 14: database interview questions mcqs (database interview questions mcqs)
    15. SET 15: database developer mcqs (database developer mcqs)
    16. SET 16: database Repeated mcqs (database Repeated mcqs)
    17. SET 17: Database mcqs PPSC (Database mcqs PPSC)
    18. SET 18: Database mcqs FPSC (Database mcqs FPSC)
    19. SET 19: DBMS mcqs FPSC (DBMS mcqs FPSC)

Computer Science Repeated MCQs Book Download

Prof. Fazal Rehman Shamil
Latest posts by Prof. Fazal Rehman Shamil (see all)