Register

#DBMS #SQL Define Check Constraint in SQL

390 views

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · SpoolingNext → · waiting time
← Previous in category · relational calculusNext in category → · No. of tables for ER...
Position:
Show:

Related questions

0 0 votes
1 1 answer
1.0k
1.0k views
iarnav asked Dec 4, 2017
1,045 views
#DBMS SQL QUERY
Consider the table employee(empId, name, department, salary) and the two queries Q1,below. Assuming that department 5 has more than one employee, and we want to find the ...
1 1 vote
1 answers 1 answer
1.2k
1.2k views
tishhaagrawal asked Dec 16, 2023
1,207 views
MadeEasy Test Series: How many tuples will be present in the output of the following SQL query.
My doubt here is, if NOT EXISTS gets an empty set as the input then every tuple of the table in the outer query must satisfy the condition. Am I right?For example, in the...
0 0 votes
0 0 answers
1.2k
1.2k views
Nirmal Gaur asked Sep 15, 2018
1,244 views
SQL query with NOT IN connective.
a) 0 b) 1 c) 2 d) 3
0 0 votes
0 0 answers
426
426 views
Asutosh asked Jul 7, 2018
426 views
#DBMS #SQL
For the relations:A(pid, cid)B(pid, pname, powner)C(cid, cname, cdesciption)How will the query be executed :SELECT pname, cname FROM A, B, CWHERE B.powner = $somevalueAND...