Introduction to SQL The SQL statement: SELECT Name, COUNT(*) FROM NAME_TABLE; counts the number of name rows and displays this total in a table with a single row and a single column. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Non-Equijoin Self-Join Equijoin None of these Non-Equijoin Self-Join Equijoin None of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language To define the data structures All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is a valid SQL type? CHARACTER All of these FLOAT NUMERIC CHARACTER All of these FLOAT NUMERIC ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL NULL is the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer the same as blank for character not a value the same as 0 for integer and blank for character the same as 0 for integer ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Select the right statement to insert values to the student table. INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( INSERT VALUES INTO student ( INSERT INTO student VALUES ( INSERT student VALUES ( INSERT VALUES ( ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS