how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

What are different types of queries in sql?

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

how to retrieve only duplicate values in a table

9 Answers  

---

---

The select into statement is most often used to create backup copies of tables or for archiving records?

0 Answers  

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,

---

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 are the types of records?

0 Answers  

---

What is the file extension for sql database?

0 Answers  

---