Passing C2090-616 exam is a first step for you to get the IBM Certified Database Administrator certification. With studying all of DB2 11.1 Fundamentals for LUW C2090-616 exam prep questions dumps, you can test your skills to check if you have a good understanding of the exam topics or not. All the IBM C2090-616 exam prep questions are collected from the real test by our certified experts, who update the C2090-616 questions frequently according to the changes at the testing center.
Which edition of DB2 LUW has been discontinued in v11.1?A . DB2 Developer EditionB . DB2 Express Server EditionC . DB2 Enterprise Server EditionD . DB2 Connect Enterprise Server EditionView AnswerAnswer: B Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.licensing.doc/doc/r0053238.html
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 . RowB . TableC . ScalarD ....
You are asked to provide a recommendation for the appropriate DB2 edition for a new application. The application is characterized by long, complex queries that select a subset of columns and often perform grouping...
Which of the following is TRUE about indexes on column organized tables?A . No indexes are allowedB . Indexes are only allowed on numeric columnsC . Indexes are automatically created to enforce unique constraintsD...
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?A . COMMITB . SAVEPOINTC . ROLLBACK WORKD . UPDATE TERMINATEView AnswerAnswer: C...
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?A . NOT NULLB . Foreign keyC . Primary keyD . Informational constraintView AnswerAnswer:...
What of the following is TRUE about triggers?A . Triggers are activated by INSERT, UPDATE, DELETE and SELECT statementsB . Triggers can be used to perform data manipulation operations against complex viewsC . Triggers...
The following statements are executed: GRANT CREATETAB, DATAACCESS, ON DATABASE TO ROLE role A; GRANT CREATETAB, BINDADD ON DATABASE TO ROLE role B; GRANT ROLE role A to USER db2inst3; GRANT ROLE role B...
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuserA . An error is returnedB . An entry is mane...
Which of the following authorities is sufficient for connecting to a database?A . SQLADMB . CONNECTC . DATAACESSD . ACCESSCTRLView AnswerAnswer: B Explanation:http://www-01.ibm.com/support/docview.wss?uid=swg21427232
