Crowdly
Додати до Chrome
Retake | Database Management Systems | Aldiyar Salkenov
Шукаєте відповіді та рішення тестів для Retake | Database Management Systems | Aldiyar Salkenov? Перегляньте нашу велику колекцію перевірених відповідей для Retake | Database Management Systems | Aldiyar Salkenov в moodle.astanait.edu.kz.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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?