Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? CHANGE TABLE MODIFY TABLE All of these ALTER TABLE CHANGE TABLE MODIFY TABLE All of these ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The benefits of a standard relational language include which of the following? All of these Reduced training costs Increased dependence on a single vendor Applications are not needed All of these Reduced training costs Increased dependence on a single vendor Applications are not needed 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 The command to eliminate a table from a database is: UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; UPDATE TABLE CUSTOMER; REMOVE TABLE CUSTOMER; DROP TABLE CUSTOMER; DELETE TABLE CUSTOMER; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which command undo all the updates performed by the SQL in the transaction? ROLLBACK TRUNCATE COMMIT DELETE ROLLBACK TRUNCATE COMMIT DELETE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The rows of the result relation produced by a SELECT statement can be sorted, but only by one column. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS