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)