The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Select
Join
Union
Intersection
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
2
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
3
Discuss
|
_____ operator is used for appending two strings.
Solution |
4
Discuss
|
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
5
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
6
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
7
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
8
Discuss
|
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
Solution |
9
Discuss
|
This query does which of the following operation?
Solution |
10
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved