What are temporal data types in Oracle ? - Oracle provides following temporal data types: Date Data Type – Different formats of Dates TimeStamp Data Type – Different formats of Time Stamp Interval Data Type – Interval between dates and time

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: What are temporal data types in Oracle ?

Answer: Oracle provides following temporal data types:

Date Data Type – Different formats of Dates
TimeStamp Data Type – Different formats of Time Stamp
Interval Data Type – Interval between dates and time

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 6506 users
Added on	5/11/2016
Views	70331
Rate it!

Question: What are temporal data types in Oracle ?

Answer:

Oracle provides following temporal data types:

Date Data Type – Different formats of Dates
TimeStamp Data Type – Different formats of Time Stamp
Interval Data Type – Interval between dates and time Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	What is a sub query and what are the different types of subqueries?	View Answer
	What is the use of Aggregate functions in Oracle?	View Answer
	What is USING Clause and give example?	View Answer
	What is BLOB datatype?	View Answer
	With SQL, how can you return the number of records in the ‘Persons’ table? a) SELECT COLUMNS () FROM Persons b) SELECT COLUMNS () FROM Persons c) SELECT COUNTS () FROM Persons d) SELECT COUNTS () FROM Persons	View Answer
	What is difference between using cursor variable(Ref cursor) and collections(like record with associative array)	View Answer
	Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each?	View Answer
	Explain the difference between a data block, an extent and a segment?	View Answer
	What is the function of redo log?	View Answer
	What is a redo log?	View Answer
	What are the characteristics of data files?	View Answer
	What is a datafile?	View Answer
	How to define data block size?	View Answer
	What is data block?	View Answer
	What is Restricted Mode of Instance Startup ?	View Answer
	What are the different modes of mounting a Database with the Parallel Server ?	View Answer
	What are the steps involved in Database Startup ?	View Answer
	What is Current record attribute property?	View Answer
	What is OLE automation ?	View Answer
	What are savepoint mode and cursor mode properties?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode