Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


If an unique key constraint on DATE column is created, will
it validate the rows that are inserted with SYSDATE?

Answers were Sorted based on User's Feedback



If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / kangana

uNIQUE CONSTARINT CAN VALIDATE PSEUDOCLOUMN SYSDATE

SYSDATE FORMAT IS LIKE 3/2/2010 8:42:46 PM

SO FOR EACH MILLISECOND IF U INSER A ROW IT WILL TAKE THE
INSERTION BUT IF U INSERT IN EACH FRACTION OF MILLISECOND
ITS VALIDATE AND UNIQUE CONSTARINT IS VOILATED.

Is This Answer Correct ?    10 Yes 0 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / nagendra

Yes, it will validate the rows that are inserted with sysdate

Is This Answer Correct ?    9 Yes 3 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / zikku

No Date column can not validate the rows that are inserted
with sysdate.

Is This Answer Correct ?    5 Yes 3 No

If an unique key constraint on DATE column is created, will it validate the rows that are inserted..

Answer / chandrasekar ramasamy

No B'coz the sysdate contains date and time format

Is This Answer Correct ?    5 Yes 3 No

Post New Answer



More SQL PLSQL Interview Questions

What is rtm stands for?

0 Answers  


what are properties of a transaction? : Sql dba

0 Answers  


Can a key be both primary and foreign?

0 Answers  


Why we use pl sql?

0 Answers  


How is debugging done?

0 Answers  






what is 'force view'?

3 Answers   Cap Gemini, SPIC,


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

0 Answers  


Is sql similar to python?

0 Answers  


write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,


What are different categories of sql commands?

0 Answers  


Are stored procedures compiled?

0 Answers  


Describe different types of general function used in sql?

0 Answers  






Categories