Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password FROM Users SELECT Username AND Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users SELECT Username AND Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statement: SELECT Number1 + Number 2 AS Total FROM NUMBER_TABLE; adds two numbers from each row together and lists the results in a column named Total. False True False True ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Table employee has 10 records. It has a non-NULL SALARY column which is also UNIQUE.The SQL statementSELECT COUNT(*) FROM employee WHERE SALARY > ALL (SELECT SALARY FROM EMPLOYEE);prints 0 9 10 5 0 9 10 5 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 manipulation language To specify the syntax and semantics of SQL data definition language To define the data structures All of these 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 ________ was adopted as a national standard by ANSI in 1992. Microsoft Access SQL Oracle DBase Microsoft Access SQL Oracle DBase ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which SQL statement is used to update data in a database? MODIFY SAVE AS UPDATE SAVE MODIFY SAVE AS UPDATE SAVE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS