Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT student VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Join operation. Projection operation. Rename operation. Selection operation. Join operation. Projection operation. Rename operation. Selection operation. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SUM, AVG, MIN, and MAX can only be used with numeric columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The FROM SQL clause is used to... specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition specify what table we are selecting or deleting data FROM None of these specify search condition specify range for search condition ANSWER DOWNLOAD EXAMIANS APP