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
Introduction to SQL What is the full form of SQL? Structured Query Language Simple Query Language None of these Structured Query List Structured Query Language Simple Query Language None of these Structured Query List 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 A subquery in an SQL SELECT statement is enclosed in: braces -- {...}. CAPITAL LETTERS. parenthesis -- (...) . brackets -- [...]. braces -- {...}. CAPITAL LETTERS. parenthesis -- (...) . brackets -- [...]. ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL Which of the SQL statements is correct? SELECT Username AND Password FROM Users SELECT Username, Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' SELECT Username AND Password FROM Users SELECT Username, Password FROM Users None of these SELECT Username, Password WHERE Username = 'user1' ANSWER DOWNLOAD EXAMIANS APP
Introduction to SQL The SQL statementSELECT ROUND(45.926, -1) FROM DUAL; prints 045.926 prints 50 is illegal prints garbage prints 045.926 prints 50 is illegal prints garbage ANSWER DOWNLOAD EXAMIANS APP