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