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


Databases Interview Questions
Questions Answers Views Company eMail

Can you tell me how to add new column in existing views?how?How is possible?

FIS,

921

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

IBM, Saama Tech,

1 2197

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from ; except this you can't use another select statement. You can use no of variables as per requirement.

 1 1627

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

Infosys,

851

how to find 6th highest salary

Chetak Logistics,

1036

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

 1052

difference of using cursor for loop and open,fetch,close.which one is better

Accenture,

1247

What are local and global Indexes and where they are useful.

 922

how are rank and dense rank being alloted for column with same values over a particular column

 1 1413

what are sequences

 1082

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

 802

how to hide the stored procedure inside a package

 1 1239

Explain few examples of stored procedure over triggers?

ADITI,

507

What are the different types of backups that exist?

ADITI,

674

What can be used instead of trigger?

ADITI,

615

Un-Answered Questions { Databases }

How will you decide the active and passive nodes?

632

First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9

1302

Explain about reporting services of MYSQL?

606

Explain intimate shared memory(ism)

516

What is integrity in sql?

547




Is sybase sql?

454

Is the syntax correct? Explain the meaning of the syntax given below: $dbc = mysqli_connect('data.aliensabductedme.com', 'owen', 'aliensrool', 'aliendatabase');

520

How to find out what version of microsoft access I have?

444

What operating systems are supported by oracle sql developer?

511

What is primefaces used for?

549

What is a mysql model?

495

Why use update_statistics command in sql server?

544

When would you use a database?

484

What is the usage of analyze command in oracle?

603

How to count groups returned with the group by clause in oracle?

561

For More Un-Answered { Databases } Questions Click Here