Introduction to SQL Which of the following is the original purpose of SQL? All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? INSERT CREATE MAKE ADD INSERT CREATE MAKE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ............. joins two or more tables based on a specified column value not equaling a specified column value in another table. NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN NATURAL JOIN OUTER JOIN EQUIJOIN NON-EQUIJOIN ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME SUM, AVG, MIN, MAX, MULT COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN SUM, AVG, MIN, MAX, NAME ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL keyword is used to retrieve a maximum value? MOST TOP UPPER MAX MOST TOP UPPER MAX ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL What is the meaning of LIKE '%0%0%' Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's Feature has more than two 0's Feature has two 0's in it, at any position Feature ends with two 0's Feature begins with two 0's ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS