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 of the following statements about stored procedures is TRUE?A . Stored procedures can be written in SQL PL, but not in the PL/SQL dialectB . The CREATE SOURCED PROCEDURE statement defines a procedure...
Which of the following SQL statements will remove all rows from the table T1? (Choose two.)A . DELETE FROM t1B . DELETE* FROM t1C . DELETE* TABLE t1D . TRUNCATE TABLE t1 IMMEDIATEE ....
Which operation typically requires a Share (S) lock?A . INSERTB . SELECTC . DELETED . UPDATEView AnswerAnswer: B Explanation:https://www.ibm.com/developerworks/data/library/techarticle/dm-0509schuetz/index.html
Which three facilities are used to control authorization in DB2?A . privileges, db2ssh, LBAC credentialsB . privileges, authority levels, certificatesC . db2ssh, trusted contexts, authority levelsD . privileges, authority levels, LBAC credentialsView AnswerAnswer: D...
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)A . db2look with the Cx optionB . db2pd with the Cauth optionC . Query the...
Consider the following sequence of events: Eddie grants SELECT WITH GRANT OPTION privilege to Mike. Mike grants SELECT privilege to Jeff. Eddie revokes SELECT privilege from Mike. What will happen to Jeff’s SELECT privilege?A...
Which database object can be locked explicitly?A . RowB . ViewC . IndexD . TableView AnswerAnswer: D Explanation:https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html
Which of the following authorities are sufficient for creating a database? (Choose two.)A . DBADMB . SYSADMC . SECADMD . SYSCTRLE . SYSMAINTView AnswerAnswer: BD Explanation:https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.admin.cmd.doc/doc/r0001941.html
A user executes the following statements: СREATE TABLE t1 (c1 INT, c2 INT); CREATE ALIAS a1 FOR t1; What will be the result if the user executes the following statement? DROP ALIAS a1;A ....
Which locking event occurs when two applications lock rows that are needed by the other, such that neither application can continue executing?A . DeadlockB . Lock timeoutC . Lock escalationD . Lock conversionView AnswerAnswer:...
