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

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 7379

Hi Guys, I have a situation where I need to access the column values from rowtype variable. However, the column names are dynamic. below is sample code: declare Cursor c1 is select * from emp; Cursor c2 is select column_name from xyztable; v_c2 c2%rowtype; v_str varchar2 v_value varchar2(200); begin for rec in c1 loop open c2;---this cursor has column names like EMPLOYEE_ID, FIRST_NAME, LAST_NAME etc. loop fetch c2 into v_c2; exit when c2%notfound; /* now lets say i want to access value of LAST_NAME from cursor c1, so I am writing below code, however it does not work as expected */ v_str:= 'rec.'|| v_c2.column_name; -- this will give me string like "rec.EMPLOYEE_ID" v_value:=v_str; end loop; end loop; end; / Plz help ASAP.Thanks.

2 3601

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

TCS,

1 3364

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

TCS,

2 4042

difference between SQL and C

Indus Software Technologies,

1 3508

Why fastload support to empty table?

CTS,

1697

Teradata: How can we know the indexed column in a table?

CTS, HSBC,

1894

how to overcome kernel isssues

Fortune,

1629

how to restore particular schema from rman full backup?

HCL,

1758

user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?

HCL,

1 3098

what is logical system in sap basis

1643

how to solve cardinality in dbms...many to many ralationships

1705

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

Access Info,

1453

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

Alshaya,

1 3294

How to display all Friday's in a year with date?

Flipkart,

4 7615

Un-Answered Questions { Databases }

What is tuple in sql?

1086

What is a deterministic function?

1073

How to load data through external tables?

1140

Where the sql database files are stored?

1021

Is mongodb encrypted?

What are sub reports?

203

How to create new databases with "create database" statements?

1026

What are the advantages dts has over bcp?

1002

Can you explain pdq priority?

167

Why should we go for stored procedures? Why not direct queries?

1103

What are the different set operators available in sql?

1027

How do I create a mysql username and password?

901

Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

996

What is a static data dictionary in oracle?

1115

Can sql servers linked to other servers?

1049

For More Un-Answered { Databases } Questions Click Here