Introduction to SQL Which of the following must be enclosed in double quotes? Strings Column Alias All of these Dates Strings Column Alias All of these Dates ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL query and modification commands make up a(n) ________ . HTML DML DDL XML HTML DML DDL XML ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following do you need to consider when you make a table in SQL? Primary keys Data types All of these Default values Primary keys Data types All of these Default values ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Let the statementSELECT column1 FROM myTable;return 10 rows. The statementSELECT ALL column1 FROM myTable;will return exactly 10 rows None of these more than 10 rows less than 10 rows exactly 10 rows None of these more than 10 rows less than 10 rows ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL To define what columns should be displayed in an SQL SELECT statement: use FROM to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. use FROM to name the source table(s) and list the columns to be shown after SELECT. use SELECT to name the source table(s) and list the columns to be shown after USING. use USING to name the source table(s) and list the columns to be shown after WHER use USING to name the source table(s) and list the columns to be shown after SELECT. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature ends with two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature has more than two 0's Feature ends with two 0's Feature has two 0's in it, at any position Feature begins with two 0's Feature has more than two 0's ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS