Databases Interview Questions
Questions Answers Views Company eMail

For web applications from which version of Oracle is suitable?

1 3170

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

1 3012

What is mutating table?

Saama Tech,

11 52369




How to call DDL statements from pl/sql?

4 26601

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

MBT, Evosys,

4 9875

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

2 9701

what are Dynamic SQL statements?

9 16225

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

TCS,

1 8546

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

4 10717

what is constraining table?

2 9314

How pl/sql source code can be protected?

2 7180

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

TCS,

21 31611

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

2 8914

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

Sail, ICICI, Saama Tech,

7 37183

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

2077







Un-Answered Questions { Databases }

wat wil hapn if we give the both read and deny read permission to user?

976


1) Does oracle have any table which contain all the exceptions and it's code internally?

597


what is the scripts in data base?

874


Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

962


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

970






How do you Implement SSIS Packages in your Project?

869


i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1077


how to take backup bcp out for a column in table in sql server?

886


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

698


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1043


What is Tax Categories?

824


What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

747


WHAT IS ecc 6.0

827


Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?

1749


can u give guidance abt packages of plsql

851