A Format 1 partition has primary and secondary extents of 5000 pages. Which MAXEXTENTS
value maximizes the table size?

Click on the Exhibit button to show the result of a FILEINFO, STAT, PARTONLY of a base table and index.

What is the maximum number of physical I/Os needed to retrieve a base table row for a specific
index value using these partitions?

Click the Exhibit button.

The exhibit shows the explain plan output. What happens with the first FETCH statement of the explained cursor?

Click the Exhibit button.

The exhibit shows the Employee and Department Tables.
Based on the definition of these two tables, what happens if a department is deleted from the Department Table
without checking that an employee belongs to the department.

In which situation can denormalization enhance performance?

Access of a base table through an index can be more expensive than a full table scan. What are
possible reasons? Select TWO.

What can be performed on an entry-sequenced table?

Tandem Reload Analyzer (TRA) can be used to determine if files or tables would benefit from
being reloaded. For which file or table organization can TRA be used?

Review the following declaration.
EXEC SQL BEGIN DECLARE SECTION;

EXEC SQL INVOKE TESTTAB AS test_tbl;
struct test_tbl test;
int new_salary = -1;
EXEC SQL END DECLARE SECTION;
test.salary_i = -1;
Which statement sets the salary column to NULL in the table testtab?

Which NonStop SQL component is used to form an executable query plan?