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')

What is the maximum rows in sql server table?

876

---

What is the largest component inside a field?

1065

---

Is it possible to update the views? If yes, how, if not, why?

985

---

Describe in brief databases and sql server databases architecture.

963

---

Scalability, Availability, Integration with internet, etc.)?

2844

---

Where are full-text indexes stored?

959

---

Determine when an index is appropriate?

1033

---

what type of index will get created after executing the above statement? : Sql server database administration

939

---

Explain primary key?

920

---

What is resource governor in sql server?

960

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

936

---

What are synonyms?

926

---

What is spatial and temporal data?

946

---

why would you use sql agent? : Sql server database administration

1143

---

What are the types of dml?

948

---