Which of the following is NOT a definition of a relation?
Which of the following is NOT a definition of a relation?
Which of the following options contains the correct restore order so that the database can be restored to the
Consider the following scenario:
Suday: full backup
Monday: delta incremental
Tuesday: incremental
Wednesday: delta incremental
Thursday: system crashed
Which of the following options contains the correct restore order so that the database can be
restored to the last stable moment before the crash?
Which of the following is NOT true about Database Management Systems?
Which of the following is NOT true about Database Management Systems?
Which of the following is NOT a valid approach for storing XML documents?
Which of the following is NOT a valid approach for storing XML documents?
how many rows will be inserted in TB1?
Consider TB1 has no rows initially and that the auto commit feature is disabled. After execution of
the following statements, how many rows will be inserted in TB1?
INSERT INTO TB1 VALUES (1, ‘ABC’)
INSERT INTO TB1 VALUES (2, ‘DEF’)
COMMIT
INSERT INTO TB1 VALUES (3, ‘GHI’)
ROLLBACK
COMMIT
how many DB2 server licenses by PVU do they need in total assuming all users can be using all machines they ha
User X needs access to server A and B, while user Y needs access to server B, C and D, how
many DB2 server licenses by PVU do they need in total assuming all users can be using all
machines they have access to at the same time?
which of the following statement will only return the first five of the rows?
If table TABLE1 contains 50 rows, which of the following statement will only return the first five of
the rows?
Which of the following statements can be used to increase in 10% the salary of all employees in department D1?
Which of the following statements can be used to increase in 10% the salary of all employees in
department D1?
"Indexes can be created on computed columns." Is this statement:
Consider the following statement. “Indexes can be created on computed columns.” Is this
statement:
Which of the following is NOT displayed by DB2 Access Plan?
Which of the following is NOT displayed by DB2 Access Plan?