What is a temporal table?



What is a temporal table?..

Answer / Kavita Mishra

A temporal table in SQL is a special type of table that automatically tracks historical changes to the data. Temporal tables allow you to query both current and historical data as if it were all in the present. This can be useful for auditing, reporting, and trend analysis purposes.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are the advantages of the packages

6 Answers   Oracle,


explain advantages of myisam over innodb? : Sql dba

1 Answers  


What is the clause we need to add in function body to return variable?

1 Answers  


what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,


Enlist the data types that can be used in pl/sql?

1 Answers  


How do you remove duplicate records from a table?

1 Answers  


Can i use Commit inside the Trigger? Suppose i use commit what will be happy (it's complied /executed/work)

6 Answers  


What is rownum and rowid?

1 Answers  


How do I copy a table in sql?

1 Answers  


What is oracle pl sql developer?

1 Answers  


Why do we use sql constraints? Which constraints we can use while creating database in sql?

1 Answers  


Can we insert in view in sql?

1 Answers  


Categories