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
Subscribe
Login
0 Comments