4200 FINAL
Based on the order of precedence, what is the result of the following expression: 14+8*4/2-6
24
Table A contain eight rows and table B contains four rows. The output of their Cartesian product includes _____ rows?
32
Identify the line of code containing the error in the following PL/SQL block. 1)DECLARE 2)first_variable NUMBER := 2; 3)BEGIN 4)first_variable := first_variable ^ 3; 5)DBMS_OUTPUT.PUT_LINE(second_variable); 6)END;
4
If you create an inner join query involving table A that contains six rows and table B that contains four rows, what is the maximum number of rows that can be included in the results?
6
The following PL/SQL block extracts and displays the area code and phone number for a customer. However it contains a logic error. Identify the error. DECLARE curr_phone VARCHAR2(30) := '9045551897'; curr_arecode VARCHAR2(30); curr_number VARCHAR2(30); BEGIN curr_areacode := SUBSTR(curr_phone, 1, 3); DBMS_OUTPUT.PUT_LINE(' The area code is: ' || curr_areacode); curr_number := SUBSTR(curr_phone, 4, 6); DBMS_OUTPUT.PUT_LINE('The phone number is: ' || curr_number); END;
?
Which of the following can be used to run the oralab02.sql script files in SQL Plus? (choose all correct answers) a) Execute oralab02.sql b) @ oralab2.sql c) Run oralab02.sql d) Start oralab02.sql
@ oralab2.sql Start oralab02.sql
Potential development projects can be identified by: a) a steering committee b) top management c) a senior IS manager d) user departments e) All of the above
All of the above
Which of the following types of joins include a row from table A if it has an equivalent value in the common column in table B? a) inner join b) natural join c) equijoin d) All the above
All the above
Which of the following is a valid statement?
An updatable view can be used to delete data from its underlying tables
You want to use the INSERT INTO command to add data to all the columns of an oracle table, but you don't remember the order of the columns in the table. What SQL command can you use to verify the order?
DESCRIBE
Which of the following removes the view named FAC from the database?
DROP VIEW Fac;
Which of the following alternative methods for making information systems identification and selection decisions has at its focus integration with existing systems?
Development group
Analytical skills:
Enable you to understand the organization and its functions, to identify opportunities and problems, and to analyze and solve problems
In a PL/SQL block, which of the following section(s) is mandatory?
Execution section
A boundary is the point of contact where a system meets its environment or where subsystems meet each other
FALSE
An interface separates a system from other systems
FALSE
Due to the principle of incremental commitment, a selected project will result in a working system.
FALSE
During logical design, the analyst team decides which programming languages the computer instructions should be written in, which database systems and file structures will be used for the data, and which hardware platform, operating system, and network environment the system will run under.
FALSE
Logical design is tied to a specific hardware and software platform
FALSE
Projects identified by top management have a cross-functional focus.
FALSE
Requirements structuring is the first activity of the systems planning and selection phase
FALSE
The SQL CREATE SEQUENCE command is a data manipulation language command
FALSE
The objective of project identification and selection is to transform a vague system request document into a tangible project description.
FALSE
The output of the systems planning and selection phase is a description of the alternative solution recommended by the analysis team.
FALSE
To maintain consistency, the classification and ranking of projects should only be performed by top management or a steering committe
FALSE
When you use the CREATE SEQUENCE command to create a sequence, you need to use a COMMIT command (at a later time) for the sequence to ultimately exist in the database
FALSE
The following statement is an example of what type of query SELECT s_first, s_last, grade, course_sec_id FROM student s, enrollment e WHERE s_s_id = e_e_id;
Inner query
What will be the value of the variable first_variable after execution of the following PL/SQL block? DECLARE first_variable NUMBER; second_variable NUMBER; BEGIN second_variable := (100 * 3)/10; END;
NULL
The following is an example of what kind of query? SELECT s_first, s_last FROM student WHERE s_id = (SELECT s_id FROM enrollment WHERE grade = 'A');
Nested query
The extent to which the project is viewed as improving profits, customer service, etc., and the duration of these benefits best defines which of the following evaluation criteria?
Potential benefits
In the following query which of the following will cause an error to occur? SELECT f_last, f_first FROM faculty Where f_id = (Select f_id, super_id FROM faculty WHERE rank = 'Assistant');
SELECT f_id, super_id
In which SDLC phase will the analyst study the organization's current procedures and the information systems used to perform tasks?
Systems analysis
In which phase will the systems analyst convert the description of the recommended alternative solution into logical and then physical system specifications?
Systems design
In which SDLC phase is the information system coded, tested, and installed in the organization?
Systems implementation and operation
A feasibility study is conducted before the second phase of the SDLC to determine the economic and organization impact of the system.
TRUE
A key principle of the Agile Methodologies is a clear focus on people rather than roles.
TRUE
A schedule of specific IS development projects is the primary deliverable from the project identification and selection phase.
TRUE
During operation, programmers make the changes that user ask for and modify the system to reflect changing business conditions
TRUE
In the systems development life cycle, it is possible to complete some activities in one phase in parallel with some activities of another phase.
TRUE
Involving the user in analysis and design is a key advantage to the prototyping technique
TRUE
Joint application design (JAD) is a structured process in which users, managers, and analysts work together for several days in a series of intensive meetings to specify or review system requirements
TRUE
Systems implementation and operation is the final phase of the SDLC.
TRUE
The criteria used to evaluate projects will vary by organization
TRUE
The development group identifies projects based on the ease with which existing hardware and systems will integrate with the proposed project.
TRUE
The end user is not the person in the organization most involved in the systems analysis and design process
TRUE
The major outcome from project initiation and planning are the Baseline Project Plan
TRUE
Which of the following data type is not classified as a scalar datatype?
VARRAY
The objective of the project planning process is the development of:
a baseline project plan
Enable you to understand the organization and its functions, to identify opportunities and problems, and to analyze and solve problems
analytical skills
Research has found that projects identified by individual departments or business units most often:
have a narrow, tactical focus
Research has found that projects identified by top management more often:
have a strategic, organizational focus
Management skills:
help you manage projects, resources, risk, and change
Technical skills:
help you understand the potential and the limitations of information technology
Interpersonal skills:
help you work with end users, as well as other analysts and programmers
How to work with end users, as well as other analysts and programmers
interpersonal skills
Help you manage projects, resources, risks, and change
management skills
Which of the following is a SET operator? a) UNITE b) INTERCEPT c) SUM d) none of the above
none of the above
Building a scaled-down version of the desired system best describes:
prototyping
A systems development methodology created to radically decrease the time needed to design and implement information systems best describes:
rapid application development
The extent to which the project is viewed as helping the organization achieve its strategic objectives and long-term goals describes:
strategic alignment
The phase of the SDLC in which the current system is studied and alternative replacement systems are proposed
system analysis
The phase of the SDLC in which the system chosen for development in systems analysis is first described independently of any computer platform and is then transformed into technology-specific details from which all programming and system construction can be accomplished
system design
A description of the alternative solution recommended by the analysis team is provided during the:
systems analysis phase
The final phase of the SDLC, in which the information system is coded, tested, and installed in the organization, and in which the information system is systematically repaired and improved.
systems implementation and operation
The phase of the SDLC in which an organization's information system needs are analyzed,and in which a potential information systems project is identified and an argument for continuing or not continuing with the project is presented
systems planning and selection
Help you understand the potential and the limitations of information technology
technical skills
Identify the line of code containing the error in the following PL/SQL block. 1)DECLARE 2)second_variable NUMBER DEFAULT 2; 3)BEGIN 4)second_variable := second_variable + 3; 5)DBMS_OUTPUT.PUT_LINE(second_variable); 6)END;
there is no error
Which of the following possible project sources most often reflects the broader needs of the organization?
top management
When attempting to debug a logic error, the first step is to:
use the DBMS_OUTPUT debugging statements to determine the values of the variables
Analyzing an organizations activities to determine where value is added to products and/or services and the costs incurred best describes:
value chain analysis
