Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10. Select from employee where salary >10000 and dept ld=101; Which of the following flelds are displayed as an output? * (1 Point) All

image text in transcribed
10. Select " from employee where salary >10000 and dept ld=101; Which of the following flelds are displayed as an output? * (1 Point) All the field of the employee table Salary Employee Salary, deptijd 11. Insert into employee (1002,30;2000); In the given query which of the keyword below has to be used in the blank space above? * (1 Point) Field Table Relation Values 12. To alter a database which command below should be used * (1 Point) ALTER database name Modify database name Modify database database, name A.TER database database name 13. is used with aggregations to filter out results feturned by the aggregation. It is similar to WHERE except that WHERE removes values before the aggregation function is applied to the values, and (1. Point) emoves values after aggregation has occurred. WHERE, HAVING HAVING, WHERE WHERE, WHERE HAVING, HAVING

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Concepts International Edition

Authors: David M. Kroenke

6th Edition International Edition

0133098222, 978-0133098228

More Books

Students also viewed these Databases questions

Question

=+ 9. What is inflation and what causes it?

Answered: 1 week ago

Question

=+6. What does the invisible hand of the marketplace do?

Answered: 1 week ago