Question
CONSTRAINT salary VALUE test __________;
In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:
a.
Value>=30000.00
b.
Not null;
c.
Check(value >= 29000.00);
d.
Check(value)
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. CREATE DOMAIN YearlySalary NUMERIC(8,2) CONSTRAINT salary VALUE test __________; In order to ensure that an instructor’s salary domain allows only values greater than a...
Similar Questions
Discover Related MCQs
Q. In contemporary databases the top level of the hierarchy consists of ______ each of which can contain _____
View solution
Q. The database administrator who authorizes all the new users, modifies database and takes grants privilege is
View solution
Q. Which of the following is a basic form of grant statement ?
View solution
Q. Which of the following is used to access the database server at time of executing the program and get the data from the server accordingly ?
View solution
Q. Which of the following header must be included in java program to establish database connectivity using JDBC ?
View solution
Q. DriverManager.getConnection(_______ , ______ , ______)
What are the two parameters that are included ?
View solution
Q. Which of the following invokes functions in sql ?
View solution
Q. Which of the following function is used to find the column count of the particular resultset ?
View solution
Q. Which of the following is a following statement is a prepared statements ?
View solution
Q. Which of the following is used as the embedded SQL in COBOL ?
View solution
Q. Which of the following is used to distinguish the variables in SQL from the host language variables ?
View solution
Q. The update statement can be executed in host language using
View solution
Q. Which of the following is used to access large objects from a database ?
View solution
Q. Which of the following is used to input the entry and give the result in a variable in a procedure ?
View solution
Q. The format for compound statement is
View solution
Q. Repeat
sequence of statements;
__________________
end repeat
Fill in the correct option :
View solution
Q. Which of the following is the correct format for if statement ?
View solution
Q. A stored procedure in SQL is a___________
View solution
Q. Temporary stored procedures are stored in _________ database.
View solution
Q. Declare out of classroom seats condition
DECLARE exit handler FOR OUT OF classroom seats
BEGIN
SEQUENCE OF statements
END
The above statements are used for
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
Java Programming
Level up your coding skills with our Java Programming MCQs. From object-oriented...
Microprocessor
Understand the heart of your computer with our Microprocessor MCQs. Topics include...
