Multiple Choice Questions - SQL Views
1) Views are virtual tables.
A) True
B) False
2)
You can perform ...... operation(s) on SQL Views.
A) Select
B) Filter
C) Sort
D) Join
E) All of above
3)
Views can be indexed, and they can have triggers or default values associated with them.
A) True
B) False
4)
You can update a view by using the following syntax:
A)
CREATE OR UPDATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
B)
UPDATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
C)
CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
5)
You can delete a view with the ........... command
A) DELETE VIEW
B) REMOVE VIEW
C) DROP VIEW
D) DIGG VIEW
6)
In Oracle SQL no insert, update, or delete modifications on views are allowed that use one of the following constructs in the view definition:
A) Joins
B) Aggregate function such as sum, min, max etc.
C) set-valued subqueries (in, any, all) or test for existence (exists)
D) group by clause or distinct clause
E) All of Above
7)
The following view statements contain the name, job title and the annual salary of employees working in the department 20: (Choose the correct)
A)
create view DEPT20 is
select ENAME, JOB, SAL*12 ANNUAL SALARY from EMP
where DEPTNO = 20;
B)
create view DEPT20 as
select ENAME, JOB, SAL*12 ANNUAL SALARY from EMP
where DEPTNO = 20;
C)
create view DEPT20 as
select ENAME, JOB, SAL*12 ANNUAL SALARY from EMP
where DEPTNO <> 20;
8)
A view is evaluated again each time it is accessed.
A) True
B) False
9)
............ view contains an entry for each datafile of the database.
A) v$data_file
B) v$datfile
C) v$datafiles
D) v$datafile
10)
...............Contains information on each log group.
A) v$log
B) v$log_file
C) v$loggroup
D) v$log_group
Answers