Please answer following questions explaining with proof.. 1. The SQL command use
ID: 666935 • Letter: P
Question
Please answer following questions explaining with proof..
1. The SQL command used to select attributes from rows in one or more tables is _____.
2. The command to join the EMP_LNAME attribute from the EMPLOYEE table and the PROJ_NAME and PROJ_BUDGET attributes from the PROJECT table where the value of EMP_NUM match is _____.
3. Database connectivity software is also known as:
4. The _____ query will output the table contents when the value of PROD_ PRICE is less than or equal to 100.00.
5. The operator used to check whether an attribute value is within a range of values is _____.
6. SQL is a(n) _____ language.
Explanation / Answer
1. The SQL command used to select attributes from rows in one or more tables is _____.
SELECT
2. The command to join the EMP_LNAME attribute from the EMPLOYEE table and the PROJ_NAME and PROJ_BUDGET attributes from the PROJECT table where the value of EMP_NUM match is _____.
select EMP_LNAME from EMPLOYEE
join
select PROJ_NAME, PROJ_BUDGET from PROJECT
on EMPLOYEE.EMP_NUM,PROJECT.EMP_NUM
3. Database connectivity software is also known as: Database middleware
4. The _____ query will output the table contents when the value of PROD_ PRICE is less than or equal to 100.00.
select *from table where PROD_ PRICE<=100.00
5. The operator used to check whether an attribute value is within a range of values is _____.
BETWEEN
6. SQL is a(n) _____ language.
Structured querying language