_____ is dropped when the table or tablespace is dropped
SYNONYM
ALIAS
All of the above
None of the above
A collection of named objects is called ______
Schema
Table
Alias
Both a & b
The maximum number of tables that can be joined is _____________
20
10
15
No Limit.
When the program name is not in the plan, we get
-810
-801
-805
-825
B37 abend during SPUFI is due to
Space Issues
Data Issues
No records found while querying the table
To retrieve data from more than one table we could use
Joins
Unions
Nested SELECT
Which of the following tools can be used to automate table reorganization Operations ?
Control Center
Command Center
Command Line Processor
Task Center
Given the following statement: CREATE TABLE t1 col1 SMALLINT NOT NULL PRIMARY KEY, col2 VARCHAR(200) NOT NULL WITH DEFAULT NONE, col3 DECIMAL(5,2) CHECK (col3 >= 100.00), col4 DATE NOT NULL WITH DEFAULT) Which of the following definitions will cause the CREATE TABLE statement to fail?
COL1
COL2
COL3
COL4
Which of the following is used to indicate a column will not accept NULL values and can be referenced in another table's foreign key specification?
Check constraint
Default constraint
Unique constraint
Informational constraint
What authority is required to create a table?
ADMIN Privileges
CREATETAB Privileges
No Privileges
USERTAB Privileges