Examine this statement and output:
CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ) ; Query OK, 0 rows affected, 1 warning (0.01 sec)
An attempt is made to add an SRID attribute to the column using the statement:
ALTER TABLE geom MODIFY COLUMN g geometry NOT NULL SRID 0;
Which is true?
Examine these commands and output:
Which is true about the execution of the insert statement?
Examine the appointments table definition which contains one million rows:
Now, examine this statement which executes successfully:
Which statement will improve query performance?
Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?
Which change will prevent negative ages to be inserted into the people table?