Answer / Keshaw Kant Tiwari

Database Management System (DBMS) is a software application used to create, maintain, and manage digital information stored in a database. It provides an interface for users to interact with the database, offering features like data definition, manipulation, and security.

Give the order of sql select?

1 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

What types of commands can be executed in sql*plus?

1 Answers  

---

display your age in months?

2 Answers  

---

What is application trigger?

1 Answers  

---

How to display the current date in sql?

1 Answers  

---

Do ddl statements need commit?

1 Answers  

---

Is truncate ddl or dml?

1 Answers  

---

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,

---

Is left join same as inner join?

1 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

Give the structure of the procedure ?

1 Answers  

---