Given two tables, t1 and t2, the join condition "t1.t2_id = t2.id" how do you get rows from t1 that have NO counterparts in t2?

How would you remove all rows from a table 'STAFF'

The user-created stored function 'test' takes a varchar(5) and an integer and returns a varchar. Which of the following correctly calls the function?

______ - Nothing that’s being read is actively being changed by another transaction.

To select the multiple values from a column as a string use the _________ function.

The _____________ privilege is often used when loading a file into a database table.

Result of this query? SELECT lNSERT()

Which holds correct while optimizing the query? 1) Use ((a AND D) AND c OR (((a AND D) AND (c AND d)))) instead of (a AND D AND c) on (3 AND b AND c AND d) 2)Use b>5 AND b=c AND 825 instead of (a 3}Use (8>=5 AND 8:5) OR (8:6 AND 5:5) 0R (8:7 AND 5:6) instead of B=5 OR 8=6

Which can be done using the ALTER TABLE statement?

Which statements are correct in the context of the lNSERT statement?

Which should be done for optimizing SELECT statements?