Which assertion about the following queries is true? SELECT COUNT(DISTINCT mgr), MAX(DISTINCT salary) FROM emp; SELECT COUNT(mgr), MAX(salary) FROM emp; Select one: O a. They will always return the same numbers in columns 1 and 2 O b. They will always return the same number in column 1 but may return different numbers in column 2 O c. They may return different numbers in column 1 but will always return the same number in column 2. O d. They may return different numbers in column 1 and may return different numbers in column 2

Which assertion about the following queries is true? SELECT COUNT(DISTINCT mgr), MAX(DISTINCT salary) FROM emp; SELECT COUNT(mgr), MAX(salary) FROM emp; Select one: O a. They will always return the same numbers in columns 1 and 2 O b. They will always return the same number in column 1 but may return different numbers in column 2 O c. They may return different numbers in column 1 but will always return the same number in column 2. O d. They may return different numbers in column 1 and may return different numbers in column 2

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

accessing and modifying data in a relational database with a computer programming language
Computer Science Do a research on the Internet and Explain the OOP features of PHP (approx 200 words)
Define data, information, and database.
Computer science Emerging Practices Characteristics
Differentiate between research methodology and research method with examples
Explain the concept of object-oriented programming (OOP) and its benefits in software design and development.
Differentiate between research methodology and research methodology, referring to the many types of research as methods and techniques (e.g., library research, field research, and laboratory research).
Data refers to the format in which data is stored, processed, and transferred.
Research techniques (such as library research, field research, and laboratory research) are distinct from research methodology.
Library Management Software Application Requirements Document
Explain the principles of object-oriented system design and provide examples of object-oriented design patterns.
large scale database