Introduction to SQL SQL can be used to: All of these modify database data only. create database structures only. query database data only. All of these modify database data only. create database structures only. query database data only. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL You can add a row using SQL in a database with which of the following? MAKE INSERT CREATE ADD MAKE INSERT CREATE ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following is the original purpose of SQL? 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 To specify the syntax and semantics of SQL data definition language To specify the syntax and semantics of SQL manipulation language ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Count function in SQL returns the number of groups. distinct values. columns. values. groups. distinct values. columns. values. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL A subquery in an SQL SELECT statement: can always be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. has a distinct form that cannot be duplicated by a join. can always be duplicated by a join. cannot have its results sorted using ORDER BY. can only be used with two tables. has a distinct form that cannot be duplicated by a join. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL 'AS' clause is used in SQL for Selection operation. Rename operation. Join operation. Projection operation. Selection operation. Rename operation. Join operation. Projection operation. ANSWER DOWNLOAD EXAMIANS APP