Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE ADD CREATE INSERT MAKE ADD CREATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following group functions ignore NULL values? All of these COUNT MAX SUM All of these COUNT MAX SUM ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to eliminate a table from a database is: DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; DROP TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS