If an UNIQUE KEY constraint on DATE column is created, will
it accept duplicate values?
- 2 Answers
- 3937 Views
- I also Faced
- E-Mail Answers
Answer Posted / orawhiz
no
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
What is database connection pool size?
What are cursors give different types of cursors?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
What is data sparsity and how it effect on aggregation?
What are the six database objects?
i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in
What do you understand by data independence?
Name the different data models that are available for database systems.
What is the difference between star flake and snow flake schema?
Briefly describe the three types of sql commands.
What is the importance of query in database?
What are functions in database?
What is the main purpose of a database?
