How can this be done?
A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in. How can this be done? A. Enable share result set on the list object. B. Create a join in the Query explorer to merge the data. […]
Where should the Dashboard be located?
An author has finished working on a Dashboard and wants to make it available to other authors. Where should the Dashboard be located? A. My content folder B. Team content folder C. Administration console, Mobile tab D. Administration console, Library tab
How can this be achieved?
A customer wants to have a report with a bar chart, which is going to be displayed on a tablet. By changing a filter on the report, the chart should change dynamically. The report output size should be as small as possible. How can this be achieved? A. Create an Active Report using visualizations. Check […]
Which of the following is TRUE about indexes on column organized tables?
Which of the following is TRUE about indexes on column organized tables? A. No indexes are allowed B. Indexes are only allowed on numeric columns C. Indexes are automatically created to enforce unique constraints D. An index is only allowed on the synopsis table supporting a column organized table
Which of the following statements about triggers are TRUE? (Choose two.)
Which of the following statements about triggers are TRUE? (Choose two.) A. There is a limit of 8 for the maximum number of cascading trigger activations B. Triggers can be activated as a result of changes due to referential constraint enforcement C. Multiple INSTEAD OF triggers are allowed for each kind of operation on a […]
Which edition of DB2 LUW has been discontinued in v11.1?
Which edition of DB2 LUW has been discontinued in v11.1? A. DB2 Developer Edition B. DB2 Express Server Edition C. DB2 Enterprise Server Edition D. DB2 Connect Enterprise Server Edition Reference: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/r0053238.html
Which of the following statements about stored procedures is TRUE?
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 dialect B. The CREATE SOURCED PROCEDURE statement defines a procedure that is based on another procedure in a federated database C. There are three types of stored procedures which can be […]
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work?
Which of the following is TRUE about a COMMIT statement executed at the end of the T1 unit of work? A. A ROLLBACK command executed just after the COMMIT command cancels that COMMIT B. Save points defined during transaction T1 are released only if there is a RELEASE SAVEPOINT command executed after the COMMIT command […]
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table?
Which constraint can be used to ensure that identical values are never stored in a set of columns in a table? A. NOT NULL B. Foreign key C. Primary key D. Informational constraint Reference: https://www.ibm.com/developerworks/data/library/techarticle/dm-0401melnyk/index.html
What will be the result if the user executes the following statement?
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. The alias A1 will be dropped B. The table T1 will be dropped C. Both T1 and A1 will be dropped […]