CSIS304 Chapters 7-9 - Flashcards

question

MySQL allows multiple triggering conditions per trigger.

answer

False

question

Every PL/SQL block must be given a name.

answer

False

question

To test a trigger, one should use the EXECUTE TRIGGER command.

answer

False

question

The Oracle equivalent to an MS Access AutoNumber is a(n) _____. 1) auto-number 2) sequence 3) TO_NUMBER function 4) trigger

answer

sequence

question

_____ is a cursor attribute that returns TRUE if the last FETCH returned a row, and FALSE if not. 1) %ROWCOUNT 2) %NOTFOUND 3) %FOUND 4) %ISOPEN

answer

%FOUND

question

The _____ operator could be used in place of INTERSECT if the DBMS does not support it. 1) IN 2) OF 3) AND 4) UNION

answer

IN

question

The statement SELECT * FROM T1, T2 produces a(n) _____ join. 1) cross 2) natural 3) equi-

answer

natural

question

To remedy the lack of procedural functionality in SQL, and to provide some standardization within the many vendor offerings, the SQL-99 standard defined the use of persistent stored modules. 1) True 2) False

answer

True

question

SQL supports the conditional execution of procedures (IF-THEN-ELSE statements) that are typically supported by a programming language.

answer

False

question

A row-level trigger is assumed if we omit the FOR EACH ROW keywords and a statement-level trigger required the use of the FOR EACH ROW keyword.

answer

False

question

_____ is a relational set operator. 1) MINUS 2) PLUS 3) ALL 4) EXISTS

answer

MINUS

question

Cursors are held in a reserved memory area in the client computer.

answer

False

question

A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values. 1) outer 2) inner 4) cross

answer

cross

question

A stored function is another name for a stored procedure. 1) True 2) False

answer

False

question

Just like database triggers, stored procedures are stored in the database. 1) True 2) False

answer

True

question

In Oracle, you can use the SQL*Plus command SHOW ERRORS to help you diagnose errors found in PL/SQL blocks. 1) True 2) False

answer

True

question

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables. 1) True 2) False

answer

False

question

In subquery terminology, the first query in the SQL statement is known as the _____ query. 1) outer 2) lefT 3) inner 4) base

answer

outer

question

A relational join operation merges rows from two tables. 1) True 2) False

answer

True

question

Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator? 1) 7 2) 10 3) 15 4) 17

answer

17

question

One of the disadvantages of stored procedures is that they increase network traffic. 1) True 2) False

answer

False

question

A statement-level trigger is assumed if a designer omits the FOR EACH ROW keywords. 1) True 2) False

answer

True

question

Oracle recommends _____ for creating audit logs. 1) triggers 2) stored procedures 3) stored functions 4) tables

answer

triggers

question

Assume you are using the MINUS operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the MINUS operator? 1) 0 2) 2 3) 8 4) 10

answer

8

question

The _____ statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second. 1) UNION 2) UNION ALL 3) INTERSECT 4) MINUS

answer

MINUS

question

Cursor-style processing involves retrieving data from the cursor, one row at a time. 1) True 2) False

answer

True

question

When using the Oracle TO_DATE function, the code _____ represents a three-letter month name. 1) MON 2) MM3 3) MONTH 4) MM

answer

MON

question

One of the major advantages of stored procedures is that they can be used to encapsulate and represent business transactions. 1) True 2) False

answer

True

question

The Oracle string concatenation function is _____. 1) CONCAT 2) + 3) || 4) &&

answer

||

question

An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value. 1) True 2) False

answer

True

question

A _____ is a query inside a query. 1) subquery 2) range query 3) join 4) set query

answer

subquery

question

The first step in developing the conceptual model using ER diagrams is to ____. -normalize the entities -complete the initial ER diagram -identify, analyze, and refine the business rules -define the attributes, primary keys, and foreign keys for each of the entities

answer

identify, analyze, and refine the business rules

question

The primary objective of database design is ____. to create the most efficient database possible to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models to create the fastest queries to be able to add data quickly

answer

to create complete, normalized, nonredundant, and fully integrated conceptual, logical, and physical database models

question

The ANSI prescribes a standard SQL-the current fully approved version is known as SQL-07. True False

answer

False

question

The conceptual design step that determines end-user views, outputs, and transaction-processing requirements is ____. data analysis and requirements entity relationship modeling and normalization data model verification distributed database design

answer

data analysis and requirements

question

The testing and evaluation phase occurs after applications programming. True False

answer

False

question

The existing hardware and software systems are studied during the planning phase. True False

answer

False

question

