C2090-616 PDF Dumps
How to use our free ibm C2090-616 PDF Dumps
Our Free C2090-616 PDF dumps are based on the full C2090-616 mock exams which are available on our Web Site.
The ibm C2090-616 PDF consists in questions and answers with detailed explanations.
You can use the PDF C2090-616 practice exam as a study material to pass the C2090-616 exam, and don't forget to try also our C2090-616 testing engine Web Simulator.
- - Download as PDF file format from those pages:
Java 8 PDF Dumps | Spring Core PDF Dumps | Oracle 12c PDF Dumps | Microsoft PDF Dumps | Cisco PDF Dumps | PMI PDF Dumps | Salesforce PDF Dumps | VMware PDF Dumps | Cloudera PDF Dumps | Amazon PDF Dumps | APICS PDF Dumps | C++ PDF Dumps | CompTIA PDF Dumps | ECCouncil PDF Dumps | ISC PDF Dumps | Palo Alto Networks PDF Dumps - - or -
- - Use it with our Free Web Simulator from those pages:
Java 8 Practice Exams | Spring Core Practice Exams | Oracle 12c Practice Exams | Microsoft Practice Exams | Cisco Practice Exams | PMI Practice Exams | Salesforce Practice Exams | VMware Practice Exams | Cloudera Practice Exams Amazon PDF Dumps | APICS PDF Dumps | C++ PDF Dumps | CompTIA PDF Dumps | ECCouncil PDF Dumps | ISC PDF Dumps | Palo Alto Networks PDF Dumps
Q1.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 solution: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/sqlref/src/tpc/ db2z_sql_createfuncinlinesqlscalar.html Q2.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 solution: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.5.0/ com.ibm.db2.luw.admin.dbobj.doc/doc/c0004113.html Q3.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 solution: A Q4.Which of the following authorities is sufficient for connecting to a database? - A: SQLADM - B: CONNECT - C: DATAACESS - D: ACCESSCTRL solution: D Explanation: Reference: http://www-01.ibm.com/support/docview.wss?uid=swg21427232 Q5.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 solution: A, B Q6.Which DB2 object is associated with PREVIOUS VALUE and NEXT VALUE expressions? - A: Sequence - B: Row Identifier - C: Identity Column - D: Insert time clustering table solution: A Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/sqlref/src/tpc/ db2z_sequencereference.html Q7.Which of the following statements describe super exclusive (Z) locks for a table? (Choose two.) - A: No other applications can access the table - B: Only uncommitted read (UR) applications can access the table - C: The lock owner and other applications can read, but not update, the locked table - D: The lock owner can both read and update data. Other applications can read the table - E: This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped solution: A, E Explanation: Reference: https://www.ibm.com/support/knowledgecenter/hr/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0005270.html Q8.Which of the following statements regarding locking is TRUE? - A: The same lock modes apply to tables, rows, or blocks - B: Lock conversion can take place implicitly as a query executes - C: Changing the mode of a lock that is already held is called lock escalation - D: Lock conversion is not necessary if an X lock is required and an S or U lock is currently held solution: B Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_9.7.0/ com.ibm.db2.luw.admin.perf.doc/doc/c0021283.html Q9.Which of the following is designed for continuous availability, increased throughput of many concurrent short queries, and easy scalability? - A: DB2 HADR - B: DB2 pureScale - C: DB2 Express-C - D: DS2 Database Partitioning Feature solution: B Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/ com.ibm.db2.luw.licensing.doc/doc/c0054843.html Q10.Which of the following statements will successfully create a table that scores index data in a different table space than the table data? - A: CREATE TABLE t1 (c1 INT, c2 INT); - B: CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS2; - C: CREATE TABLE t1 (c1 INT, c2 INT) IN TS1 INDEX IN TS1; - D: CREATE TABLE t1 (c1 INT, c2 INT) DATA IN TS1 INDEX IN TS2; solution: B