SAP R/3
ABAPBASISOracleFICO (Financial Accounting & Controling)MM (Materials Management)SD (Sales and Distribution)HR (Human Resource)PP (Production Planning)BW (Business Warehousing)PM (Plant Maintenance)QM (Quality Management)NetweaverPS (Project Systems)Business OneIS (Industry Solutions)SCM (SAP Supply Chain Management)IM (Investment Management)SRM (Supplier Relationship Management)CRM (Customer Relationship Management)SEM (Strategic Enterprise Management Software)CS (Customer Service)EC (Enterprise Controlling)TR (Treasury)Logistics Information SystemAPO Advanced Planner and Optimizer
Home » Interview Questions » Oracle
Viewing 0 - 20 out of 382 Articles
Oracle
- Oracle SQL optimization FAQ
1. What is SQL optimization? SQL optimization (or SQL statement tuning or Shared Cursor cache analysis) refers to the identification, analysis and optimization of SQL statements that are responsible ... - Oracle Certified Professional Exams IZ007 Questions Set 5
Q. Which four are correct guidelines for naming database tables? (Choose four) A. Must begin with either a number or a letter. B. Must be 1-30 characters long. C. Should not be an Oracle Server r ... - Oracle Interview Question Set 1
Question 1. what is difference between Co-related sub query and nested sub query? Answer: Co-related sub query is one in which inner query is evaluated only once and from that result outer query is ... - (1Z0-007q9) Which of the following has been achieved by the following SQL codes? SELECT employee_id FROM employees WHERE commission_pct = .5 OR salary > 23000;
Q. (1Z0-007q9) Which of the following has been achieved by the following SQL codes? SELECT employee_id FROM employees WHERE commission_pct = .5 OR salary > 23000; A. it returns employees who ha ... - When should you create a role? (Choose two)
Q. When should you create a role? (Choose two) A. to simplify the process of creating new users using the CREATE USER xxx IDENTIFIED by yyy statement B. to grant a group of related privileges ... - Which two statements complete a transaction? (Choose two.)
Q. Which two statements complete a transaction? (Choose two.) A. DELETE employees; B. DESCRIBE employees; C. ROLLBACK TO SAVEPOINT C; D. GRANT SELECT ON employees TO SCOTT; E. ALTER TABL ... - Oracle Interview Question Set 2
Question 21.: What is Log Switch? Answer: The point at which ORACLE ends writing to one online redo log file and begins writing to another is called a log switch. Question 22. What are the steps ... - Which two statements about sequences are true? (Choose two.)
Q. Which two statements about sequences are true? (Choose two.) A. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retr ... - Q. Which two statements about creating constraints are true? (Choose two.)
Q. Which two statements about creating constraints are true? (Choose two.) A. Constraint names must start with SYS_C. B. All constraints must be defined at the column level. C. Constraints ... - Which two statements about subqueries are true? (Choose two.)
Q.Which two statements about subqueries are true? (Choose two.) A. A single row subquery can retrieve data from only one table. B. A SQL query statement cannot display data from table B that i ... - Mark for review The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point?
Q. Mark for review The DBA issues this SQL command: CREATE USER scott IDENTIFIED by tiger; What privileges does the user Scott have at this point? A. no privileges B. only the SELECT privilege ... - Mark for review Which two are true about aggregate functions? (Choose two.)
Q. Mark for review Which two are true about aggregate functions? (Choose two.) A. You can use aggregate functions in any clause of a SELECT statement. B. You can use aggregate functions only i ... - Oracle Certified Professional Exams IZ007 Questions Set 36
Q. What does the TRUNCATE statement do? A. removes the table B. removes all rows from a table C. shortens the tale to 10 rows D. removes all columns from a table E. removes foreign keys from a ta ... - Oracle Certified Professional Exams IZ007 Questions Set 38
Q. Scott issues the SQL statements: to be done CREATE TABLE dept (deptno number(2) dname VARCHAR2(14) loc VARCHAR2(13)); GRANT SELECT ON DEPT TO SUE; If Sue needs to select from Scott’s D ... - Oracle Certified Professional Exams IZ007 Questions Set 9
Q. Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for a ... - Oracle Certified Professional Exams IZ007 Questions Set 20
Q. Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Sc ... - The server parameter file (SPFILE) provides which three advantages when managing initialization parameters? (Choose three.)
Q. The server parameter file (SPFILE) provides which three advantages when managing initialization parameters? (Choose three.) A. The Oracle server maintains the server parameter file. B. The server ... - Mark for review Examine the statement: Create synonym emp for hr.employees; What happens when you issue the statement?
Q. Mark for review Examine the statement: Create synonym emp for hr.employees; What happens when you issue the statement? A. An error is generated. B. You will have two identical tables in the ... - How to add TABLE INDEX in oracle database
How to add TABLE INDEX in oracle database ... - Mark for review Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)
Q. Mark for review Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.) A. It releases the storage space used by the table. B. It does ...
Posted in: Oracle » | By: rekha | Date: 05 Sep 2011 11:04 am | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 05 Jul 2011 11:41 am | Comments (3)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 02 May 2011 7:06 am | Comments (2)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 07 Feb 2011 6:16 am | Comments (0)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 13 Jan 2011 7:07 am | Comments (0)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 11 Jan 2011 1:17 pm | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 06 Jan 2011 6:44 am | Comments (2)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 05 Jan 2011 12:37 pm | Comments (3)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 27 Dec 2010 3:34 pm | Comments (0)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 15 Nov 2010 12:16 pm | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 13 Nov 2010 8:57 am | Comments (0)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 02 Nov 2010 5:25 am | Comments (4)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 26 Oct 2010 1:28 am | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 25 Oct 2010 7:53 am | Comments (5)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 05 Oct 2010 2:52 am | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 04 Oct 2010 11:48 am | Comments (1)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 29 Sep 2010 1:54 am | Comments (3)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 12 Sep 2010 7:13 pm | Comments (2)
Posted in: Oracle » | By: Shailesh Singh | Date: 28 Aug 2010 1:43 am | Comments (0)
Posted in: Oracle » | By: Shailesh Singh Visen | Date: 19 Aug 2010 7:01 am | Comments (1)
Tutorials | Forum | Books | Interview Questions | Transaction Codes | Institutes | Jobs | Classifieds | News | Announcements
SAP ERP Support/Consulting | RSS/Syndication | Contact Us | Terms Of Use | Terms & Conditions
SAP ERP Support/Consulting | RSS/Syndication | Contact Us | Terms Of Use | Terms & Conditions
©2005-2011 SAP Techies. All rights reserved.