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
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
2
Discuss
|
Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a _________
Solution |
3
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
4
Discuss
|
Using which language can a user request information from a database?
Solution |
5
Discuss
|
’_____’ matches any string of ______ three characters. ’_____%’ matches any string of at ______ three characters.
Solution |
6
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
7
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 |
8
Discuss
|
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
9
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
10
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved