Single-Table SQL

11?試題

1.?

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

Delete data

Check Python code for errors

Create a table

Insert data

2.?

Which of these is the right syntax to make a new table?

MAKE DATASET people;

MAKE people;

CREATE TABLE people;

CREATE people;

3.?

Which SQL command is used to insert a new row into a table?

INSERT INTO

ADD ROW

INSERT ROW

INSERT AFTER

4.?

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

RETRIEVE * FROM Users

RETRIEVE all FROM User

SELECT all FROM Users

SELECT * FROM Users

5.?

Which keyword will cause the results of the query to be displayed in sorted order?

GROUP BY

ORDER BY

WHERE

None of these

6.?

In database terminology, another word for table is

relation

attribute

field

row

7.?

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

Developer

UI/UX Designer

Project Manager

Database Administrator

8.?

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

SQLite

SQL Server

Oracle

MySQL

Postgres

9.?

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

The first row of the table will be deleted

All the rows in the table are deleted

All the rows without a primary key will be deleted

It is a syntax error

10.?

Which of the following commands would update a column named "name" in a table named "Users"?

UPDATE Users (name) VALUES ('new name') WHERE ...

Users->name = 'new name' WHERE ...

Users.name='new name' WHERE ...

UPDATE Users SET name='new name' WHERE ...

11.?

What does this SQL command do?

SELECT COUNT(*) FROM Users

Hint: This is not from the lecture

It only retrieves the rows of Users if there are at least two rows

It is a syntax errror

It counts the rows in the table Users

It adds a COUNT column to the Users table

總結

以上是生活随笔為你收集整理的Coursera课程Python for everyone：Quiz: Single-Table SQL的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。