Databases Interview Questions
Questions Answers Views Company eMail

Can the SNAPSHOTS be refreshed automatically ?

1 3393

Can the User set Archive file name formats ?

1 5167

Which parameters are optional in init.ora parameter file?

1728

What is the use of NOARCHIEVELOG parameter in Database?

1 4685

Are Constraints exported through Export command?

1 3876

How the status of the Rollback segment can be viewed ?

1 3929

Can we assign Explicitly transaction to a rollback segment

1 4203

What file is read by ODBC to load drivers ?

Oracle,

1 8701

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 157485

How do you start and stop MySQL on Windows?

3 5926

How do you start MySQL on Linux?

3 5448

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 32575

What?s the default port for MySQL Server?

Yahoo,

4 7788

What does tee command do in MySQL?

1 7974

Can you save your connection settings to a conf file?

1 3860


Un-Answered Questions { Databases }

What is the purpose of a staging area?

1


Explain scalar functions in sql?

553


What are the characteristics of data in the database?

454


How do you delete duplicate rows in sql server?

483


What is entity and its types?

487






What is data source object?

525


What is the maximum row of a size?

548


How can we generate report output in excel format?

529


How is clustered database important in oracle rac architecture?

1


How to extract a unit value from a date and time?

473


Should I use mbr or gpt?

515


What is a mutating table and a constraining table?

547


Can multiple columns be used in sql group by clause in ms sql server?

520


What is foreign key in database?

475


Write down the differences between nosql and rdbms?

506