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.
Gknit1Pr^VqEQuestion 1
Structured Query Language (SQL) is used to (check all that apply)
Check Python code for errors
Delete data
Create a table
Insert data
Question 2
Which of these is the right syntax to make a new table?
MAKE DATASET people;
CREATE TABLE people;
MAKE people;
CREATE people;
Question 3
Which SQL command is used to insert a new row into a table?
INSERT ROW
INSERT AFTER
ADD ROW
INSERT INTO
Question 4
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
Question 5
Which keyword will cause the results of the query to be displayed in sorted order?
GROUP BY
ORDER BY
WHERE
None of these
Question 6
In database terminology, another word for table is
field
attribute
relation
row
Question 7
In a typical online production environment, who has direct access to the production database?
Developer
UI/UX Designer
Project Manager
Database Administrator
Question 8
Which of the following is the database software used in this class?
Postgres
MySQL
Oracle
SQL Server
SQLite
Question 9
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
Question 10
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 …
Question 11
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
