Some questions about DATABASE 1.In a bank, all of the following are examples of
ID: 3726709 • Letter: S
Question
Some questions about DATABASE
1.In a bank, all of the following are examples of end users EXCEPT a
bank manager
database administrator
teller
loan administrator
2.Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = [1558-QW1]
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = (1558-QW1)
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE <'1558-QW1';
SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE = {1558-QW1}
3.user, Adam, wants to use stored functions in the database to compute values. Which two statements identify
the properties of a stored function? (Choose two.)
A stored function may or may not return a value.
A stored function can enhance the efficiency of a query.
A stored function cannot provide parallel query execution.
A stored function can only be called from a SQL expression.
A stored function can modify character strings to represent special data types.
4.Relational views are used for all the following reasons EXCEPT
they allow users customized access to data
they can hide portions of the database from users
they can contain calculated data
they provide more efficient access to records
A.bank manager
B.database administrator
C.teller
D.loan administrator
Explanation / Answer
1.In a bank, all of the following are examples of end users EXCEPT a
Ans: B. database administrator
2.Which query will output the table contents when the value of the character field P_CODE is alphabetically less than 1558-QW1?
Ans: c. SELECT P_CODE, P_DESCRIPT, P_QOH, P_MIN, P_PRICE
FROM PRODUCT
WHERE P_CODE <'1558-QW1';
3.user, Adam, wants to use stored functions in the database to compute values. Which two statements identify the properties of a stored function?
Ans: a. A stored function may or may not return a value.
d. A stored function can only be called from a SQL expression.
4.Relational views are used for all the following reasons EXCEPT
Ans: D. they provide more efficient access to records
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.