The expected Database
@mylovelydatabase
62 subscribers
1 video
7 links
Father channel=https://t.me/Mylovelychanne
Download Telegram
About
Blog
Apps
Platform
Join
The expected Database
62 subscribers
The expected Database
https://t.me/mylovelydatabase
Telegram
The expected Database
Father channel=https://t.me/Mylovelychanne
176 views
The expected Database
For intersection of two relations they must be union compatible.
Anonymous Quiz
81%
True
19%
False
16 voters171 views
The expected Database
Forwarded from The EXPECTED CHANNEL !πŸ’‘
β€”β€”β€”β€”- is used to define the schema or structure of the database.
Anonymous Quiz
73%
DDL
18%
DML
5%
DCL
3%
none
60 voters120 views
The expected Database
Forwarded from The EXPECTED CHANNEL !πŸ’‘
β€”β€”β€”β€”- used to retrieve and update data from the database.
Anonymous Quiz
84%
DML
5%
DDL
7%
DCL
4%
none
56 voters136 views
The expected Database
The SQL USE statement is used toβ€”β€”β€”β€”β€”- any existing database in the SQL schema.
Anonymous Quiz
37%
Update
19%
Alter
19%
Create
25%
none
52 voters422 views
The expected Database
The basic syntax of the USE statement in SQL schema is
Anonymous Quiz
60%
USE DatabaseName
20%
USE Database
18%
CREATE DATABASE DatabaseName
2%
none
50 voters448 views
The expected Database
Tuples are explicitly deleted from only one table at a time.
Anonymous Quiz
76%
True
24%
False
17 voters166 views
The expected Database
Forwarded from The EXPECTED CHANNEL !πŸ’‘
SQL is primarily based on concepts from β€”β€”β€”β€”.
Anonymous Quiz
52%
Relational algebra
13%
Relational calculus
34%
Both
2%
none
64 voters147 views
The expected Database
Οƒ selection condition ( R ) from this the
relation resulting from the SELECT operation has the same attributes as R.
Anonymous Quiz
73%
TRUE
27%
FALSE
33 voters427 views
The expected Database
What is duplicate elimination?
Anonymous Quiz
42%
When the project operation removes any duplicate tuples
29%
when the selection operation removes any duplicate tuples
23%
when the project operation removes any duplicate attribute
6%
when the selection operation removes any duplicate attribute
31 voters427 views
The expected Database
Duplication of tuples is allowed in SQL.
Anonymous Quiz
35%
True
65%
False
54 voters433 views
The expected Database
When is the number of tuples in a relation R resulting from a PROJECT operation is equal to the number of tuples in R?
Anonymous Quiz
38%
If the projection list is a superkey of R
45%
it is always equal to the number of tuples in R
3%
It is always less than number of tuples in R
14%
none
29 voters462 views
The expected Database
The relation resulting from the SELECT operation has the same attributes as the original relation.
Anonymous Quiz
69%
True
31%
False
πŸ‘2
42 voters474 views
The expected Database
Which one is also called restrict or filter operation?
Anonymous Quiz
27%
Projection
5%
Rename
68%
Selection
0%
none
44 voters526 views
The expected Database
If the domain of an attribute is a set of unordered values, then which operators are used?
Anonymous Quiz
29%
β‰  and = only
20%
> and < only
31%
>= and <= only
20%
none
35 voters587 views
The expected Database
Both UNION and INTERSECTION can be treated as n-ary operations.
Anonymous Quiz
71%
True
29%
False
52 voters650 views
The expected Database
The relations on which Cartesian product is applied do not have to be union compatible.
Anonymous Quiz
59%
True
41%
False
58 voters722 views
The expected Database
The first name of SQl wasn't Structured query language.
Anonymous Quiz
65%
true
35%
false
96 voters816 views
The expected Database
https://t.me/Mylovelychanne
Telegram
The EXPECTED CHANNEL !πŸ’‘
BOT=https://t.me/TheExpectedbot

#Java
#Database=https://t.me/mylovelydatabase
#Probability=https://t.me/mylovelyexpected
and others.
#C++
#Discussion=https://t.me/mylovelycoders
300 views
The expected Database
The expected Database
https://t.me/Mylovelychanne
Join this mother channel of the expected database it is for programmers.
includes course materials,website links,java,c++ codes(You can check),exam questions.
292 views