Page: 1
/ 10
Total 145 questions
Which statement about triggers is true?
- A. A trigger is designed to return specific types of values and contains executable code.
- B. A trigger is designed to return specific types of values but contains no executable code.
- C. A trigger performs actions to capture details about an activity like a join operation against multiple tables.
- D. A trigger performs actionsin response to an event like an INSERT, UPDATE or DELETE operation on a table.
Answer : D
If a table named MY_TAB contains 100 rows and the following statement is executed:
What will happen?
- A. The last 5 rows in the table will be deleted.
- B. The first 5 rows in the table will be deleted.
- C. The statement will fail because a subquery cannot be used with a DELETE statement.
- D. The statement will fail because a table name was not specified with the DELETE statement.
Answer : A
You have a business need to query DB2 10 and DB2 9 databases and you want to write an application that can run on most platforms unchanged. Which interface would you use to achieve your goal?
- A. CLI
- B. XML
- C. JDBC
- D. RUBY
Answer : C
What are two valid objects that can be created in DB2?(Choose two.)
- A. Tree
- B. Node
- C. Trigger
- D. Contexts
- E. Sequence
Answer : C,E
When is an INTENT EXCLUSIVE (IX) lock required?
- A. When atransaction intends to read or change data.
- B. When a transaction intends to change but not read data.
- C. When a transaction intends to read but not change data.
- D. When a transaction intends to change the system catalog.
Answer : A
By default, a column defined as a TIMESTAMP includes which attributes?
- A. No fractional digits or time zone.
- B. 6 fractional digits and no timezone.
- C. 12 fractional digits plus a time zone.
- D. 12 fractional digits and no time zone.
Answer : B
Which function can be used to obtain values from XML documents that are to be inserted into one or more tables?
- A. XMLTABLE
- B. XMLPARSE
- C. XMLEXISTS
- D. XMLATTRIBUTES
Answer : A
Which SQL statement should be used to select the minimum and maximum salaries
(SALARY), by job code (JOB), from a table EMPLOYEE?
- A. SELECTjob, MIN(salary), MAX(salary) FROM employee GROUP BY job;
- B. SELECT job, MIN(salary), MAX(salary) FROM employee ORDER BY job;
- C. SELECT job, MIN(salary), MAX(salary) FROM employee GROUP BY job, MIN(salary), MAX(salary);
- D. SELECT JOB, MIN(salary),MAX(salary) FROM employee ORDER BY job, MIN(salary), MAX(salary);
Answer : A
Which statement will prevent concurrent application processes from performing anything other than read-only operationsagainst a table named TAB1?
A. LOCK TABLE tab1 IN READ MODE -
B. LOCK TABLE tab1 IN SHARE MODE
C. LOCK TABLE tab1 IN EXCLUSIVE MODE
D. LOCK TABLE tab1 IN READ-ONLY MODE
Answer : B Topic 2, Volume B
What are INSTEAD OF triggers used for?
- A. To update data in other tables.
- B. To perform insert, update, and delete operations against complex views.
- C. To check or modify values before they are actually stored in a database.
- D. To run non-database operations that are coded in user-defined functions.
Answer : B
What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?
- A. Trigger
- B. Procedure
- C. Table function
- D. Scalar function
Answer : A
Which SQL statement would be used to retrieve only salaries that are greater than
$100,000.00 from a table named EMPLOYEE?
- A. SELECT * FROM employee WHERE salary < 100000
- B. SELECT salary FROM employee WHERE salary > 100000
- C. SELECT salary FROM employee WHERE salary >100,000.00
- D. SELECT * FROM employee WHERE salary GREATER THAN 100000
Answer : B
If no isolation level is specified, what is the default isolation level used?
- A. Cursor Stability (CS)
- B. Repeatable Read (RR)
- C. Read Stability(RS) with Currently Committed semantics
- D. Cursor Stability (CS) with Currently Committed semantics
Answer : A
Which statement about UPDATE processing is FALSE?
- A. The UPDATE statement logs the before and after value of every column it modifies.
- B. A searched UPDATE is used to update one or more rows and a positioned UPDATE is used to update exactly one row.
- C. When the UPDATE statement modifies parent key columns, the value of corresponding foreign key columns are also modified.
- D. The UPDATE statement modifies the values of specified columns in the rows of a table, view, or underlying table(s) of a specified fullselect.
Answer : C
User USER1 wants to define arequired relationship between two tables named TAB1 and
TAB2 in such a way that whenever a record is deleted from table TAB1, any related records are deleted from table TAB2. What must user USER1 do to accomplish this?
- A. 1) Create a primary key on tableTAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE CASCADE rule.
- B. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE CASCADE rule.
- C. 1) Create a primary key on table TAB1; 2) Create a foreign key on table TAB2 that references the primary key on table TAB1 and adheres to the ON DELETE RESTRICT rule.
- D. 1) Create a primary key on table TAB2; 2) Create a foreign key on table TAB1 that references the primary key on table TAB2 and adheres to the ON DELETE RESTRICT rule.
Answer : A