The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Join
Cartesian product
Intersection
Set difference
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
2
Discuss
|
Using which language can a user request information from a database?
Solution |
3
Discuss
|
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
4
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
5
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
6
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
7
Discuss
|
This query does which of the following operation?
Solution |
8
Discuss
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
9
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
10
Discuss
|
_____ operator is used for appending two strings.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved