Databases Interview Questions
Questions Answers Views Company eMail

Can you call pl/sql package functions from within a fast formula?

542

Why does %isopen return false for an implicit cursor?

1 589

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

528

what are different types of keys in sql?

584

Define overloaded procedure?

597

How do we accept inputs from user during runtime?

530

What does the acronym acid stand for in database management?

511

What is the difference among union, minus and intersect?

520

What are the differences between implicit and explicit cursors?

494

Cite the differences between execution of triggers and stored procedures?

583

What is a recursive stored procedure?

594

Define commit, rollback and savepoint?

553

How can we link a sql database to an existing android app?

532

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

642

what is error ora-03113: end-of-file on communication channel?

576


Un-Answered Questions { Databases }

How to set a transaction to be read only in oracle?

556


List different datatypes of postgresql?

384


How do I import a csv file into postgres?

478


What is metadata in mongodb?

1


How do I completely uninstall postgresql?

403






I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

1630


Differentiate between ms sql server reporting services vs crystal reports?

461


How do I start mongodb on windows?

1


How can I connect mysql database?

458


Explain in details security in SQL azure?

93


what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

1651


How to call stored procedure using http soap?

499


How do I alter a column in postgresql?

382


What is transactional replication?

537


What types of Joins are possible with Sql Server?

516