HP Interview -2016
Unix
1) grep command in unix
2) what is set command
2)
select length('HELLO')- length(replace('HELLO','L',''))
FROM
dual;
| Is This Answer Correct ? | 3 Yes | 3 No |
1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....
What is an implicit commit?
What is pivot query?
what is schema? : Sql dba
What is the difference between cross join and natural join?
Mention what are the benefits of pl/sql packages?
What is difference between stored function and application function?
what is a trigger? : Sql dba
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
Is sql port 1433 encrypted?
What is pl sql block in dbms?
What is difference between cursor and trigger?
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)