Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Here the dept_name attribute appears in both the relations. Here using common attributes in relation schema is one way of relating ___________ relations.
Attributes of common
Tuple of common
Tuple of distinct
Attributes of distinct
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
2
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
3
Discuss
|
_____ operator is used for appending two strings.
Solution |
4
Discuss
|
By default, the order by clause lists items in ______ order.
Solution |
5
Discuss
|
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Solution |
6
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
7
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
8
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
9
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
10
Discuss
|
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved