db2 questions

INSERT INTO QUESTION (XMLQ) VALUES \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID></author> \
    <classification> \
    <topic> DB2 Fundamentals </topic> \
    <subtopic> Query </subtopic></classification> \
    <level> Very Easy </level> \
    <language> English </language> \
    <minutes_allocated> 1 </minutes_allocated> \
    <question_text> Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?</question_text> \
    <answer> \
    <choice1 type="correct"> % </choice1> \
    <choice2> * </choice2> \
    <choice3> ? </choice3> \
    <choice4> / </choice4></answer> \
    <keywords> like, %, *, ?, / </keywords></question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Fundamentals </topic> \
    <subtopic> Query </subtopic> \
    </classification> \
    <level> Easy </level> \
    <language> English </language> \
    <minutes_allocated> 2 </minutes_allocated> \
    <question_text> \
    User USER1 holds CONTROL privilege on table TABLE1. Which two of the following statements is user USER1 allowed to execute? \
    </question_text> \
    <answer> \
    <choice1> GRANT CONTROL ON table1 TO user2 </choice1> \
    <choice2> GRANT LOAD ON table1 TO user2 </choice2> \
    <choice3 type="correct"> GRANT INSERT, UPDATE ON table1 TO user2 WITH GRANT OPTION </choice3> \
    <choice4> GRANT BINDADD ON table1 TO PUBLIC </choice4> \
    </answer> \
    <keywords> control privilege, grant control, grant load, grant binadd, grant insert update </keywords> \
</question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Fundamentals </topic> \
    <subtopic> Configuration </subtopic> \
    </classification> \
    <level> Easy </level> \
    <language> English </language> \
    <minutes_allocated> 2 </minutes_allocated> \
    <question_text> \
    Which authority or privilege is granted by the DB2 Database Manager configuration file? \
    </question_text> \
    <answer> \
    <choice1> CONNECT </choice1> \
    <choice2> CONTROL </choice2> \
    <choice3 type="correct"> SYSMAINT </choice3> \
    <choice4> EXECUTE </choice4> \
    </answer> \
    <keywords> DB2 database manager, sysmaint, connect, control, execute </keywords> \
</question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Fundamentals </topic> \
    <subtopic> Configuration </subtopic> \
    </classification> \
    <level> Easy </level> \
    <language> English </language> \
    <minutes_allocated> 2 </minutes_allocated> \
    <question_text> \
    Which type of key is defined on the child table to implement a referential constraint? \
    </question_text> \
    <answer> \
    <choice1> Unique Key </choice1> \
    <choice2 type="correct"> Foreign Key </choice2> \
    <choice3> Primary Key </choice3> \
    <choice4> Composite Key </choice4> \
    </answer> \
    <keywords> referential constraint, unique key, primary key, foreign key, composite key </keywords> \
    </question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Administration </topic> \
    <subtopic> Security </subtopic> \
    </classification> \
    <level> Easy </level> \
    <language> English </language> \
    <minutes_allocated> 2 </minutes_allocated> \
    <question_text> \
    What is the purpose of Authorities ? \
    </question_text> \
    <answer> \
    <choice1>  Authorities express a set of rights to perform actions executed by the user </choice1> \
    <choice2> To give a set of rights to selected user </choice2> \
    <choice3 type="correct"> Authorities express a set of rights to perform high level Administrative functions </choice3> \
    <choice4> Authorities express a set of rights to perform low level Administrative functions </choice4> \
    </answer> \
    <keywords> Authorities, administrative function </keywords> \
    </question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Administration </topic> \
    <subtopic> privilege </subtopic> \
    </classification> \
    <level> Very Easy </level> \
    <language> English </language> \
    <minutes_allocated> 1 </minutes_allocated> \
    <question_text> \
    What database object which SELECT privilege can not manage? \
    </question_text> \
    <answer> \
    <choice1>  TABLES </choice1> \
    <choice2> NICKNAME </choice2> \
    <choice3> VIEWS </choice3> \
    <choice4 type="correct"> SCHEMA </choice4> \
    </answer> \
    <keywords> select privilege, tables, nickname, schema, views </keywords> \
    </question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Administration </topic> \
    <subtopic> command </subtopic> \
    </classification> \
    <level> Difficult </level> \
    <language> English </language> \
    <minutes_allocated> 3 </minutes_allocated> \
    <question_text> \
    What Get dbm cfg command for? \
    </question_text> \
    <answer> \
    <choice1>  To change the configuration of DB2 Database Manager Configuration file </choice1> \
    <choice2> To view current configuration of DB2 Database Manager Configuration file </choice2> \
    <choice3 type="correct"> To view the parameter values of DB2 Database Manager Configuration file </choice3> \
    <choice4> To update sysmaint_group value of DB2 Database Manager Configuration file </choice4> \
    </answer> \
    <keywords> get dbm cfg, change, view, update </keywords> \
    </question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Design </topic> \
    <subtopic> normalization </subtopic> \
    </classification> \
    <level> Easy </level> \
    <language> English </language> \
    <minutes_allocated> 2 </minutes_allocated> \
    <question_text> \
    Which of the following is not the advantages of Normalization ? \
    </question_text> \
    <answer> \
    <choice1>  reduce the redundancy </choice1> \
    <choice2> avoid null values </choice2> \
    <choice3> avoid update anomalies </choice3> \
    <choice4 type="correct"> easy to produce reports </choice4> \
    </answer> \
    <keywords> normalization, redudancy, null values, update anomalies, produce reports </keywords> \
    </question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Design </topic> \
    <subtopic> identifier </subtopic> \
    </classification> \
    <level> Difficult </level> \
    <language> English </language> \
    <minutes_allocated> 3 </minutes_allocated> \
    <question_text> \
    Which of the following is not the difference between Primary Key and Unique Key ? \
    </question_text> \
    <answer> \
    <choice1>  A unique key can also be a primary key and can involve in joins </choice1> \
    <choice2> A table will contains only one primary key in a table, but can contains more than one unique key </choice2> \
    <choice3 type="correct"> a primary key by default it will create a non clustered index whereas for the unique key by default it will create clustered index </choice3> \
    <choice4> Primary key won’t allow any null value, but unique key allows only one null</choice4> \
    </answer> \
    <keywords> primary key, unique key </keywords> \
</question>'), \
('<question> \
    <author> \
    <user_ID> admin@ibm.com </user_ID> \
    </author> \
    <classification> \
    <topic> DB2 Design </topic> \
    <subtopic> table </subtopic> \
    </classification> \
    <level> Very Easy </level> \
    <language> English </language> \
    <minutes_allocated> 1 </minutes_allocated> \
    <question_text> \
    What is Tuple ? \
    </question_text> \
    <answer> \
    <choice1 type="correct">  Row in a table </choice1> \
    <choice2> Column in a table </choice2> \
    <choice3> number of columns in a table </choice3> \
    <choice4> the name of a table</choice4> \
    </answer> \
    <keywords> tuple, row, column</keywords> \
</question>')