Databases Interview Questions
Questions Answers Views Company eMail

what is the difference between char and varchar data types? : Sql dba

526

what tools available for managing mysql server? : Sql dba

518

what are wild cards used in database for pattern matching ? : Sql dba

537

how to decrement dates by 1 in mysql? : Sql dba

574

how to convert dates to character strings? : Sql dba

529

how is exception handling handled in mysql? : Sql dba

538

what is transaction? : Sql dba

521

how to create a new table by selecting rows from another table in mysql? : Sql dba

550

explain normalization concept? : Sql dba

574

differentiate between float and double. : Sql dba

549

how to enter characters as hex numbers? : Sql dba

559

what are the drivers in mysql? : Sql dba

543

how to get a list of indexes of an existing table? : Sql dba

504

what is subquery? : Sql dba

562

what is an extent ? : Sql dba

574


Un-Answered Questions { Databases }

Explain what are the different index configurations a table can have?

681


If we use sum function in mysql, does it return sum of that row or for that column?

520


What is a field in a table?

568


Explain the use of owner option in exp command.

560


What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

3973






Write SQL queries on Self Join and Inner Join.

600


Name some usages of database trigger?

550


can an order by clause be used in a creation of a view?

682


What is over () in sql?

517


how many ways we can we find the current date using mysql? : Sql dba

603


Can you load data into multiple tables at once? : aql loader

593


Is a database a file?

517


How to estimate disk space needed for an export job?

550


What are the basic features of ms access?

409


What is the purpose of the grep command?

273