Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 385 |
Which of the following sets of keywords constitutes a mapping in SQL?
| SELECT, FROM, TABLE | |
| SELECT, FROM, WHERE
| |
| CONNECT, TABLE, CREATE | |
| SELECT, TABLE, INSERT
|
Question 385 Explanation:
Explanation: SELECT, FROM, WHERE are the keywords that constitute a mapping in SQL.
A SELECT statement retrieves zero or more rows from one or more database tables
WHERE specifies which rows to retrieve. The SQL From clause is the source of a row set to be operated upon in a Data Manipulation Language (DML) statement.
Exam[le: SELECT *
FROM mytable
WHERE mycol > 100
A SELECT statement retrieves zero or more rows from one or more database tables
WHERE specifies which rows to retrieve. The SQL From clause is the source of a row set to be operated upon in a Data Manipulation Language (DML) statement.
Exam[le: SELECT *
FROM mytable
WHERE mycol > 100
Correct Answer: B
Question 385 Explanation:
Explanation: SELECT, FROM, WHERE are the keywords that constitute a mapping in SQL.
A SELECT statement retrieves zero or more rows from one or more database tables
WHERE specifies which rows to retrieve. The SQL From clause is the source of a row set to be operated upon in a Data Manipulation Language (DML) statement.
Exam[le: SELECT *
FROM mytable
WHERE mycol > 100
A SELECT statement retrieves zero or more rows from one or more database tables
WHERE specifies which rows to retrieve. The SQL From clause is the source of a row set to be operated upon in a Data Manipulation Language (DML) statement.
Exam[le: SELECT *
FROM mytable
WHERE mycol > 100