Which of the following is NOT a definition of a relation?
Consider the following scenario:
Suday: full backup
Monday: delta 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 a valid approach for storing XML documents?
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’)
INSERT INTO TB1 VALUES (3, ‘GHI’)
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?
If table TABLE1 contains 50 rows, which of the following statement will only return the first five of
Which of the following statements can be used to increase in 10% the salary of all employees in
Consider the following statement. “Indexes can be created on computed columns.” Is this
Which of the following is NOT displayed by DB2 Access Plan?