First round
-------------------
- Procedure
- Packages
- Views
- Virtual tables
- Can we use dcl with in function?
- Joins and few scenarios
- Triggers and its type
- Pragma, type and its functionality
- How to create db link in oracle
- Materialized view
- How to find duplicate values from table?
- Cursor and its functionality
- Write a script to display friday and its date from a entire year.
- Exception Handling
Second round
------------------------
Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
No Answer is Posted For this Question
Be the First to Post Answer
Authentication mechanisms in Sql Server ?
While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
Which is faster subquery or join?
difference between table level constraint and column level and advantages of table level constraint
What is the use of time stamp in select statement?
How can use stored procedures in sql?
What is execution plan in sql?
what is SCALAR Queries?
What are actual parameters and formal parameters?
hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews
please explain database architecture..
What is scalar data type in pl sql?
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)