Databases Interview Questions
Questions Answers Views Company eMail

Can the SNAPSHOTS be refreshed automatically ?

1 2393

Can the User set Archive file name formats ?

1 4019

Which parameters are optional in init.ora parameter file?

1051




What is the use of NOARCHIEVELOG parameter in Database?

1 3860

Are Constraints exported through Export command?

1 2702

How the status of the Rollback segment can be viewed ?

1 2797

Can we assign Explicitly transaction to a rollback segment

1 3345

What file is read by ODBC to load drivers ?

Oracle,

1 7201

how to find nth highest salary

Cognizant, IBM, NexGen, Oracle,

103 125890

How do you start and stop MySQL on Windows?

3 3888

How do you start MySQL on Linux?

3 3488

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 27680

What?s the default port for MySQL Server?

Yahoo,

4 5260

What does tee command do in MySQL?

1 6670

Can you save your connection settings to a conf file?

1 2597







Un-Answered Questions { Databases }

what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

4854


Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

1363


which gives Oracle R12 Financial training in delhi please give me answer its urgent?

1207


i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........

724


while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

2937






What is the Maximum size for a table in PostgreSQL?

429


issues involved in modeling and building data werahouses

926


interview questions with answer for cts

1244


what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

1285


How to define a cusotmer as a supplier in ORACLE R12

1079


What is responsibility and how u attach How to create user and how u attach with responsibility.

981


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

1000


for what purpose we use MDM(master data management)tell me plz.

3018


Can you tell me how to add new column in existing views?how?How is possible?

220


If user is owning any SQL Objects, can we drop that user

906