Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Table 1: STUDIES PNAME (VARCHAR), SPLACE (VARCHAR), COURSE (VARCHAR), CCOST (NUMBER) Table 2: SOFTWARE PNAME (VARCHAR), TITLE (VARCHAR), DEVIN (VARCHAR), SCOST (NUMBER), DCOST (NUMBER), SOLD (NUMBER) Table 3: PROGRAMMER PNAME (VARCHAR), DOB (DATE), DOJ (DATE), SEX (CHAR), PROF1 (VARCHAR), PROF2 (VARCHAR), SAL (NUMBER) PNAME – Programmer Name, SPLACE – Study Place, CCOST – Course Cost, DEVIN – Language the software or package is developed in, SCOST – Software Cost, DCOST – Development Cost, PROF1 – Proficiency 1 Use the above table definitions to answer the questions that follow. Find out the selling cost average for packages developed in Oracle. Display the names, ages and experiences of all programmers How much revenue has been earned through

Azri Solutions,

1 6661

what is inline command?

2 9845

in a master-master replication with two masters and alternate slaves running on two systems.can i have a script or any mysql command to know which one is right now acting as master.

1 3866

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 19559

How many index keys possible for a table

6 12833

What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....

DELL, i Tech, Infosys, Siemens, TCS,

9 64228

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

eicc,

1 2413

pls explain connect by prior with example and its real time use

3 14713

wat will be the sql query to extract only last 3 records from table supose table hving thousands for records

19 30661

How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table?

Leo Technologies, Mannar Company, Synechron,

15 33331

Un-Answered Questions { Databases }

What is self contained sub query?

1138

What is current version of mysql?

1071

How to put more than 1000 values into an oracle in clause?

1110

Explain system functions or built-in functions? What are different types of system functions?

1060

Can you index views?

953

what is the age limit for groups1 examination

2337

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1293

How can I check that whether automatic statistic update is enabled or not?

1108

Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com

1896

How raid can influence database performance?

1114

How to convert character strings into numeric values?

1186

What are the properties of the transaction?

1069

Why and when do stored procedure recompile?

1053

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2176

Is primary key clustered index?

1016

For More Un-Answered { Databases } Questions Click Here