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 6636

what is inline command?

2 9808

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 3841

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 19507

How many index keys possible for a table

6 12764

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 64116

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,

2390

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

3 14675

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

19 30447

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

Leo Technologies, Mannar Company, Synechron,

15 33101

Un-Answered Questions { Databases }

How do you store pictures in a database?

1064

How do I start sql server 2017?

993

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2204

What is the best database management system?

1047

What is merge in oracle?

1106

Can we use the cursor's to create the collection in PL/SQL?

1105

What are the different Authentication modes in SQL Server and how can you change authentication mode?

1136

What can be used instead of trigger?

1213

Is sql a rdbms?

869

Explain the architecture of reporting services?

1041

Explain transaction server auto commit?

1092

What do you know about mongodb?

How to round a numeric value to a specific precision?

1126

What are the restrictions applicable while creating views?

1001

What is write ahead logging in postgresql?

925

For More Un-Answered { Databases } Questions Click Here