DB2 Quiz 1-10

• • Q1 - Which of the following is valid in the case of Query?
  • A - PRICE NOT > 500.00
  • B - PRICE = > 500.00
  • C - NOT PRICE > 500.00
  • D - None of the above
  • Answer : C - NOT PRICE > 500.00
  View Answer
• • Q2 - After successful precompilation
  • A - DBRM and Modified source code files are created
  • B - DBRM and PLAN are created
  • C - DBRM and Load module are created
  • D - PLAN and Load module created
  • Answer : C - DBRM and Load module are created
  View Answer
• • Q3 - How would you find out the total number of rows in a table?
  • A - Use SELECT SUM(*) ...
  • B - Use SELECT COUNT(*) ...
  • C - Use SELECT TOTAL(*) ...
  • D - Use SELECT COUNT(TOTAL) ...
  • Answer : B - Use SELECT COUNT(*) ...
  View Answer
• • Q4 - A set of volumes which hold the databases in which tables are stored is called______ .
  • A - Database
  • B - Tablespace
  • C - Storage group
  • D - Tables
  • Answer : C - Storage group
  View Answer
• • Q5 - Bind component Produces:
  • A - Only Package
  • B - Only Application Plan
  • C - All of above
  • D - None of above
  • Answer : B - Only Application Plan
  View Answer
• • Q6 - How do you eliminate duplicate values in SELECT?
  • A - Use SELECT DISTINCT ...
  • B - Use SELECT UNIQUE ...
  • C - Use SELECT ALL UNIQUE ...
  • D - None of above
  • Answer : A - Use SELECT DISTINCT ...
  View Answer
• • Q7 - Can you use MAX on a CHAR column?
  • A - Yes
  • B - No
  • Answer : A - Yes
  View Answer
• • Q8 - DB2 Directory cannot be accessed by SQL statements.
  • A - True
  • B - False
  • Answer : A - True
  View Answer
• • Q9 - The statement "SELECT SALARY + BONUS + 1 SALARY FROM TABLE1;" is correct.
  • A - True
  • B - False
  • Answer : A - True
  View Answer
• • Q10 - If there is no authority to execute the PLAN the error is at
  • A - Bind time
  • B - Recompile time
  • C - Runtime
  • D - Spufi
  • Answer : A - Bind time
  View Answer