Which system table contains information on constraints on all the tables created? - Ans: yes, USER_CONSTRAINTS, system table contains information on constraints on all the tables created

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

DATABASE

SQL

DETAILS

Question: Which system table contains information on constraints on all the tables created?

Answer: Ans:

yes,

USER_CONSTRAINTS,

system table contains information on constraints on all the tables created

Category	SQL Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.3) By 7493 users
Added on	7/25/2011
Views	72503
Rate it!

Question: Which system table contains information on constraints on all the tables created?

Answer:

Ans:

yes,

USER_CONSTRAINTS,

system table contains information on constraints on all the tables created

Source: CoolInterview.com

user_cons_columns table consists the information of the table name,column name ,constraint name
user_constraints contains information about table name, constraint type,constraint name e.t.c Source: CoolInterview.com

Answered by: praneeth | Date: 12/29/2008 |

Contact praneeth

USER_CONSTRAINTS

SELECT CONSTRAINT_NAME FROM USER_CONSTRAINTS Source: CoolInterview.com

Answered by: kiran | Date: 8/16/2010 |

Contact kiran

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
	Which command displays the SQL command in the SQL buffer, and then executes it	View Answer
	What does the following query do	View Answer
	What will be the output of the following query	View Answer
	TRUNCATE TABLE EMP; DELETE FROM EMP; Will the outputs of the above two commands differ	View Answer
	What is the difference between Single row sub-Query and Scalar sub-Query	View Answer
	How do I write a cron which will run a SQL query and mail the results to a group?	View Answer
	Is there any query which is used to find the case sensitivity in each records in database through visual basic?	View Answer
	I have a table with duplicate names in it. Write me a query which returns only duplicate rows with number of times they are repeated.	View Answer
	How to copy sql table.	View Answer
	Difference between Store Procedure and Trigger	View Answer
	Cursor Syntax brief history	View Answer
	Explain normalization with examples.	View Answer
	How to find out the database name from SQL*PLUS command prompt?	View Answer
	How can we backup the sql files & what is SAP?	View Answer
	Whats the back end processes when we type "Select * from Table"?	- SQL Interview Questions & Answers"> View Answer
	What is the difference between SQL and SQL Server?	View Answer
	What is table space	View Answer
	What is diffrence between Co-related sub query and nested sub query??	View Answer
	There is a eno & gender in a table. Eno has primary key and gender has a check constraints for the values 'M' and 'F'. While inserting the data into the table M was misspelled as F and F as M. What is the update statement to replace F with M and M with F?	View Answer
	When we give SELECT * FROM EMP; How does oracle respond:	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 SQL Interview Questions & Answers - Exam Mode / Learning Mode