"Linked SQL" is a term used to refer to SQL statements that are contained within an application programming language such as COBOL, C++, ASP, Java, or ColdFusion. True False

answer

False

question

Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes. True False

answer

False

question

The ANSI SQL standards are also accepted by the ISO. True False

answer

True

question

The ____ function returns the current system date in MS Access. TO_DATE() SYSDATE() DATE() TODAY()

answer

DATE()

question

The COMMIT command does not permanently save all changes. In order to do that, you must use SAVE.

answer

False

question

A trigger is procedural SQL code that is automatically invoked by the RDBMS upon the occurrence of a given data manipulation event. True False

answer

True

question

The result of analysis should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

answer

True

question

Automating business procedures and automatically maintaining data integrity and consistency are trivial in a modern business environment.

answer

False

question

The query to join the P_DESCRIPT and P_PRICE fields from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE, and V_CONTACT fields from the VENDOR table where the values of V_CODE match is ____. SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE VENDOR.V_CODE; SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE; SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE VENDOR.V_CODE;

answer

SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;

question

UNION, INTERSECT, and MINUS work properly only if relations are union-compatible, which means that the names of the relation attributes and their data types must be different. True False

answer

False

question

The ____ design is the process of selecting the data storage and data access characteristics of the database. time network logical physical

answer

physical

question

In the detailed systems design phase, steps are laid out for conversion from the old system to the new system. True False

answer

True

question

After testing is concluded, end-user training is not necessary.

answer

False

question

The special operator used to check for similar character strings is ____. BETWEEN IS NULL LIKE IN

answer

LIKE

question

The COUNT function is designed to tally the number of non-null "values" of an attribute, and is often used in conjunction with the DISTINCT clause. True False

answer

True

question

All SQL commands must be issued on a single line. True False

answer

False

question

There are ____ stages in the DBLC. four five six seven

answer

six

question

Installing the DBMS, creating the database, and loading or converting the data are part of the ____ phase of the DBLC. database initial study database design implementation and loading testing and evaluation

answer

implementation and loading

question

Database performance is one of the least important factors in all database implementations.

answer

False

question

The logical systems design is created during the ____ phase of the SDLC. planning analysis implementation maintenance

answer

analysis

question

The SQL command that modifies an attribute's values in one or more table's rows is ____. INSERT SELECT COMMIT UPDATE

answer

COMMIT

question

In the detailed systems design phase, the designer starts the design of the system's processes True False

answer

False

question

Because every request for structural changes requires retracing the SDLC steps, the system is always at some stage of the SDLC.

answer

True

question

The detailed systems design phase includes all the necessary technical specifications for the screens, menus, reports, and other devices used to make the system more efficient.

answer

True

question

The ____ command is used with the ALTER TABLE command to modify the table by deleting a column. DROP REMOVE DELETE ERASE

answer

DROP

question

The special operator used to check whether a subquery returns any rows is ____. BETWEEN EXISTS LIKE IN

answer

EXISTS

question

Although SQL commands can be grouped together on a single line, complex command sequences are best shown on separate lines, with space between the SQL command and the command's components.

answer

True

question

String comparisons are made from left to right. True False

answer

True

question

SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT. True False

answer

True

question

SQL requires the use of the ADD command to enter data into a table.

answer

False

question

Each statement inside the PL/SQL code must end with a period ("."). True False

answer

False

question

In subquery terminology, the first query in the SQL statement is known as the ____ query. outer left inner base

answer

outer

question

The SQL aggregate function that gives the total of all values for a selected attribute in a given column is ____. COUNT MIN MAX SUM

answer

SUM

question

The NEXT command for a cursor is used to retrieve a row from the cursor and place it in the respective PL/SQL variables. True False

answer

False

question

The SQL aggregate function that gives the number of rows containing non-null values for the given column is ____. COUNT MIN MAX SUM

answer

COUNT

question

The ANSI standard defines ____ type(s) of outer join(s) one two three four

answer

three

question

Cursor-style processing involves retrieving data from the cursor, one row at a time. True False

answer

True

question

____ coupling describes the extent to which modules are independent of one another. Verification Process Module Cohesive

answer

Module

question

PL/SQL blocks have a section used to declare variables. True False

answer

True

question

In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.

answer

True

question

The SQL aggregate function that gives the average for the specific column is ____. COUNT AVG MAX SUM

answer

AVG

question

The traditional SDLC is divided into ____ phases. two three four five

answer

five

question

A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server. PSM PLS SQL Statement PMR

answer

PSM

question

A database language enables the user to perform complex queries designed to transform the raw data into useful information. True False

answer

True

question

Problems defined during the planning phase are examined in greater detail during the analysis phase. True False

answer

True

