Databases Interview Questions
Questions Answers Views Company eMail

Where the procedures are stored in database?

484

Explain about the implementation of stored procedures?

518

Does storing of data in stored procedures increase the access time? Explain?

809

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

413

How can we call stored procedures inside store procedures?

489

State about the security aspects of stored procedures?

555

Explain the benefits of running stored procedure on a database engine?

570

How one call ddl statement using stored procedures in oracle?

451

State the different extensions for stored procedures?

470

How many types of stored procedure?

488

What is the difference between "is" and "as" while creating procedure?

434

What is the difference between stored procedures and stored functions in oracle?

461

How you can import data from other sources into access database?

511

Explain how we can do multi-join query in ms access?

518

Between different data’s, what are the types of relationship can be formed?

611


Un-Answered Questions { Databases }

What are the types of Generic profiles types in ODI?

438


Does google use sql?

506


Point out the difference between user tables and data dictionary?

536


Can you put an access database on sharepoint?

387


Can you pass expressions to function parameters?

532






Is mysql a dbms?

483


Can you force a query to use a specific index?

525


How many sql databases can you have on one server?

588


Does aws have mongodb?

1


query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp

1635


Write the command to remove all players named sachin from the players table.

729


What is the server name in sql server?

553


Is mongodb still popular?

1


Write command to import an mysql file?

507


How do I connect to a sybase database?

452