Question

Which is NOT one of the most common types of SQL CHECK constraints?

a.

System date

b.

Range checks

c.

Lists of values

d.

Comparing one column value to another within the same table

Posted under DBMS

Answer: (a).System date

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. Which is NOT one of the most common types of SQL CHECK constraints?

Add Comment

Similar Questions

Discover Related MCQs

Q. What is an advantage of placing computations in SQL views?

View solution

Q. Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:

View solution

Q. ‘AS’ clause is used in SQL for

View solution

Q. The language which has recently become the defacto standard for interfacing application programs with relational database system is

View solution

Q. A report generator is used to

View solution

Q. Count function in SQL returns the number of

View solution

Q. The statement in SQL which allows to change the definition of a table is

View solution

Q. Which of the following is correct:

View solution

Q. Which of the following is a valid SQL type?

View solution

Q. Which of the following is an advantage of view?

View solution

Q. Which of the following is a legal expression in SQL?

View solution

Q. Which of the following is a comparison operator in SQL?

View solution

Q. Which one of the following is not true for a view:

View solution

Q. To delete a particular column in a relation the command used is:

View solution

Q. The ______ operator is used to compare a value to a list of literals values that have been specified.

View solution

Q. _____________ function divides one numeric expression by another and returns the remainder.

View solution

Q. A data manipulation command the combines the records from one or more tables is called

View solution

Q. _________ is a virtual table that draws its data from the result of an SQL SELECT statement.

View solution

Q. A table joined with itself is called

View solution

Q. _________ data type can store unstructured data.

View solution

View All MCQs on DBMS

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!

MongoDB

Learn the leading NoSQL database with our MongoDB MCQs. Understand everything from...

Compiler Design

Unravel the process of translating source code into executable programs with our...

Computer Graphics

Step into the visual side of computing with our Computer Graphics MCQs. Cover topics...

Web Technologies

Master the building blocks of the web with our Web Technologies MCQs. From HTML and...

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...

HTML

Start your journey in web development with our HTML MCQs. Learn the building blocks...

Object Oriented Programming

Enhance your coding skills with our Object Oriented Programming MCQs. Understand...

Hadoop

Dive into the world of big data with our Hadoop MCQs. Cover key concepts including...