Database-Management-System
August 29, 2024Database-Management-System
August 29, 2024Database-Management-System
| Question 689 |
With SQL, how can you return the number of records in the “person’s” table?
| SELECT COUNT (*) FROM persons | |
| SELECT COUNT () FROM persons | |
| SELECT COLUMN () FROM persons | |
| SELECT COLUMN (*) FROM Persons |
Question 689 Explanation:
→ Normally we want print all records from database, we use SQL command is SELECT * from filename.
→ Suppose we want to return the number of records, it means count total number of records from relation(or table).
SELECT COUNT(*) FROM persons
→ Suppose we want to return the number of records, it means count total number of records from relation(or table).
SELECT COUNT(*) FROM persons
Correct Answer: A
Question 689 Explanation:
→ Normally we want print all records from database, we use SQL command is SELECT * from filename.
→ Suppose we want to return the number of records, it means count total number of records from relation(or table).
SELECT COUNT(*) FROM persons
→ Suppose we want to return the number of records, it means count total number of records from relation(or table).
SELECT COUNT(*) FROM persons