SQL PLSQL Interview Questions
Questions Answers Views Company eMail

what is the difference between group by and order by in sql? : Sql dba

596

what are the different functions in sorting an array? : Sql dba

579

what are date and time data types in mysql? : Sql dba

495

what is 'mysqlshow'? : Sql dba

581

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

555

how to rename an existing column in a table? : Sql dba

504

explain primary keys and auto increment fields in mysql : sql dba

516

what is a constraint? Tell me about its various levels. : Sql dba

557

explain the advantages and disadvantages of stored procedure? : Sql dba

529

how to write date and time literals? : Sql dba

528

what are the types of subquery? : Sql dba

584

how do you login to mysql using unix shell? : Sql dba

561

how can we know the count/number of elements of an array? : Sql dba

568

how to include character strings in sql statements? : Sql dba

551

what is meant by urlencode and urldocode? : Sql dba

596


Post New SQL PLSQL Questions

Un-Answered Questions { SQL PLSQL }

how to drop an existing index in mysql? : Sql dba

531


What are field types?

533


Difference between truncate, delete and drop commands?

554


How does a trigger work?

531


How to fetch alternate records from a table?

675






Why do we use partitions in sql?

543


How do I filter in sql profiler?

534


What is query execution plan in sql?

563


Are subqueries faster than joins?

569


What is mutating error?

502


What do you understand by exception handling in pl/sql?

571


Define concurrency control. : Transact sql

582


What does t sql mean?

529


What is pl sql script?

560


If the application is running very slow? At what points you need to go about the database in order to improve the performance?

561