A(n) ____ is an alternate name given to a column or table in any SQL statement.
ID: 3836327 • Letter: A
Question
A(n) ____ is an alternate name given to a column or table in any SQL statement.
1.
trigger
2.
stored function
3.
alias
4.
data type
The special operator used to check whether an attribute value is within a range of values is ____.
1.
IN
2.
BETWEEN
3.
LIKE
4.
NULL
Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point is
1.
float(p,d)
2.
Char(p,d)
3.
Numeric(p,d)
4.
all Above
A ____ join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values.
1.
cross
2.
left outer
3.
Full outer
4.
Natural
From a structural point of view, 2NF is better than ____.
1.
4NF
2.
1NF
3.
BCNF
4.
3NF
If attribute A determines both attributes B and C, then it is also true that:
1.
C A
2.
(B,C) A
3.
A B
4.
B A
To list all the contents of the PRODUCT table, you would use ____.
1.
Select *
from product;
2.
select all
from product;
3.
List *
from product;
4.
Display *
from product;
1.
trigger
2.
stored function
3.
alias
4.
data type
Explanation / Answer
Alias is an alternate name given to a column or table in any SQL statement
The special operator used to check whether an attribute value is within a range of values is between
Fixed point number, with user-specified precision of p digits, with n digits to the right of decimal point is
Numeric(p,d)
Cross join returns rows with matching values and includes all rows from both tables (T1 and T2) with unmatched values
From a structural point of view, 2NF is better than 3NF
If attribute A determines both attributes B and C, then it is also true that:
(B,C) A
To list all the contents of the PRODUCT table, you would use
Select *
from product;
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.