Databases Interview Questions
Questions Answers Views Company eMail

Can the SNAPSHOTS be refreshed automatically ?

1 2443

Can the User set Archive file name formats ?

1 4071

Which parameters are optional in init.ora parameter file?

1088




What is the use of NOARCHIEVELOG parameter in Database?

1 3898

Are Constraints exported through Export command?

1 2748

How the status of the Rollback segment can be viewed ?

1 2857

Can we assign Explicitly transaction to a rollback segment

1 3391

What file is read by ODBC to load drivers ?

Oracle,

1 7349

how to find nth highest salary

IBM, Oracle, Cognizant, NexGen,

103 126800

How do you start and stop MySQL on Windows?

3 3987

How do you start MySQL on Linux?

3 3559

Explain the difference between mysql and mysqli interfaces in PHP?

TCS,

10 27851

What?s the default port for MySQL Server?

Yahoo,

4 5365

What does tee command do in MySQL?

1 6736

Can you save your connection settings to a conf file?

1 2654







Un-Answered Questions { Databases }

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

827


Is the After report trigger fired if the report execution fails ?

1642


where the dff data will be stored

1152


can u combine pipeline parallelism and partition parallalism? how and whan?

1257


what happened to the global index when I truncate the data in one of the partition?

897






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?

1428


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1084


First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

647


I HAVE A PI ON COL A THE NEXT DAY I WANT CHANGE THE PI ON COL B? PLS SEND ME THE ANS

1485


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

959


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?

708


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

1490


Is it possible to split the print reviewer into more than one region ?

1155


Why do you want to join software field as you have done your BE in Electronics?

1105


During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

341