Introduction to SQL There is an equivalent join expression that can be substituted for all subquery expressions. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language To define the data structures To specify the syntax and semantics of SQL manipulation language All of these To specify the syntax and semantics of SQL data definition language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL ON UPDATE CASCADE ensures which of the following? Normalization All of these Materialized Views Data Integrity Normalization All of these Materialized Views Data Integrity ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL SQL can be used to: modify database data only. query database data only. create database structures only. All of these modify database data only. query database data only. create database structures only. All of these ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL In SQL, which command(s) is(are) used to change a table's storage characteristics? All of these MODIFY TABLE ALTER TABLE CHANGE TABLE All of these MODIFY TABLE ALTER TABLE CHANGE TABLE ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is valid SQL for an Index? REMOVE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; CREATE INDEX ID; REMOVE INDEX ID; CHANGE INDEX ID; ADD INDEX ID; CREATE INDEX ID; ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS