Introduction to SQL Indexes may be created or dropped at any time. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A view is which of the following? A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands A virtual table that can be accessed via SQL commands A base table that can be accessed via SQL commands A virtual table that cannot be accessed via SQL commands A base table that cannot be accessed via SQL commands ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70oF. SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' OR temperature > 70; SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' OR temperature > 70; ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Indexes can usually be created for both primary and secondary keys. True False True False 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 Default values All of these Data types Primary keys Default values All of these Data types ANSWER DOWNLOAD EXAMIANS APP
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
EXAMIANS