QUESTION 17 Which four triggering events can cause a trigger to fire? (Choose four) short 1. A specific error or any errors occurs. 2. A database is shut down or started up. 3. A specific user or any user logs on or off. 4. A user executes a CREATE or an ALTER table statement. 5. A user executes a SELECT statement with an ORDER BY clause. 6. A user executes a JOIN statement that uses four or more tables. (A)1234(B)2345(C)1245(D)3456

QUESTION 14 There is a CUSTOMER table in a schema that has a public synonym CUSTOMER and you are granted all object privileges on it. You have a procedure PROCESS_CUSTOMER that processes customer information that is in the public synonym CUSTOMER table. You have just created a new table called CUSTOMER within your schema. Which statement is true? (A) Creating the table has no effect and procedure PROCESS_CUSTOMER still accesses data from public synonym CUSTOMER table. (B) If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER is invalidated and gives compilation errors. (C) If the structure of your CUSTOMER table is entirely different from the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles and accesses your CUSTOMER table. (D) If the structure of your CUSTOMER table is the same as the public synonym CUSTOMER table then the procedure PROCESS_CUSTOMER successfully recompiles when invoked and accesses your CUSTOMER table.

其他試題