question

To join tables, simply enumerate the tables in the FROM clause of the SELECT statement. The DBMS will create a Cartesian product of every table in the FROM clause. To get the correct results, you need to select the rows in which the common attribute values do not match. True False

answer

False

question

During the testing phase, the system is subjected to exhaustive testing until it is ready for use. True False

answer

False

question

Database designs that fail to recognize that the database is part of a larger information system are not likely to be successful. True False

answer

True

question

In Oracle, ____ make(s) it possible to merge SQL and traditional programming constructs, such as variables, conditional processing (IF-THEN-ELSE), basic loops (FOR and WHILE loops,) and error trapping. triggers indexes embedded SQL procedural SQL

answer

procedural SQL

question

A statement-level trigger is assumed if you omit the FOR EACH ROW keywords. True False

answer

True

question

Stored procedures must have at least one argument. True False

answer

False

question

The ____ query combines rows from two queries and excludes duplicates. UNION UNION ALL INTERSECT MINUS

answer

UNION

question

During decentralized design, after the ____ process has been completed, all modules are integrated into one conceptual model. initial verification conceptual logical

answer

verification

question

The SQL character data format(s) is(are) ____. CHAR and VARCHAR VARCHAR only Alphanumeric CHAR only

answer

CHAR and VARCHAR

question

"Union-compatible" means that the ____. names of the relation attributes can be different, but the data types must be alike names of the relation attributes must be the same, but the data types can be different names of the relation attributes must be the same and their data types must be alike number of attributes must be the same, but the names and data types can be different

answer

names of the relation attributes must be the same and their data types must be alike

question

Assume you are using the INTERSECT operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the INTERSECT operator? 0 2 7 10

answer

2

question

The ____ special operator is used to check whether an attribute value is null. BETWEEN IS NULL LIKE IN

answer

IS NULL

question

Triggers can only be used to update table values True False

answer

False

question

Systems analysis is used to determine the need for an information system and to establish its limits. True False

answer

True

question

Physical design becomes simpler when data is distributed at different locations. True False

answer

False

question

Date procedures are often more software-specific than other SQL procedures. True False

answer

True

question

The conceptual design step that identifies ER modules and validates insert, update, and delete rules is ____. database analysis and requirements ER modeling and normalization data-model verification distributed database design

answer

data-model verification

question

The first step in the DBLC is ____. operation database initial study database design implementation and loading

answer

database initial study

question

The ANSI SQL standards are also accepted by the ISO.

answer

True

question

Entity integrity is enforced automatically when the primary key is specified in the CREATE TABLE command sequence.

answer

True

question

A database language enables the user to create database and table structures to perform basic data management chores.

answer

True

question

When a user issues the DELETE FROM tablename command without specifying a WHERE condition, _____. 1) no rows will be deleted 2) the first row will be deleted 3) the last row will be deleted 4) all rows will be deleted

answer

all rows will be deleted

question

Mathematical operators cannot be used to place restrictions on character-based attributes.

answer

False

question

When joining three or more tables, you need to specify a join condition for one pair of tables.

answer

False

question

The _____ constraint assigns a value to an attribute when a new row is added to a table. 1) CHECK 2) UNIQUE 3) NOT NULL 4) DEFAULT

answer

DEFAULT

question

The conditional LIKE must be used in conjunction with wildcard characters.

answer

True

question

An alias is especially useful when a table must be joined to itself in a ___ query.

answer

recursive

question

A system maintenance activity generated in response to changes in the business environment is referred to as corrective maintenance.

answer

False

question

Analyzing the company situation is part of the _____ phase of the Database Life Cycle (DBLC). 1) database initial study 2) database design 3) testing, and evaluation 4) operation

answer

database initial study

question

The implementation phase of database design includes creating the database storage structure and loading the database, but does not provide for data management.

answer

False

question

The assignment of access rights may restrict operations on predetermined objects such as databases, tables, views, queries, and reports.

answer

True

question

The term "database development" is used to describe the process of database design and implementation

answer

True

question

The database contents are loaded during the _____ phase of the Systems Development Life Cycle (SDLC). 1) analysis 2) detailed systems design 3) implementation 4) maintenance

answer

implementation

question

_____ is a technique that creates logical representations of computing resources that are independent of the underlying physical computing resources. 1) Normalization 2) Virtualization 3) Specialization 4) Generalization

answer

Virtualization

question

After the initial declarations in Database Life Cycle (DBLC), the database designer must carefully probe in order to generate additional information that will help define the problem within the larger framework of company operations. 1) True 2) False

answer

True

question

