suppose one file is used by 100 user and file is locked by 100 user, what are the impact analysis?
1 3068suppose a job is running for 15 minutes after that it goes to message wait? what are the impact analysis
1 35411) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
CTS,
1154First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
1141- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
CTS,
1387have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
1236
What is the use of function extension ?
How do I run a script in windows 10?
What are the other modules integrated with organisational management?
Explain what is tableau?
what is the difference between a struct and a class in c#?
How is mvvm different from mvc?
What is meant by a bolt dispute?
Can you explain data mining?
What is the language manager in joomla?
Is string a primitive data type in c#?
Is hibernate better than jdbc?
What is data skew in spark?
Where we can use the synchronization?
How can you turn-on and turn-off cas?
What mysql -u john -p command does?