A view in Oracle is a virtual table created by a SQL query that selects data from one or more tables. It does not store data itself but displays data from the underlying tables. 12) What is the difference between DELETE and TRUNCATE commands in Oracle? The DELETE command removes specific ...
Oracle utilizes SQL (Structured Query Language) for querying and manipulating data, providing a comprehensive platform for data management in organizations. 2. What are the different components of Oracle architecture? The Oracle architecture consists of several key components, including: a. Oracle Data...
3. What command would you use to encrypt a PL/SQL application? WRAP 4. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. They are all named PL/SQL blocks. Function must return a value. Can be called inside a query. Procedure may or may not return value. Package is the ...
17 :: How do I write a cron which will run a SQL query and mail the results to agroup? Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results through email.Read More 18 :: What operator performs pattern matching LIKE operatorRead More 19 :: What is the use of...
13. How you were passing cursor variables in PL/SQL 2.2. In PL/SQL 2.2 cursor variables cannot be declared in a package.This is because the storage for a cursor variable has to be allocated using Pro*C or OCI with version 2.2,the only means of passing a cursor variable to a PL/SQL...
DBMS Tutorial | Database Management System tutorial and examples on Oracle, SQL, MongoDB, MCQ, Interview Questions with the answer, etc.
DBMS Tutorial | Database Management System tutorial and examples on Oracle, SQL, MongoDB, MCQ, Interview Questions with the answer, etc.
ORACLE DBA 面试题集 一:SQL tuning 类 1 列举几种表连接方式 等连接、非等连接、自连接、外连接(左、右、全) 2 不借助第三方工具,怎样查看 sql 的执行计划 I) 使用 Explain Plan,查询 PLAN_TABLE; EXPLAIN PLAN SET STATEMENT_ID='QUERY1' FOR SELECT * FROM a WHERE aa=1; SELECT operation, options...
34. What SQL query from v$session can you run to show how many sessions are logged in as a particular user account? 35. Why does Oracle not permit the use of PCTUSED with indexes? 36. What would you use to improve performance on an insert statement that places ...
To generate a report of all full and incremental backups from an Oracle Enterprise Manager (OEM) database, you can use the following SQL query. This query retrieves information from the…Read more » Mastering Oracle Database: Interview Questions and Answers ...