Which of the SQL statements is correct?
A. SELECT Username AND Password FROM Users
B. SELECT Username, Password FROM Users
C. SELECT Username, Password WHERE Username = 'user1'
D. None of these
Answer: Option B
Solution(By Examveda Team)
Correct order of SELECT, FROM and WHERE clause is as follow:
SELECT column_name1, column_name2, ....
FROM table_name
WHERE condition
So, only
SELECT Username, Password FROM Users
follows the above syntax.
A. Structured Query Language
B. Structured Query List
C. Simple Query Language
D. None of these
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None
Which operator performs pattern matching?
A. BETWEEN operator
B. LIKE operator
C. EXISTS operator
D. None of these
What operator tests column for the absence of data?
A. EXISTS operator
B. NOT operator
C. IS NULL operator
D. None of these
Join The Discussion