can you tell what are the different set operations available in mysql? : Mysql dba

0 Answers  

---

Please suggest me any course and institute which provide training on the below skills. • Knowledge of data extraction concepts and tools • QMF (query management facility)queries • Experience and expertise in QMF queries • Excellent ability to write, read, and interpret QMF queries against the Source Data Warehouse base level (daily and monthly) and month-end affinity comp tables • RDBMS & ER • Knowledge of Relational Databases (RDBMS) and Entity Relationship (ER) Diagrams • SOURCE Data Warehouse • Experience and expertise in Source Data Warehouse or data warehouses on the mainframe. • MS SQL Server • Experience in MS SQL Server • Excellent skill in writing/interpreting SQL queries and running Data Transformation Services (DTS) or open query packages. • Knowledge of writing/interpreting Visual Basic code.

1 Answers  

---

How can you filter the duplicate data while retrieving records from the table?

0 Answers  

---

How you can create a trigger in mysql?

0 Answers  

---

How to set mysql variable in php?

0 Answers  

---

---

Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.

1 Answers  

---

What is the maximum number of records in mysql table?

0 Answers  

---

What is unsigned in mysql?

0 Answers  

---

Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command

5 Answers   Amdocs, MediaSoft,

---

What are the types of queries?

0 Answers  

---

Where’s database data actually stored?

0 Answers  

---

How do you create a primary key?

0 Answers  

---