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

Answer Posted / chandrasekar ramasamy

No B'coz the sysdate contains date and time format

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Should I use mbr or gpt?

727


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

998


What is the difference between cluster and non-cluster index?

803


what does myisamchk do? : Sql dba

741


What is a database event trigger?

797






what is a foreign key ? : Sql dba

785


What are different clauses used in sql?

812


How do you explain an index?

986


Can instead of triggers be used to fire once for each statement on a view?

710


How to add new employee details in an employee_details table with the following details

821


What are all types of user defined functions?

736


How show all rows in sql?

797


Can we use views in stored procedure?

703


How much does sql cost?

733


Is mariadb nosql?

765