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
1 of

Unlock all answers in this set

Unlock answers
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