Introduction to SQL SQL provides five built-in functions: COUNT, SUM, AVG, MAX, MIN. True False True False ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A dynamic view is one whose contents materialize when referenced. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The command to remove rows from a table 'CUSTOMER' is: DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... DELETE FROM CUSTOMER WHERE ... UPDATE FROM CUSTOMER ... REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ... ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? All of these Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity Normalization ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following join is also called as an 'inner-join'? Equijoin None of these Non-Equijoin Self-Join Equijoin None of these Non-Equijoin Self-Join 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 Data types All of these Primary keys Default values Data types All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS