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