Which of the following is true about the EXPLAIN command

When declaring a foreign key on a table, referencing an existing primary key with complete definition, what might differ between foreign key and primary key?

When a user has a SELECT authorization on a certain base table, and he creates a view on that table alone, then which of the following is true?

Given the statement: CREATE TABLE t1 (c1 INTEGER NOT NULL,c2 INTEGER,PRIMARY KEY(c1),FOREIGN KEY(c2) REFERENCES t2) How many non-unique indexes are defined for table t1?

When is it necessary to precompile DB2 REXX procedures before running them?

Can static SQL statements be changed without altering the program itself?

What should be done before you do EXPLAIN?

If the null indicator has -1, what does it mean?

Which technique is used to retrieve data from more than one table in a single SQL statement?

How do you concatenate the FIRSTNAME and LASTNAME from EMPLOYEE table to give a complete name?

How would you retrieve the first 5 characters of FIRSTNAME column of DB2 table EMP?