Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between column level constraints and
table level constraints?
- 14 Answers
- 87510 Views
- IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / nilesh
Column level constraints are applicable to that column
only, whereas table level conatraints are used to define
composite keys like primary key for the combination of two
or more columns in a table
| Is This Answer Correct ? | 201 Yes | 35 No |
Post New Answer View All Answers
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Difference between hot backup vs. Cold backup?
is there a tool to trace queries, like profiler for sql server?
what is Single Byte Overhead...?
How to omit columns with default values in insert statement in oracle?
What is a table index?
Explain the difference between sql and oracle?
What are a query and state the different types of queries and their uses?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How to execute a stored program unit?
master table and child table performances and comparisons in Oracle ?
What is the difference between hot backup and cold backup in oracle?
How to use subqueries with the in operator using oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
