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. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL WHERE clause: Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. Neither A nor B are correct. Both A and B are correct. limits the row data are returned. limits the column data that are returned. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) None Data Manipulation Language(DML) Both of above Data Definition Language(DDL) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to delete data FROM a database? COLLAPSE DELETE REMOVE ALTER COLLAPSE DELETE REMOVE ALTER ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a SQL aggregate function? AVG LEFT LEN JOIN AVG LEFT LEN JOIN ANSWER DOWNLOAD EXAMIANS APP