Precise C2090-616 Dumps 2021

NEW QUESTION 1
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 deployed: SQL procedures, external procedures, and sourced procedures
• D. Two identically-named procedures within a schema are permitted to have exactly the same number of parameters, but the parameters must have different data types assigned

Answer: B

NEW QUESTION 2
How can you tell what privileges on a table or view have been granted to a user? (Choose two.)

• A. db2look with the –x option
• B. db2pd with the –auth option
• C. Query the SYSCAT.DBAUTH view
• D. Query the SYSCAT.TABLES view
• E. Query the SYSCAT.TABAUTH view

Answer: CE

NEW QUESTION 3
Which of the following editions of DB2 include support for Federation with Oracle database?

• A. DB2 Express-C
• B. DB2 Developer Edition
• C. DB2 Enterprise Server Edition
• D. DB2 Workgroup Server Edition

Answer: C

NEW QUESTION 4
Which of the following commands can undo the work done by the current unit of work executing UPDATE statements on a table?

• A. COMMIT
• B. SAVEPOINT
• C. ROLLBACK WORK
• D. UPDATE TERMINATE

Answer: C

NEW QUESTION 5
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 and aggregation. The initial database size is estimated at 5 TB, with growth of about 100 GB per year. Keep data size on disk to a minimum is a priority?
Which of the following editions would be best meet the described needs?

• A. DB2 Express-C
• B. DB2 Enterprise Server Edition
• C. DB2 Workgroup Server Edition
• D. DB2 Advanced Enterprise Server Edition

Answer: D

NEW QUESTION 6
A portion of your database tables are used for OLTP-type processing and another portion are used for more analytical queries. There is a small subset of tables that are used in both of these usage patterns. What could you use to derive the analytic improvements offered by BLU technology in such an environment?

• A. Shadow tables
• B. Range-partitioned tables
• C. Materialized query tables
• D. Multidimensional clustering tables

Answer: A

NEW QUESTION 7
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 dat
• E. Other applications can read the table
• F. This lock is acquired under certain conditions, such as when the table is altered or dropped or an index on the table is dropped

Answer: AE

NEW QUESTION 8
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

Answer: AB

NEW QUESTION 9
What happens when you run the following statement if MYUSER holds no privileges on table MYTABLE? REVOKE SELECT ON TABLE mytable FROM USER myuser

• A. An error is returned
• B. An entry is mane in SYSCAT.TABAUTH
• C. The REVOKE statement succeeds with no effect
• D. All privileges are granted to user MYUSER on MYTABLE

Answer: C

NEW QUESTION 10
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 to USER db2inst3;
Which of the following is TRUE if this statement is executed later? REVOKE ROLE roleB FROM USER db2inst3;

• A. This statement will succeed and DB2 INST3 will still be able to create in the database
• B. This statement will succeed and DB2 INST3 only retains DATAACCESS privileges on the database
• C. This statement will fail as CREATETAB is granted to two different roles and must be revoked at the same time
• D. This statement will succeed with a warning since CREATETAB cannot be totally revoke
• E. DB2INST3 willretain both roles

Answer: D

NEW QUESTION 11
Consider the following query and the resulting set of data:
SELECT empno, lastname FROM emp WHERE empno BETWEEN ‘000020’ and ‘000070’ Result:
If the query below is executed, how many rows will be returned?
SELECT empno FROM emp WHERE empno > ‘000020’ AND empno ‘000070’

• A. 1
• B. 3
• C. 5

Answer: C

NEW QUESTION 12
What is the primary use case for creating an index with the RANDOM option on a table?

• A. Maximize performance with OLTP random key queries
• B. Maximize performance when inserting into an expression based index containing the RAND() function
• C. Minimize contention due to ascending key or descending key inserts, especially in a pureScale environment
• D. Minimize hashing skew on a table in a multiple database partition environment, especially with column organized tables

Answer: C

NEW QUESTION 13
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

Answer: B

NEW QUESTION 14
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

Answer: A

NEW QUESTION 15
Which of the following compatibility features is always active, regardless of the settings for the DB2_COMPATIBILITY_VECTOR registry variable or the SQL_COMPAT global variable?

• A. Implicit casting
• B. Double-dot notation
• C. Use of bitmap indexes
• D. Selecting from the DUAL table

Answer: D

NEW QUESTION 16
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

Answer: B

NEW QUESTION 17
Consider the following SQL statement: SELECT workdept, empno, lastname, salary,
RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary FROM employee
ORDER BY workdept, lastname
What does the RANK() OVER (PARTITION BY workdept ORDER BY salary) clause do?

• A. It ranks the rows in each WORKDEPT by SALARY
• B. It groups all rows by WORKDEPT, then ranks all rows in the complete result set by SALARY
• C. It generates a blank output line after each group of rows with the same WORKDEPT, and ranks these groups by SALARY
• D. It tells the optimizer to physically partition the EMPLOYEE table by the WORKDEPT column for runtimeexecution, and ranks each WORKDEPT by SALARY

Answer: B

NEW QUESTION 18
Which method for restricting data access relies on security labels and security policies to control what data a user can access?

• A. Authentication
• B. Authorities and privileges
• C. Label-based access control
• D. Row and column access control

Answer: C