Student(ID, name, dept name, tot_cred)
In this query which attributes form the primary key?
Name
Dept
Tot_cred
ID
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
2
Discuss
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
3
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
4
Discuss
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
5
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
6
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
7
Discuss
|
By default, the order by clause lists items in ______ order.
Solution |
8
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
9
Discuss
|
A ________ in a table represents a relationship among a set of values.
Solution |
10
Discuss
|
This query can be replaced by which of the following ?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved