yo

In MySQL, a column has a SET type with 16 possible elements. How many bytes does each column value require?

2

Which of the following database programming techniques is commonly used with object-oriented programming languages?

API

Refer to the stored procedure. What is the correct call syntax to get the number of classes taught by Maggie Wilson with ID - 45631 through a stored procedure call from the command line? CREATE PROCEDURE TeacherClassLoad(IN teachID INT, OUT numberOfClasses INT) SELECT COUNT(*) INTO numberOfClasses FROM Class WHERE TeacherID = teachID;

CALL TeacherClassLoad(45631, @numberofClasses)

Which of the following is an example of database programming?

Creating a web application using Java and SQL

The _____ keyword helps the compiler identify embedded SQL statements in a program.

EXEC SQL

Which of the following required keywords specifies if the trigger will affect all rows of the table?

FOR EACH ROW

Which statements should replace XXX and YYY to execute the SELECT statement when the teacherID value is valid? CREATE PROCEDURE TeacherClassLoad(IN teachID INT) BEGIN DECLARE numberOfClasses INT; XXX SELECT COUNT(*) INTO numberOfClasses FROM Class WHERE TeacherID = teachID; YYY; END;

IF teachID IS NOT NULL THEN, END IF

Elements of the _____ type can be repeated and are not ordered.

MULTISET

Which of the following database programming techniques is an extension of the SQL language that is typically used for database applications?

Procedural SQL

Which statement should replace XXX? CREATE FUNCTION GetTeacherID(teacherLastName VARCHAR(20)) RETURNS INT XXX BEGIN DECLARE t_id INT; SELECT TeacherID INTO t_id FROM Teacher WHERE LastName = teacherLastName; END;

READS SQL DATA

_____ is an ISO standard that extends procedural SQL for use in stored procedures.

SQL/PSM

Why would mysql.connector.connect() throw an exception in a Connector/Python program?

The function was called with a username that does not have access to the database.

Which document type is commonly used by document databases?

XML

An object-relational database is _____.

an object-oriented programming language with database capabilities such as transaction management

What is a characteristic of hash structure in a key-value database?

buckets are stored on different machines, enabling horizontal scaling

When a key-value database allows multiple values per key, how is each value identified?

by using a name for each value

In Oracle Database, the object type _____.

can define either an individual column or an entire table

The PosgreSQL ARRAY type is an example of a _____ type.

collection

In an object-programming language, a class is like a _____, and an object is like a database _____.

composite type, row

A/An _____ will retrieve rows from a query that has multiple rows in the result set.

cursor

In a Connector/Python program, the _____ method prevents _____, which is a type of attack that causes a program to execute malicious SQL statements.

cursor.execute(), SQL injection

Which of the following Connector/Python cursor properties returns the number of items affected by a query?

cursor.rowcount

_____ allows a programmer to create an SQL query with a PREPARE statement at run-time.

dynamic SQL

What is the difference between the ENUM type and the SET type?

each ENUM value has exactly one element, each SET value can have many elements.

Database queries are commonly implemented using a declarative programming language because of which two main reasons?

easier programming and faster execution

Which of the following does NOT appear in the Oracle Database's CREATE TYPE statement below? CREATE TYPE NameType AS OBJECT ( ... )

function body

Programming languages fall into either _____ or _____ paradigms.

imperative, declarative

One goal of object-relational database technology is to _____.

simplify database programming

Given the Oracle Database statement below, what is PlaceType? CREATE TYPE HomeType UNDER PlaceType ( Bedrooms INT, Bathrooms INT, OVERRIDING MEMBER FUNCTION SquareFeet RETURN INT );

supertype

Strict consistency is enforced in some document databases by directing read queries to _____.

the primary replica

In order to run a program with Embedded SQL, the compiler _____

translates the SQL code to the host language first, and then to an executable program

A big data application generates 20,000 data entries per second. This rate is called what?

velocity

To fulfill data processing requirements in a growing transactional database, _____ scales up by increasing processing power of a limited number of systems.

vertical scaling