Please help solve SQL database review questions _____ With SQL, how can you retu

Question

Please help solve SQL database review questions

_____ With SQL, how can you return the number of records in the "Persons" table? A. SELECT COUNT(*) FROM Persons B. SELCET COLUMNS() FROM Persons C. SELECT COLUMNS (*) FROM Persons D. SELECT COUNTO FROM Persons The CREATE TABLE statement is used to A. change existing database table B. create a new database C. create a new database table Which of the following about ALTER TABLE is true? A. The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints. B. The SQL ALTER TABLE clause is used to insert data into database table. C. THE SQL ALTER TABLE deletes data from database table. D. The SQL ALTER TABLE clause is used to delete a database table. A view is which of the following? A. A virtual table that can be accessed via SQL commands B. A virtual table that cannot be accessed via SQL commands C. A base table that can be accessed via SQL commands D. A base table that cannot be accessed via SQL commands The command to eliminate table CUSTOMER from a database is: A. REMOVE TABLE CUSTOMER; B. DROP TABLE CUSTOMER; C. DELETE TABLE CUSTOMER D. UPDATE TABLE CUSTOMER; Which of the following do you need to consider when you make a table in SQL? A. Data types B. Primary keys C. Default values D. All of the above. Which SQL command is used to remove a column from a table? A. DELETE FROM B. REMOVE COLUMN C. DROP TABLE D. ALTER TABLE

Explanation / Answer

34

the answer is option A

35.

option C create a new data base table

36.

option A

37.

Option A

38.

Drop table Customer can be used as drop command ios used to delete the table from the database

39.

All of the above

40.

Alter table can be used as it is used for modifying the table

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.