Become a GOLD Member and access 40+ Technology Courses...
Live Help (Start Chat)
Interview Questions and Answer
Options:
a. A view is a special stored procedure executed when certain event occurs
b. A view is a virtual table which results of executing a pre-compiled query
c. A view is a database diagram
d. None of the Mentioned
Reveal Answer
Options:
a. Views could be looked as an additional layer on the table which enables us to protect intricate or sensitive data based upon our need
b. Views are virtual tables that are compiled at run time
c. Creating views can improve query response time
d. All of the Mentioned
Reveal Answer
Options:
a. System Defined Views
b. User Defined View
c. Simple View
d. Complex View
Reveal Answer
Options:
a. CREATE VIEW AS SELECT
b. CREATE VIEW AS UPDATE
c. DROP VIEW AS SELECT
d. CREATE VIEW AS UPDATE
Reveal Answer
Options:
a. DROP VIEW
b. DELETE VIEW
c. REMOVE VIEW
d. TRUNCATE VIEW
Reveal Answer
Options:
a. Schema binding binds your views to the dependent physical columns of the accessed tables specified in the contents of the view
b. These are stored only in the Master database
c. These types of view are defined by users on specified schema
d. These are used to show database self describing information
Reveal Answer
Options:
a. INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
b. INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
c. INFORMATION_SCHEMA.KEY_COLUMN_USAGE
d. sys.dm_exec_connections
Reveal Answer
Options:
a. Database-scoped Dynamic Management View
b. Complex View
c. Catalog View
d. None of the above mentioned
Reveal Answer
Options:
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;
d. All the Above
Reveal Answer
Options:
a. v$data_file
b. v$datfile
c. v$datafiles
d. v$datafile
Reveal Answer
Options:
a. v$log
b. v$log_file
c. v$loggroup
d. v$log_group
Reveal Answer
Options:
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
d. None of these
Reveal Answer
Bestdotnet google plus