Tham khảo tài liệu 'đề thi trắc nghiệm cơ sở dữ liệu trường cao thắng- phần 5', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | TRƯỜNG CĐ KỸ THUẬTCAO THÁNG KHOA ĐT-TH HỌ VÀ TÊN sv MASV. ĐÈ KIÉM CHƯƠNG 3 MÔN Cơ SỎ Dữ LIỆU thời gian làm bài 90 phút ĐIẺM 20. Which of the following statements contains an error a SELECT FROM emp WHERE empid 493945 b SELECT empid FROM emp WHERE empid 493945 c SELECT empid FROM emp d SELECT empid WHERE empid 56949 AND lastname SMITH 21. Which of the following statements will return the names of the products with Product ID 10 11 or 42 a SELECT ProductName FROM products WHERE ProductID IN 10 11 42 b SELECT ProductName FROM products WHERE ProductID IN 10 OR 11 OR 42 c SELECT ProductName FROM products WHERE ProductID 10 11 42 d SELECT ProductName FROM products WHERE ProductID IS 10 11 42 e None of the above 22. Which of the following commands will return the list of product names sorted in ascending alphabetic order a SELECT ProductName FROM products ORDER BY ProductName DESC b SELECT ProductName FROM products ORDER BY ProductName ASC c SELECT ProductName FROM products SORTED BY ProductName ASC d SELECT ProductName FROM products SORTED BY ProductName DESC e None of the above 23. Which of the following will return a list of every product ID currently listed in the order_details table where each product ID is listed only once a SELECT DISTINCT ProductID FROM order_details b SELECT ProductID FROM order_details ONLY ONCE c SELECT ProductID FROM order_details d SELECT UNIQUE ProductID FROM order_details e None of the above 24. In the instance of the relation R A O T V U shown below which of the following functional dependencies hold A o T V u 1 2 3 4 5 1 4 3 4 5 1 2 4 4 1 a A o T V u - A b o V A V - u c T O A V - u d A o T e o - V V u - A 25. Which of the following statements contains an error
