Fundamentals of Database Systems

Flashcards to help review the fundamentals of database systems, concepts, and related SQL and PL/SQL functionalities.

What is the Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row?

SQL%NOTFOUND

What clause occurs between the SELECT and FROM clauses?

INTO

What is the Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row?

SQL%NOTFOUND

What clause occurs between the SELECT and FROM clauses?

INTO

What is the memory area allocated by the Oracle server to store the SQL statement and the data that it uses known as?

CURSOR

What are automatically declared variables that allow you to evaluate what happened when a cursor was last used?

CURSOR ATTRIBUTES

What is the use of INTO clause in PL/SQL select statement to specify?

VARIABLE

What could be an error in the provided PL/SQL block that updates the salary of an employee?

QUERY RETURNS MORE THAN 1 ROW

True or False: A counter variable is an expression that returns true, false, or null.

FALSE

What is the symbol used for the assignment operator in PL/SQL?

=

What clause is used to specify variable(s) that will hold the value(s) returned from the SELECT clause?

INTO

What is the term for structures that change the logical flow of statements within a PL/SQL block?

CONTROL STRUCTURES

What is the type of loop where the statement inside must execute at least once?

BASIC LOOP

What Boolean attribute evaluates to TRUE if the most recent SQL statement returned at least one row?

SQL%FOUND

What SQL statement selects rows from one table to update and/or insert into another table?

MERGE

What type of errors cannot be used directly in PL/SQL?

DDL, DCL

What DML statements make changes to the database?

ALL THE OPTIONS

True or False: The logical operator NOT applied to a null yields NULL.

TRUE

What is a variable that allows passing a value into a procedure that can be updated within the procedure?

IN OUT

What is the type of parameter that is declared in procedure heading called?

FORMAL

In PL/SQL, the BEGIN keyword states 'this is the start of a block'. What states 'this is the start of a subprogram'?

CREATE PROCEDURE

What is the full form of the acronym OLAP?

ONLINE ANALYTICAL PROCESSING

In data warehousing, what is the purpose of the ETL process?

EXTRACT, TRANSFORM, LOAD

What is the type of ETL loading process that populates all the data warehouse tables?

INITIAL LOAD

Which data mining technique makes predictions based on patterns within data?

REGRESSION

What type of learning technique does Decision Tree represent?

SUPERVISED LEARNING

KDD stands for?

KNOWLEDGE DISCOVERY IN DATABASES

What defines an OLAP cube?

A data structure that allows fast analysis of data according to multiple dimensions.

What is the process of identifying patterns and trends in data called?

DATA MINING

In data mining, what type does Naive Bayes algorithm belong to?

CLASSIFICATION

True or False: The EVALUATION phase of CRISP-DM consists of presenting the results in a useful manner.

FALSE

What OLAP operation allows for analysis by taking one level of information for display?

SLICE

What is the acronym for Online Transaction Processing?

OLTP