Database1

What does SQL stand for?

• Structured Query Language

• Server Query Lanuage

• Stylish Query Lingo

• Super Quantum Logic

What is the name of the SQL database that comes distributed with Python?

• SQLite

• PostgreSQL

• MySQL

• PySQL

Answer explanation

There are numerous SQL databases, and some are better suited to particular purposes than others. One of the simplest, most lightweight SQL databases is SQLite, which runs directly on your machine and comes bundled with Python automatically.

Which of the following code snippets creates and connects to a new SQLite Database?

• 
• 
• 
• 

Answer explanation

The sqlite3.connect() function is used to connect to, or create, a database. When you execute .connect("test_database.db"), Python searches for an existing database called "test_database.db".

If no database with that name is found, a new one is created in the current working directory. To create a database in a different directory, you must specify the full path in the argument to .connect().

Which of the following are valid Cursor methods used to execute SQL statements and retrieve query results? Select all that apply.

• Cursor.fetchall()

• Cursor.fetchone()

• Cursor.execute()

• Cursor.fetchmany()

• Cursor.run()

Answer explanation

Cursor objects are used to execute SQL statements and retrieve query results. For example, Cursor.execute() and Cursor.executescript() are used to execute SQL queries. You can retrieve query results using the Cursor.fetchone() and Cursor.fetchall() methods.

What is the type of the results variable in the following code snippet?

• tuple

• list

• dict

• QuerySet

Answer explanation

The Cursor.fetchall() method returns the results of a query as a list of tuples, where each tuple contains the data from a single row in the query results.

Which command is used to create a new database in SQLite?

• 
  CREATE DATABASE

• CREATE SCHEMA

• 
  CREATE TABLE

• CREATE DATABASE TABLE

What is a primary key in a SQLite database?

• A unique identifier for each row in a table

• 
  A foreign key in a related table

• A column that stores binary data

• 
  A special type of index for sorting data