Databases Interview Questions
Questions Answers Views Company eMail

What is a database example?

536

What is difference between data and database?

552

Is microsoft access used anymore?

433

What are the benefits of using access?

411

Where is the quick access toolbar located?

441

How do I order columns in sql?

525

How do you concatenate in sql?

548

What is having clause in sql?

527

What is sorting in sql?

503

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

463

What is sorting in dbms?

508

Can we use two order by clause in query?

543

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 ?

534

What is Collation Sensitivity ? What are the various type ?

499

How can a user get the current SQL version?

2 794


Un-Answered Questions { Databases }

How do I start sql server 2017?

528


What is a tns service name?

532


What is sharded database?

507


Explain architecture of sql server notification services?

622


Is there an example how to configure externalfileaccess setting in firebird.conf?

470






What’s the use of custom fields in report?

567


How can we find out which auto increment was assigned on Last insert?

624


explain detail about ftp in datastage?

1810


How do you concatenate strings in mysql?

525


Can variables be used in sql statements?

550


With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

2056


What is in place upgrade in sql server?

520


What is difference between cte and view?

524


Explain the different types of constraints?

518


Do you know sql server 2008 backup compression?

564