Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . HTML DDL DML XML HTML DDL DML XML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; ADD INDEX ID; CHANGE INDEX ID; 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 Scalar aggregate are multiple values returned from an SQL query that includes an aggregate function. 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? All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS