Answer Posted / iamanocp

A table can have only 1 primary key

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.

1637

---

How can you view the errors encountered in a trigger?

1022

---

explain the difference between delete , truncate and drop commands? : Sql dba

1146

---

Does sql full backup truncate logs?

1079

---

Which data type is a composite type?

1036

---

What are the types of operators available in sql?

1125

---

what is the difference between join and union? : Sql dba

1197

---

Is clustered index a primary key?

987

---

Describe types of sql statements?

1103

---

Why left join is used in sql?

1019

---

Define tables and fields in a database

1176

---

what is a unique key ? : Sql dba

1144

---

How can you create an empty table from an existing table?

1127

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1510

---

What is write ahead logging in sql server?

1098

---