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


Databases Interview Questions
Questions Answers Views Company eMail

Can Multiple instances be run on Single Machine???

 3 4955

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

IntraLogic, Oracle,

1790

How to create LOV in Oracle forms?

Accenture, Polaris,

2 31963

When we give SELECT * FROM EMP; How does oracle respond?

Accenture, HCL, Infosys,

24 50418

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

 2 11984

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 5786

what is inline command?

 2 8525

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 3058

What are the default Oracle triggers??

CGI, Tech Mahindra,

3 17249

How many index keys possible for a table

 6 10731

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 60722

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,

1807

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

 3 13276

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

 19 25605

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

Leo Technologies, Mannar Company, Synechron,

15 28361

Un-Answered Questions { Databases }

What is the difference between translate and replace?

560

Which are the different types of indexes in sql?

563

Does sql full backup truncate logs?

533

What is mysqli_free_result?

509

How is data stored in dbms?

528




What are distinctive joins find as a part of sql?

560

What is delimiter $$?

502

Sql technical questions

779

Explain candidate key, alternate key, and composite key?

592

Does windows server 2016 come with sql server?

504

How to do replication of firebird databases?

495

What is sql keyword?

567

How do I restart sql?

527

How extra digits are handled with numeric data type literals?

523

How do I set ts role in order to run certain dbccs?

443

For More Un-Answered { Databases } Questions Click Here