Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews DB Oracle Interviews:Concepts and ArchitectureData AccessDatabase ArchitectureDatabase ManagementDatabase Security OracleDistributed ProcessingFlexfieldForms ReportsGeneral OracleMemory ManagementMTO-SAP Financial AccountingOCIOracle AOLOracle AROracle Backup RecoveryOracle D2KOracle DatabaseOracle Database DeveloperOracle DB OptimizationOracle DBAOracle DeveloperOracle ETLOracle Forms 3.0Oracle Forms 4.0Oracle GLOracle PL-SQLOracle RMANOracle ScenariosOracle SecurityOracle SQLOracle System ArchitectureOracle Technology Network (OTN)Programmatic ConstructsRAC (Real Application Clusters)SQL Plus
Copyright © 2018. All Rights Reserved
Concepts and Architecture Interview Question:
If a user executes a query which is already being used by a view exactly will oracle use already existing view to retrieve data or use the query executed by user?
Submitted by: AdministratorOracle uses query executed by user because when you use a view name in an other query, it simply transform query.
select empid,name from emp; --- original
create view emp_view as select empid,name from emp; ----- view created as name emp_view
select * from emp_view where empid=100; ---------- this quey transform into
select * from (select empid,name from emp) where empid=100;
In above query it uses view because we use view name.
If we execute original query ,It does not have any view any to interpret,hence it uses original query.
Submitted by: Administrator
select empid,name from emp; --- original
create view emp_view as select empid,name from emp; ----- view created as name emp_view
select * from emp_view where empid=100; ---------- this quey transform into
select * from (select empid,name from emp) where empid=100;
In above query it uses view because we use view name.
If we execute original query ,It does not have any view any to interpret,hence it uses original query.
Submitted by: Administrator
Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.
https://InterviewQuestionsAnswers.ORG.