Databases Interview Questions
Questions Answers Views Company eMail

For web applications from which version of Oracle is suitable?

1 3286

What are the main diff. between oracle 7.3 and oracle 8i?

1 3123

What is mutating table?

Saama Tech,

11 53145




How to call DDL statements from pl/sql?

4 27047

How to perform a loop through all tables in pl/sql?

MBT, Evosys,

4 10295

How to maintain the history of code changes of pl/sql?

2 10043

what are Dynamic SQL statements?

9 16617

Does it possible to pass object (or) table as an argument to a remote procedure?

TCS,

1 8942

What is pl/sql and what is it used for?

4 10961

what is constraining table?

2 9685

How pl/sql source code can be protected?

2 7395

What is the result, when NULL is compared with NULL?

TCS,

21 32508

What can be a size of a pl/sql block? Is there any limit?

2 9148

what are %TYPE and %ROWTYPE? what is the difference?

Sail, ICICI, Saama Tech,

7 37924

How to set the time zone for MySQL to particular country time?

2121







Un-Answered Questions { Databases }

How do you Implement SSIS Packages in your Project?

914


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

3097


i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

796


can we delete autodiff back up that we have set through sql server agent.

1173


What is a private synonym?

444






what is semphore explian it?

1415


Explain the Normalized Relations?

1665


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping

764


did u received a single file or multiple files

996


What is a Built_in subprogram ?

2775


which backup strategy you are following at ur company

1080


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2852


8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

903


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

1782


I have a few records all are same structures data, I want to store data in multiple targets how

1505