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
|
The ________ clause is used to list the attributes desired in the result of a query.
Solution |
2
Discuss
|
Using which language can a user request information from a database?
Solution |
3
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
4
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 |
5
Discuss
|
The term attribute refers to a ___________ of a table.
Solution |
6
Discuss
|
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
7
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
8
Discuss
|
This query does which of the following operation?
Solution |
9
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 |
10
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved