Chapter 6, Problem 1MC

Which of the following dictionary functions does not return a view in Python? A. get() B. keys() C.values() D.items() Which one ?

Which database operation reads table block directly a) Index scan b) Binary search c) Table scan d) Fan out

To access sequences, which files?

Program should follow in term (Contacts Database) Study the books.sql script provided in the ch17 examples folder's sql subfolder. Save the script as addressbook.sql and modify it to create a single table named contacts. The table should contain an auto-incremented id column and text columns for a person's first name, last name and phone number. make a Python script demonstrating: 1. insert contacts into the database, 2. query the database to list all the contacts and contacts with specific last name, 3. update a contact and 4. delete a contact. books.sql code: import panda as pdimport sqlite3connection = sqlite3.connect('books.db')pd.options.display.max_columns = 10pd.read_sql("SELECT * FROM  authors",connection) df = pd.read_sql( "SELECT * FROM  authors",connection)DROP TABLE IF EXISTS author_ISBN;DROP TABLE IF EXISTS titles;DROP TABLE IF EXISTS authors;CREATE TABLE authors (    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,    first TEXT NOT NULL,    last TEXT NOT NULL);CREATE TABLE…

Which type of database stores information in tables composed of rows and columns? a. columnar b. relational c. sorted d. tabular

import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection():     """     Create a connection to in-memory database     :return: Connection object     """     try:         conn = sqlite3.connect(":memory:")         return conn     except Error as e:         print(e)     # YOUR CODE HERE     # Use sqlite3.connect(":memory:") to create connection object     return conn # query to create the table table_sql = """ CREATE TABLE Horses (     id integer PRIMARY KEY NOT NULL,     name text,     breed text,     height real,     birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…

108. ____________ is a special type of stored procedure that is automatically invoked whenever the data in the table is modified. a. Procedure b. Trigger c. Curser d. None of the Mentioned

The combination of rows and columns in Microsoft Access are also called _______ a. Database b. Records c. Fields d. Tables

If the current record is the ninth record in a dataset that contains 10 records, which of the following statements will position the record pointer on the tenth record?a. TblEmployBindingSource.Position = 9b. TblEmployBindingSource.Position += 1c. TblEmployBindingSource.MoveLast()d. all of the above