Sql connectivity

Sql connectivity

11th - 12th Grade

6 Qs

quiz-placeholder

Similar activities

Banco de Dados

Banco de Dados

10th - 12th Grade

10 Qs

Data 278-287

Data 278-287

12th Grade

10 Qs

Deel 2 - H5 - Begrippen data en informatie

Deel 2 - H5 - Begrippen data en informatie

12th Grade

10 Qs

XII TKJ

XII TKJ

12th Grade

10 Qs

Prueba diagnóstica de Bases de Datos 2

Prueba diagnóstica de Bases de Datos 2

12th Grade

10 Qs

7.2 Introduction to Databases

7.2 Introduction to Databases

9th - 12th Grade

9 Qs

ICTDBS506 Creating a 'Car Pool' Database with MySQL

ICTDBS506 Creating a 'Car Pool' Database with MySQL

12th Grade - University

10 Qs

BPB(SQL)

BPB(SQL)

9th - 12th Grade

6 Qs

Sql connectivity

Sql connectivity

Assessment

Quiz

Computers

11th - 12th Grade

Medium

Created by

sql python

Used 6+ times

FREE Resource

6 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does SQL stand for?

Super Quantum Logic

Structured Query Language

Stylish Query Lingo

Server Query Lanuage

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

SQLite

PySQL

MySQL

PostgreSQL

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Cursor.fetchall()

Cursor.execute()

Cursor.run()

Cursor.fetchmany()

Cursor.fetchone()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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


import sqlite3


connection = sqlite3.connection("people.db")

cursor = connection.cursor()

cursor.execute("SELECT * FROM People")

results = cursor.fetchall()

QuerySet

tuple

list

dict

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Given a function that does not return any value, what value is shown when executed at the shell?

int

bool

void

none

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

which operator does pattern matching in mysql?

BETWEEN operator

EXISTS operator

LIKE operator

none