Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 is illegal prints 50 prints garbage prints 045.926 is illegal prints 50 prints garbage ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Most companies keep at least two versions of any database they are using. 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? Data Definition Language(DDL) Both of above None Data Manipulation Language(DML) Data Definition Language(DDL) Both of above None Data Manipulation Language(DML) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL keyword(s) ________ is used with wildcards. NOT IN only LIKE only IN only IN and NOT IN NOT IN only LIKE only IN only IN and NOT IN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; SELECT NAME IN CUSTOMER WHERE STATE IN ('VA'); SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA'); SELECT NAME IN CUSTOMER WHERE STATE = 'VA'; SELECT NAME IN CUSTOMER WHERE STATE = 'V'; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS