adspace




Databases Interview Questions
Questions Answers Views Company eMail

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

1 1610

What is the storage engine used for MySQL?

1 1609

What is the use of ENUM in MySQL?

1 1528

How to create triggers in MySQL?

1 1741

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

1 1520

What is DDL in MySQL?

1 1653

What is DML in MySQL?

1 1430

What is DCL in MySQL?

1 1647

How to save images in MySQL?

2 2111

Explain GRANT command in MySQL.

1 1382

What are different TEXT data types in MySQL?

1 1595

What different Stored Objects are supported in MySQL?

1 1752

What is MySQL Stored Procedure?

1 1612

What are the features of Stored Procedures in MYSQL?

1 1448

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 1467


Un-Answered Questions { Databases }

Have you used lexical parameters in reports?

50


What is current version of mysql?

1087


What is a view in sql?

1050


how to use regular expression in pattern match conditions? : Sql dba

1125


What is acid mean in sql server?

1257


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1032


How to use values from other tables in update statements using oracle?

1169


Why should you use or avoid select * statements?

1123


If a cursor is open, how can we find in a pl/sql block?

1252


How can you append an identity column to a temporary table?

1079


How can I check that whether automatic statistic update is enabled or not?

1123


What are different types of constraints?

1007


What is temporary table in sql server? Why we use temp table?

1029


List out the different types of locks available in sql server?

1058


What are the steps in creating a database?

1024