Answer: WRAp 24. Explain the differences between FUNCTION, PROCEDURE, and PACKAGE Answer: function and procedure is PL / SQL code to gather, usually in order to achieve a duty. Procedure does not need to return any value, and function returns a value, on the other hand, Package A group of function and procedure that have to be brought ...
It ensure the use of consistent naming conventions for databases and links in a networked environment. 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 retu...
12 :: In PL/SQL, what is bulk binding, and when/how would it help performance? Oracle's SQL and PL/SQL engines are separate parts of the kernel which require context switching, like between unix processes. This is slow, and uses up resources. If we loop on an SQL statement, we are...
The command returns the release information, such as the following:Oracle9i Enterprise Edition Release9.2.0.7.0- ProductionPL/SQL Release9.2.0.7.0- ProductionCORE9.2.0.7.0ProductionTNS for 32-bit Windows: Version9.2.0.7.0- ProductionNLSRTL Version9.2.0.7.0- Production 3. How to find opatch Vers...
Interview Questions 数据文件 数据 数据库 其他 转载 mb5ff4099f0a555 2013-07-15 16:43:00 184阅读 2评论 Oracle面试题 以下题目,可根据自己情况挑选题目作答,不必全部作答.您也可以就相关问题直接找负责面试人员面述而不笔答……一:SQL tuning 类 1:列举几种表连接方式 2:不借助第三方工具,怎样查看sq...
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...
Oracle 笔试题 oracle DBA 面试题及答案 (国外公司 ) oracle 数据库笔试题 DBA 国际大公司 Oracle 面试笔试题 oracle Database DBA Interview Questions 1. How many memory layers are in the shared pool? Sqlplus shared pool and private pool. 2. How do you find out from the RMAN catalog if a part...
Oracle APEX interview questions – APEX-related examples: What is Page Zero in Oracle APEX? What are Collections in APEX? Could you give some usage examples? What would you call APEX Items in APEX, in PL/SQL, and in JS? How would you connect an Oracle APEX application to Active Directory...
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.