Crowdly
Add to Chrome
Retake | Database Management Systems | Aldiyar Salkenov
Looking for Retake | Database Management Systems | Aldiyar Salkenov test answers and solutions? Browse our comprehensive collection of verified answers for Retake | Database Management Systems | Aldiyar Salkenov at moodle.astanait.edu.kz.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
What does DDL stand for?
_______only returns matched records from the tables that are being joined.
_______________function removes the longest string that contains a specific character from a string
Both 'HAVING' and 'WHERE' clauses can be used in aggregation functions
Evaluate the following SQL statement:
SELECT promo_id, promo_category
FROM promotions
WHERE promo_category = ‘Internet’ ORDER BY promo_id
UNION
SELECT promo_id, promo_category
FROM promotions
WHERE promo_category = ‘TV’
UNION
SELECT promo_id, promo_category
FROM promotions
WHERE promo_category = ‘Radio’;
Which statement is true
regarding the outcome of the above query?
To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?
Which of the following is not true about simple views?
Which of the following statement is true?
Evaluate the following query:
SELECT prod_name FROM products
WHERE prod_id IN (SELECT prod_id FROM products
WHERE prod_list_price = (SELECT MAX(prod_list_price)FROM products WHERE prod_list_price < (SELECT MAX(prod_list_price)FROM products)));
What would be the outcome of executing the above SQL statement?
Assuming GETDATE works with your engine, which of the following will tell you the number of days that have elapsed this year?