Bissoy.com
Doctors Medicines MCQs Q&A

___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.

___________ defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. Correct Answer Constraint

SQL constraints are used to specify rules for the data in a table.If there is any violation between the constraint and the data action, the action is aborted by the constraint.

Related Questions

A company recruits candidates satisfying the following criteria -  1. Candidates who secured at least 85% in standard 10th or equivalent. 2. Candidates who secured at least 65% in standard 12th or equivalent. 3. Candidates who are not from commerce background. Who among the following candidates will the company definitely select? A. Jitesh is a science student having scored 70% in standard 12th and 80% in 10th with an excellent sports background. B. Jignesh scored 80% in standard 12th, 90% in standard 10th and secured 2nd place in his college among all commerce students. C. Jayesh scored 75% in standard 10th, 75% in standard 12th and is an arts student. D. Jinesh secured 80% in standard 12th, 88% in standard 10th and is a science student with great acting skills
Compare the following sentences: (1) He is a man of high professional integrity. (2) Our defense forces are determined to preserve our national Integrity. (3) His personal integrity is beyond question. Identify sentence (s) in which the word integrity implies the quality of honesty and strong moral principles.
Match the following with respect to RDBMS: A. Entity integrity 1. enforces some specific business rule that do not fall into entity or domain B. Domain integrity 2. Rows can’t be deleted which are used by other records C. Referential integrity 3. enforces valid entries for a column D. User defined integrity 4. No duplicate rows in a table
You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?
The given table shows the number of students and their class. Division A students are scholars who get a 25% rebate in fees. In addition, all girls students get 40% subsidy. If the fee per student a year WITHOUT rebate or subsidy is Rs. 10,000, then find the total fees collected from the students of these 6 classes for that year. Division  /Standard  Boys Girls Division A /Standard 9 20 40 Division B /Standard 9 40 35 Division C /Standard 10 20 20 Division A /Standard 10 40 20 Division B /Standard 10 20 40 Division C /Standard 10 20 15
Refer the below data table and answer the following Question : Division/Standard Boys Girls Division A/Standard 5 20 30 Division B/Standard 5 15 20 Division C/Standard 5 30 10 Division A/Standard 6 30 25 Division B/Standard 6 30 25 Division C/Standard 6 30 20   What is the ratio of Boy’s to Girl’s? 
You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
In the following passage some of the words have been left out. Read the passage carefully and select the correct answer for the given blank out of thefour alternatives. _____________ nearly eight decades, the women's movement __________ and debated the desirability and feasibility of a Uniform Civil Code,and has ended up ___________ a simple question — what is the value of uniformity? Is it for the "integrity of the nation" that uniformity in lawsis required, as some judicial pronouncements ___________? If so, who exactly is the beneficiary? Which sections of people benefit from"integrity of the nation", that abstract entity which is not exactly _______ the top of your mind as your husband throws you out on the street? and has ended up ___________ a simple question — what is the value of uniformity?
Which Section of the Specific Relief Act, 1963, provides that the 'specific relief to be granted only for enforcing civil rights' and not for enforcing penal laws:
Match the following Types of mechanism Motion achieved P. Scott Russel mechanism 1. Intermittent motion Q. Geneva mechanism 2. Quick return motion R. Off set slider crank mechanism 3. Simple harmonic motion S. scotch Yoke mechanism 4. Straight line motion