Databases Interview Questions
Questions Answers Views Company eMail

why sql is used as interpreter frequently rather than a compile?

1 4701

i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

HCL,

1746

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1898

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

L&T,

8 14220

After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?

Cognizant,

1607

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1920

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

Sapient,

2 4542

I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 3204

I have a reference table called 1. of 2 fields called 1.BadgeGroups(BG)and 1.Badges(B)like BG G aa 10 aa 11 bb 12 bb 13 bb 14 Using MS Design View Table 2 has 3 fields called 2.name, 2.badgegroup and 2.group In Table 2 called 2. they calls Table 1 for 2 fields BUT with the second field 2.badges, I want the combo box only to display the 1.badges where 2.badgegroup = 1.badgegroup The current select I have is for Table Data View Row Source is: 2.badgegroup is filled from a Combo box using Select Distinct etc from Table 1. Tried different syntax's but still lost, looking for some help SELECT 1.[BadgeGroup], 1.Badge FROM 1. WHERE 1.[BadgeGroup]=Me.2.BadgeGroup); I can populate 2.badgegroup with a

1945

how to create an user in oracle 10g.please give me an example..

1 3972

please explain about oracle

1 2967

What are wait events. Describe the wait event tables.

CTS,

1 6411

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 11172

how we can find nth max salary from an employe table by using my sql?

8 11211

what are the tools used for oracle 10g in real time.

IBM,

1902


Un-Answered Questions { Databases }

Explain table queries and select queries. What are the main differences between the two?

423


What will be the maximum number of indexes per table?

509


what are the different kinds of indexing?

485


Enlist the advantages of dbms.

546


How do you create a table in microsoft access?

356






What is oracle open database communication (odbc)?

536


What is difference between group by and order by clause?

521


Does ms access use sql?

418


What is tee command in mysql?

465


Can multiple columns be used in group by in oracle?

525


What is the role of tester in discovery(in Checklist)?

1438


What is field with example?

492


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1960


what are the new features introduced in sql server 2000? : Sql server database administration

526


What do you mean by SQL injection attack?

592