Interested to Buy Any Domain ? << Click Here >> for more details...
1. what is a single procedure? 2. suppose a view constructed on a query... after that in the master table a column was dropped, then what will be the status of that view? will it be invalid or something else? 3. what is mutating table error? how can you solve that problem? 4. suppose "select * from emp where empno=7788;" is running slow because of what ever the cause it is.. how can you fix it and make the execution faster? 5. will the snapshot of data will be stored in the RAM , where will ir be stored exactly. 6. how to delete 100 tables or 100000 tables' data from the schema without writing delete statement for no.of times. write an sql statement to do that job. 7. suppose a package contains so many cursors, procedures and all.. and we are using such types of procedures so many in a program. so the execution is to be stored all those packages and all to the RAM. utimately it is using many resources for each time execution. how can you reduce the time and using of resources for each execution because the query need to be run many times. how can you tune that? 8. suppose a procudere is there with specs as (a,b,c,d), all of these are IN mode only then while calling them should we pass all the 4 arguments? how to pass (b,c) only.. how ever the specs are wrote in the same order displayed in the above? 9. a function is returning a table type, how to access that function in a select statement? 10. i have a table in database A and another table in database B, how can you access the data of these two tables? write a query for that with dblinks. 11. i have two tables might have 15/20 columns in that.. i wanna send these columns(table) to the front end application for example you are using asp.net by writing a procedure. write that to perform the above job. 12. shall we create a table in the package? 13. shall we create a table in the procedure? 14. suppose i have 10 records, in that i want to select 7th record. write a query for that. cant you use rownum for this? 15. suppose my procedure has got around 20 select statements, in that some three select statements are running very slow. what will you write to detect which queries are running slowly? 16. what fields you use frequently in plan_table? 17. what is pipeline function? explain me with an example. 18. does a unique column can contain more than one null? 19. how many hints are there provided by oracle?
5 7884Post New Honeywell Oracle General Interview Questions
- Honeywell C Interview Questions (16)
- Honeywell OOPS Interview Questions (1)
- Honeywell C++ General Interview Questions (7)
- Honeywell MFC Interview Questions (2)
- Honeywell COM DCOM Interview Questions (1)
- Honeywell VC++ AllOther Interview Questions (2)
- Honeywell Programming Languages AllOther Interview Questions (3)
- Honeywell Tcl Interview Questions (1)
- Honeywell TCP IP Interview Questions (2)
- Honeywell Protocols AllOther Interview Questions (2)
- Honeywell Networking AllOther Interview Questions (9)
- Honeywell C Sharp Interview Questions (3)
- Honeywell ASP.NET Interview Questions (3)
- Honeywell ADO.NET Interview Questions (4)
- Honeywell IIS Interview Questions (1)
- Honeywell Dot Net Framework Interview Questions (3)
- Honeywell Dot Net AllOther Interview Questions (1) Honeywell Oracle General Interview Questions (2)
- Honeywell Oracle Architecture Interview Questions (1)
- Honeywell SQL Server Interview Questions (3)
- Honeywell SQL PLSQL Interview Questions (1)
- Honeywell Database Management Interview Questions (2)
- Honeywell Windows Threads Interview Questions (2)
- Honeywell Windows AllOther Interview Questions (6)
- Honeywell Operating Systems General Concepts Interview Questions (3)
- Honeywell Data Structures Interview Questions (5)
- Honeywell Load Runner Interview Questions (2)
- Honeywell QTP Interview Questions (2)
- Honeywell Manual Testing Interview Questions (3)
- Honeywell Test Cases Interview Questions (1)
- Honeywell Servers AllOther Interview Questions (1)
- Honeywell COBOL Interview Questions (1)
- Honeywell Core Java Interview Questions (8)
- Honeywell JDBC Interview Questions (1)
- Honeywell J2EE Interview Questions (1)
- Honeywell XML XSLT RSS Interview Questions (3)
- Honeywell Business Objects Interview Questions (2)
- Honeywell Data Warehouse General Interview Questions (1)
- Honeywell HR Questions Interview Questions (54)
- Honeywell Design Patterns Interview Questions (5)
- Honeywell Project Planning Interview Questions (1)
- Honeywell Clear Case Interview Questions (3)
- Honeywell CDMA Interview Questions (1)
- Honeywell Telecom General Interview Questions (1)
- Honeywell SAP ABAP Interview Questions (1)
- Honeywell SAP HR (Human Resource Management) Interview Questions (13)
- Honeywell SAP BW (Business Warehouse) Interview Questions (2)
- Honeywell 86 Family Interview Questions (3)
- Honeywell DSP Interview Questions (2)
- Honeywell Mechanical Engineering Interview Questions (2)
- Honeywell Electrical Engineering Interview Questions (16)
- Honeywell Electronics Communications Interview Questions (5)
- Honeywell Industrial Engineering Interview Questions (1)
- Honeywell Instrumentation Interview Questions (45)
- Honeywell Engineering AllOther Interview Questions (1)
- Honeywell Business Administration Interview Questions (1)
- Honeywell Marketing Sales Interview Questions (1)
- Honeywell Banking Finance Interview Questions (1)
- Honeywell Human Resources Interview Questions (1)
- Honeywell Business Management AllOther Interview Questions (1)
- Honeywell Accounting General Interview Questions (1)
- Honeywell Journalism Interview Questions (1)
- Honeywell Call Centre AllOther Interview Questions (1)
- Honeywell BSRB Clerical Interview Questions (1)
- Honeywell APPSC AllOther Interview Questions (1)
- Honeywell Government AllOther Interview Questions (1)
- Honeywell General Aptitude Interview Questions (3)
- Honeywell Puzzles Interview Questions (1)
- Honeywell Placement Papers Interview Questions (4)
- Honeywell Sun Certifications Interview Questions (1)
- Honeywell L1 Visa Interview Questions (1)
- Honeywell C Code Interview Questions (4)
Why do we floating DC in DC system.
What is custom controller? : salesforce visualforce
How can system release locks?
Does python have a built in function for string natural sort?
Can I use windows 7 without activation?
What are shallow and deep copy?
Write a main method that prompts the user to enter the starting population, birth and death rates, and the number of years. The input birth and death rates cannot be negative, the starting population cannot be less than 2, and the number of years greater than 0. If the user enters an invalid value, this program will prompt user to re-enter the value until a valid value has been read. When all input values are valid, call on the methods above to compute estimated population and print result.
What is a managed solution?
What configurations are stored in struts configuration file ?
Tell us what kind of problems does regularization solve?
Explain the flow of information between the 5 main layers of drupal?
What do you know about the big-o notation and can you give some examples with respect to different data structures?
What is the protocol in ios?
What is an operator?
How many kinds of nns exist?
