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
|
A relational database consists of a collection of
Solution |
2
Discuss
|
Which one of the following is procedural language?
Solution |
3
Discuss
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
4
Discuss
|
A ________ in a table represents a relationship among a set of values.
Solution |
5
Discuss
|
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
6
Discuss
|
Using which language can a user request information from a database?
Solution |
7
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
8
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
9
Discuss
|
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Solution |
10
Discuss
|
This query does which of the following operation?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved