IBM C2090-616 DB2 11.1 Fundamentals for LUW Online Training
IBM C2090-616 Online Training
The questions for C2090-616 were last updated at Nov 23,2024.
- Exam Code: C2090-616
- Exam Name: DB2 11.1 Fundamentals for LUW
- Certification Provider: IBM
- Latest update: Nov 23,2024
Question #21
What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
RETURN SIN(X)/COS(X)
- A . Row
- B . Table
- C . Scalar
- D . External
Question #22
What of the following is TRUE about triggers?
- A . Triggers are activated by INSERT, UPDATE, DELETE and SELECT statements
- B . Triggers can be used to perform data manipulation operations against complex views
- C . Triggers can only be used to execute logic before or after appropriate SQL statements
- D . Only one trigger for a particular event and activation time can be created for a particular table
Question #23
What is the purpose of a role?
- A . To define exactly what a specific user can and cannot do within a particular database once they have
been authenticated - B . To group a collection of users together so that they can be simultaneously granted and revoked
specific authorities and privileges - C . To group a collection of privileges together so that they can be simultaneously granted to and revoked
from multiple users, groups, or other roles - D . To assign one or more users that need to run local DB2 applications and tools on a particular server to
the DB2ADMNS or the DB2USERS group
Question #24
Which of the following authorities is sufficient for connecting to a database?
- A . SQLADM
- B . CONNECT
- C . DATAACESS
- D . ACCESSCTRL
Question #25
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
- A . DELETE FROM t1
- B . DELETE* FROM t1
- C . DELETE* TABLE t1
- D . TRUNCATE TABLE t1 IMMEDIATE
- E . TRUNCATE TABLE t1
Latest C2090-616 Dumps Valid Version with 63 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
Subscribe
Login
0 Comments
