Databases Interview Questions
Questions Answers Views Company eMail

What is a database example?

534

What is difference between data and database?

550

Is microsoft access used anymore?

429

What are the benefits of using access?

407

Where is the quick access toolbar located?

436

How do I order columns in sql?

522

How do you concatenate in sql?

544

What is having clause in sql?

520

What is sorting in sql?

496

Which sql statement is used to delete data from a database?

455

What is sorting in dbms?

504

Can we use two order by clause in query?

539

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

528

What is Collation Sensitivity ? What are the various type ?

493

How can a user get the current SQL version?

2 777


Un-Answered Questions { Databases }

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


Tell me the phases a transaction has to undergo?

543


What is mysqladmin flush hosts?

495


Explain 4nf?

510


What is a left inner join?

529






How many file formats are supported to export data?

649


How many triggers are possible in mysql?

501


How to execute a stored program unit?

576


how we will Show selected records sorted in an ascending (asc) or descending (desc).

537


How do sql triggers work?

546


What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4006


How does a self join work?

508


How do you update sql?

515


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

720


what method you can use to reduce the overhead of Reporting Services data sources?

147