Answer / Krishnanand Yadav

{"The SELECT INTO statement in SQL is used to create a new table based on the results of an existing query. It combines the data selection and table creation steps into a single statement.", "Example": "SELECT column1, column2 INTO new_table FROM old_table WHERE condition;"}

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

2 Answers  

---

What are the types of tables in database?

1 Answers  

---

Why does reading require write privileges on database file?

1 Answers  

---

Does google have a database program?

1 Answers  

---

What is considered a database?

1 Answers  

---

What is data modelling concepts?

1 Answers  

---

Can the User set Archive file name formats ?

1 Answers  

---

What do you understand by data independence?

1 Answers  

---

How do you set a primary key?

1 Answers  

---

How many types of relationship exist in database designing?

1 Answers  

---

Explain the terms database and dbms. Also, mention the different types of dbms.

1 Answers  

---

Explain, why is rdbms better than dbms?

1 Answers  

---