Databases Interview Questions
Questions Answers Views Company eMail

Is there an object-oriented version of MySQL library functions?

1 621

What is the storage engine used for MySQL?

1 616

What is the use of ENUM in MySQL?

1 583

How to create triggers in MySQL?

1 662

What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

1 557

What is DDL in MySQL?

1 743

What is DML in MySQL?

1 581

What is DCL in MySQL?

1 713

How to save images in MySQL?

2 878

Explain GRANT command in MySQL.

1 484

What are different TEXT data types in MySQL?

1 610

What different Stored Objects are supported in MySQL?

1 680

What is MySQL Stored Procedure?

1 616

What are the features of Stored Procedures in MYSQL?

1 577

In the below example, how many String Objects are created? String s1="I am Java Expert"; String s2="I am C Expert"; String s3="I am Java Expert";

1 555


Un-Answered Questions { Databases }

What do you understand by ‘atomicity’ and ‘aggregation’?

447


What is the difference between functions and scalar functions?

563


When should I use nosql database?

544


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

634


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1696






Which tcp/ip port does sql server run?

522


How you can change the database name in SQL SERVER?

658


Where in the Oracle directory tree structure are audit traces placed?

2114


What is the difference function and stored procedure?

555


Is candidate a key?

525


How do I add a sybase driver to sql developer?

465


Do you know how to implement service broker?

531


What are the benefits of mongodb?

1


How would you remodel an existing access database?

471


What are the applications of rdbms?

472