Introduction to SQL To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. SINGLE ONLY UNIQUE DISTINCT SINGLE ONLY UNIQUE DISTINCT ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users SELECT Username, Password WHERE Username = 'user1' SELECT Username, Password FROM Users None of these SELECT Username AND Password FROM Users 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 manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures To specify the syntax and semantics of SQL manipulation language To specify the syntax and semantics of SQL data definition language All of these To define the data structures ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) Both of above None Data Definition Language(DDL) Data Manipulation Language(DML) ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the following SQL commands can be used to add data to a database table? APPEND UPDATE INSERT ADD APPEND UPDATE INSERT ADD ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The ADD command is used to enter one row of data or to add multiple rows as a result of a query. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS