Answer Posted / anil_abbireddy
DDL :data definition language
DML :data manuplation language
DCL :data control language
TCL :transaction control language
SCL :session control language
| Is This Answer Correct ? | 22 Yes | 15 No |
Post New Answer View All Answers
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.
How can I speed up sql query?
Explain what is a column in a table?
What is ttitle and btitle?
Is there a way to automate sql execution from the command-line, batch job or shell script?
what are myisam tables? : Sql dba
What are the different schemas objects that can be created using pl/sql?
What are the two types of cursors in pl sql?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
Can we use pl sql in sql server?
Can you join a table to itself?
What is crud stand for?
What is a common use of group by in sql?
What are stored procedures in mysql?
Which join is default?