Coding, testing, and debugging are part of the _____ phase of the Systems Development Life Cycle (SDLC). 1) planning 2) analysis 3) detailed systems design 4) implementation

answer

implementation (not sure)

question

The analysis phase of the Systems Development Life Cycle (SDLC) involves a cycle of coding, testing, and debugging. 1) True 2) False

answer

False

question

The process of creating an information system is known as _____. 1) systems development 2) database development 3) network development 4) enterprise development

answer

systems development

question

The database initial study phase of the Database Life Cycle (DBLC) involves _____. 1) defining objectives 2) introducing changes 3) testing the database 4) installing the DBMS

answer

defining objectives

question

The traditional Systems Development Life Cycle (SDLC) is divided into _____ phases. 1) two 2) three 3) four 4) five

answer

five (not sure)

question

Decentralized design is typical of relatively simple, small databases and can be successfully done by a single person.

answer

False

question

In DBLC, the phase after the database initial study is _____. 1) operation 2) database design 3) database initial study 4) implementation and loading

answer

database design

question

"What are the requirements of the current system's end users?" is a question asked during the _____ phase of the Systems Development Life Cycle (SDLC). 1) planning 2) analysis 3) implementation 4) maintenance

answer

analysis

question

Discovery of user requirements, existing system evaluation, and logical system design are part of the _____ phase of the Systems Development Life Cycle (SDLC). 1) planning 2) analysis 3) detailed systems design 4) implementation

answer

analysis

question

The design of the system's processes is completed during the _____ phase of the Systems Development Life Cycle (SDLC). 1) planning 2) analysis 3) detailed systems design 4) implementation

answer

detailed systems design

question

In the context of the database design process, the conceptual design step that identifies ER modules and validates insert, update, and delete rules is _____. 1) database analysis and requirements 2) ER modeling and normalization 3) data model verification 4) distributed database design

answer

data model verification

question

"Should the existing system be replaced?" is a question that is asked during the _____ stage of the Systems Development Life Cycle (SDLC). 1) planning 2) analysis 3) implementation 4) maintenance

answer

maintenance

question

In the detailed systems design phase of the Systems Development Life Cycle (SDLC), steps are laid out for the conversion of a database from an old system to a new system.

answer

True

question

_____ can render data useless to unauthorized users who might have violated some of the database security layers. 1) Data encryption 2) Access rights 3) Physical security 4) Password security

answer

Data encryption

question

The main purpose of a backup is to guarantee database restoration following a hardware or software failure.

answer

True

question

Data integrity is enforced by the database management system (DBMS) through the proper use of primary and foreign key rules.

answer

True

question

The Systems Development Life Cycle's (SDLC's) planning phase yields a general overview of the company and its objectives.

answer

True

question

A system is always at some stage of SDLC because every request for structural changes requires retracing the steps of the Systems Development Life Cycle (SDLC).

answer

True

question

In the Systems Development Life Cycle (SDLC), problems defined during the planning phase are examined in greater detail during the analysis phase.

answer

True

question

The database contents might be loaded interactively or in batch mode using a variety of methods and devices including customized user programs.

answer

True

question

The database administrator must be prepared to perform routine maintenance activities within the database.

answer

True

question

The first step in the ER model verification process is to _____. 1) identify each module and its components 2) identify the ER model's central entity 3) verify all processes against the ER model 4) identify each module's internal transaction requirements

answer

identify the ER model's central entity

question

The Systems Development Life Cycle (SDLC) traces the history of an information system.

answer

True

question

In the Systems Development Life Cycle(SDLC), the design of the system's processes begins in the detailed systems design phase.

answer

True

question

The result of analysis phase of the Systems Development Life Cycle (SDLC) should be a better understanding of the system's functional areas, actual and potential problems, and opportunities.

answer

True

question

The overall purpose of the database initial study is to create the conceptual design.

answer

False

question

The implementation and loading phase of the Database Life Cycle (DBLC) involves _____. 1) defining objectives 2) introducing changes 3) testing the database 4) installing the DBMS

answer

installing the DBMS

question

Selecting database management system (DBMS) software is part of the _____ phase of the Database Life Cycle (DBLC). 1) database initial study 2) database design 3) implementation and loading 4) testing and evaluation

answer

database design

question

In the context of the database design process, the conceptual design step that defines the fragmentation and allocation strategy is _____. 1) database analysis and requirements 2) ER modeling and normalization 3) data model verification 4) distributed database design

answer

ER modeling and normalization

question

Technique that stores related rows from two related tables in adjacent data blocks on disk

answer

Clustered Tables

question

Set of database privileges that could be assigned as a unit to a user or group

answer

Database Role

CSIS304 Chapters 7-9 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards