Databases Interview Questions
Questions Answers Views Company eMail

What is a database example?

676

What is difference between data and database?

706

Is microsoft access used anymore?

544

What are the benefits of using access?

546

Where is the quick access toolbar located?

634

How do I order columns in sql?

689

How do you concatenate in sql?

708

What is having clause in sql?

702

What is sorting in sql?

652

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

634

What is sorting in dbms?

676

Can we use two order by clause in query?

724

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 ?

726

What is Collation Sensitivity ? What are the various type ?

683

How can a user get the current SQL version?

2 1106


Un-Answered Questions { Databases }

What is transaction server isolation?

730


Why is mongodb used?

1


How do you run a query?

744


How many columns can exist together per table?

855


Which statement is used in a select query for partial matching?

785






What is blob in mysql?

674


Is a primary key unique?

684


How can I introduce multiple conditions in like operator?

694


How many commands are in sql?

694


When do you analyze the tables?

1


How do I turn off marked suspect on my database in sybase?

630


How to delete an existing row with delete statements in ms sql server?

740


How to start oracle sql developer?

734


What is meant by decimal (5,2)?

708


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1775