Answer Posted / kathiravan jayachandran

In Oracle

select to_char(sysdate, 'dd/mm/yyy')as year from dual


EG:-

select ed.emp_date_of_birth,ed.first_name,ed.last_name
from emp_details ed where
to_char(ed.emp_date_of_birth,'mm')=to_char(sysdate,'mm')

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

304

---

What do you mean by the term 'normalization'?

1127

---

What are dml (data manipulation language) statements in ms sql server?

924

---

How do I view a trc file?

898

---

Can you always create a cache of a report?

156

---

Can binary strings be converted into numeric or float data types?

967

---

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1021

---

Mention the differences between substr and charindex in sql server.

983

---

How can delete duplicate records in cte in sql server?

911

---

Explain raiserror in sql server?

962

---

What is the difference between index seek vs. Index scan?

971

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

893

---

Do you know what is rank function?

1029

---

What is report server project?

134

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

1001

---