Explain some predefined exceptions.

0 Answers  

---

What is keys and its types?

0 Answers  

---

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

---

---

What is execution plan in sql?

0 Answers  

---

What is vector point function?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

Write a query to find the name of employees those who have joined on Monday.(based on column hire_date)

15 Answers   Satyam,

---

How can we link a sql database to an existing android app?

0 Answers  

---

How do I save a sql query?

0 Answers  

---

What is dml statement?

0 Answers  

---