Application 1 executes the following statements:
INSERT INTO TAB1 (NAME,AMOUNT) VALUES (‘John,100);
COMMIT;
UPDATE TAB1 SET AMOUNT=90 WHERE NAME=‘John’;
After a few seconds, application 2 executes the following query:
SELECT AMOUNT FROM TAB1 WHERE NAME=‘John’
Assuming the Currently Committed (CUR_COMMIT) configuration parameter is enabled, which of the following is TRUE?
The creator of an index or an index specification automatically receives which privilege on the index?
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?
Which of the following editions of DB2 include support for Federation with Oracle database?
What is the maximum length allowed for a VARCHAR2 data type when the VARCHAR2_COMPAT database configuration parameter is set to ON?
DumpsMate's team of experts is always available to respond your queries on exam preparation. Get professional answers on any topic of the certification syllabus. Our experts will thoroughly satisfy you.
TESTED 26 Apr 2024
