Databases Interview Questions
Questions Answers Views Company eMail

What is a database example?

522

What is difference between data and database?

536

Is microsoft access used anymore?

423

What are the benefits of using access?

400

Where is the quick access toolbar located?

419

How do I order columns in sql?

502

How do you concatenate in sql?

529

What is having clause in sql?

502

What is sorting in sql?

480

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

433

What is sorting in dbms?

492

Can we use two order by clause in query?

523

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 ?

514

What is Collation Sensitivity ? What are the various type ?

474

How can a user get the current SQL version?

2 755


Un-Answered Questions { Databases }

Why we use trigger in sql server with example?

490


What is dba in sql? : SQL DBA

511


What is left inner join in sql?

490


How would you create a report using the report tool and report wizard?

450


How to connect html form to mysql database using php?

467






How does distributed database work?

511


What do you mean by a replica set in mongodb?

1


How can you determine if an index needs to be dropped and rebuilt?

288


Is redis in memory database?

521


What is open database communication (odbc)?

550


What is dynamic schema in mongodb?

5


How to assign data of the deleted row to variables?

558


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

510


What are the types of keys?

492


Which constraints we can use while creating database in sql?

585