Single-Table SQL >> Using Databases with Python
*Please Wait 15 Seconds To Get The Pdf Loaded
* Please Disable Internet Download Manager (IDM) To View This Pdf.
Structured Query Language (SQL) is used to (check all that apply)
Check Python code for errors
Create a table
Which of these is the right syntax to make a new table?
MAKE DATASET people;
CREATE TABLE people;
Which SQL command is used to insert a new row into a table?
Which command is used to retrieve all records from a table?
RETRIEVE all FROM User
SELECT all FROM Users
RETRIEVE * FROM Users
SELECT * FROM Users
Which keyword will cause the results of the query to be displayed in sorted order?
None of these
In database terminology, another word for table is
In a typical online production environment, who has direct access to the production database?
Which of the following is the database software used in this class?
What happens if a DELETE command is run on a table without a WHERE clause?
All the rows without a primary key will be deleted
All the rows in the table are deleted
It is a syntax error
The first row of the table will be deleted
Which of the following commands would update a column named “name” in a table named “Users”?
Users->name = ‘new name’ WHERE …
UPDATE Users SET name=’new name’ WHERE …
Users.name=’new name’ WHERE …
UPDATE Users (name) VALUES (‘new name’) WHERE …
What does this SQL command do?
Hint: This is not from the lecture
It is a syntax errror
It adds a COUNT column to the Users table
It counts the rows in the table Users
It only retrieves the rows of Users if there are at least two rows