Which of the following is NOT true about schemas?
Which of the following is NOT true about schemas?
When does a view get populated?
When does a view get populated?
Which of the following INSERT statements will execute successfully?
Given the following statements:
CREATE TABLE table1 (col1 INTEGER, col2 CHAR(3));
CREATE VIEW view1 AS
SELECT col1, col2 FROM table1
WHERE col1 < 100
WITH LOCAL CHECK OPTION;
Which of the following INSERT statements will execute successfully?
Which of the following actions will NOT cause a trigger to be fired?
Which of the following actions will NOT cause a trigger to be fired?
Which of the following statements is NOT true?
The following triggers were defined for a table named SALES in the order shown:
CREATE TRIGGER trigger_a
NO CASCADE BEFORE UPDATE ON sales
REFERENCING NEW AS new
FOR EACH ROW
SET new.commission = sale_amt * .05
WHERE invoice = n.invoice;
CREATE TRIGGER trigger_b
AFTER INSERT ON sales
REFERENCING NEW AS new
FOR EACH ROW
UPDATE sales SET bill_date = CURRENT DATE + 30 DAYS
WHERE invoice = n.invoice;
CREATE TRIGGER trigger_c
NO CASCADE BEFORE DELETE ON sales
FOR EACH ROW
SIGNAL SQLSTATE ‘75005’
SET MESSAGE_TEXT = ‘Deletes not allowed!’;
Which of the following statements is NOT true?
Which of the following CREATE TABLE statements will NOT be successful?
Which of the following CREATE TABLE statements will NOT be successful?
Which of the following statements is true?
If the following SQL statement is executed:
CREATE TABLE sales
(invoice_no NOT NULL PRIMARY KEY,
sales_date DATE,
sales_amt NUMERIC(7,2))
IN tbsp0, tbsp1, tbsp2, tbsp3
PARTITION BY RANGE (sales_date NULLS FIRST)
(STARTING ‘1/1/2007′ ENDING ’12/31/2007’
EVERY 3 MONTHS)
Which of the following statements is true?
Which of the following is NOT a characteristic of a declared temporary table?
Which of the following is NOT a characteristic of a declared temporary table?
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referenc
Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a
foreign key referencing the primary key (IDCOL1) of TABLE1?
What type of constraint can be used to ensure that, in any given row in a table, the value of one column never
What type of constraint can be used to ensure that, in any given row in a table, the value of one
column never exceeds the value of another column?