Question
CREATE TABLE Manager(ID NUMERIC,Name VARCHAR(20),budget NUMERIC,Details VARCHAR(30));a.
Check(budget>0)
b.
Check(budget<0)
c.
Alter(budget>0)
d.
Alter(budget<0)
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. Inorder to ensure that the value of budget is non-negative which of the following should be used?
Similar Questions
Discover Related MCQs
Q. Domain constraints, functional dependency and referential integrity are special forms of _________
View solution
Q. Create index studentID_index on student(ID);
Here which one denotes the relation for which index is created ?
View solution
Q. Values of one type can be converted to another domain using which of the following ?
View solution
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 specified value use:
View solution
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
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!
