Coursera | Using Databases with Python

Single-Table SQL

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^VqE

Question 1

Structured Query Language (SQL) is used to (check all that apply)

1 point
 

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?

1 point
 

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?

1 point
 

INSERT ROW

INSERT AFTER

ADD ROW

INSERT INTO

 

Question 4

Which command is used to retrieve all records from a table?

1 point
 

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?

1 point
 

GROUP BY

ORDER BY

WHERE

None of these

 

Question 6

In database terminology, another word for table is

1 point
 

field

attribute

relation

row

 

Question 7

In a typical online production environment, who has direct access to the production database?

1 point
 

Developer

UI/UX Designer

Project Manager

Database Administrator

 

Question 8

Which of the following is the database software used in this class?

1 point
 

Postgres

MySQL

Oracle

SQL Server

SQLite

 

Question 9

What happens if a DELETE command is run on a table without a WHERE clause?

1 point
 

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”?

1 point
 

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

1 point
 

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

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *