1. Categories >> Software >> Databases
  2. Suggest New Category


Databases Interview Questions
Questions Answers Views Company eMail

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

 1 4726

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,

1762

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

 1917

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

L&T,

8 14311

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

Cognizant,

1629

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

 1943

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 4574

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 3234

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

1966

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

 1 4020

please explain about oracle

1 2992

What are wait events. Describe the wait event tables.

CTS,

1 6442

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

 1 11195

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

 8 11275

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

IBM,

1926

Un-Answered Questions { Databases }

What are the 5 major parts of a database system?

473

Explain ranking functions?

603

What do you understand by intension and extension?

489

your distribution database is full what will u do

1676

What is an example of a schema?

439




How you can add messages to the nt event log from within a stored procedure?

563

What is the difference between local and global temporary table?

542

List the data types available in mssql?

516

What is scalar user-defined function?

540

What are two types of data in a database environment?

438

What happens if the constraint name is left out of a constraint clause?

272

Does truncate need commit?

509

what are the different ways to return the rowcount of a table?

569

I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?

618

How can you delete databases in neo4j?

1

For More Un-Answered { Databases } Questions Click Here