PrepAway - Latest Free Exam Questions & Answers

Which of the following database objects can be used to accomplish this?

A number of applications issue the following SQL statement:
SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno
= e.deptno
A database administrator wishes to store this query within the database. Which of the following
database objects can be used to accomplish this?

PrepAway - Latest Free Exam Questions & Answers

A.
Alias

B.
View

C.
Schema

D.
Trigger


Leave a Reply