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
|
_____ operator is used for appending two strings.
Solution |
2
Discuss
|
Which one of the following is procedural language?
Solution |
3
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
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
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
6
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
7
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
8
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
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
|
This query can be replaced by which of the following ?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved