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