Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND ADD UPDATE INSERT APPEND ADD UPDATE INSERT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES INTO student ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT student VALUES ( INSERT INTO student VALUES ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: query database data only. create database structures only. All of these modify database data only. query database data only. create database structures only. All of these modify database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 0 9 10 5 0 9 10 5 ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? JOIN LEN AVG LEFT JOIN LEN AVG LEFT ANSWER DOWNLOAD EXAMIANS APP