Monday- cisco



Procedures doesn't need to return any value TRUE

function doesn't need to return any value FALSE

Variables can be used for ALL

In distributed database design, portion of a database resides in DIFFERENT

the process of selecting the data storage and data access characteristics of the database PHYSICAL

Information are raw facts FALSE

To reference a bind variable, it should be prefixed by ampersand (&) symbol FALSE

IN operator is used to match a character pattern TRUE

Designers gather information from ALL

Components of Information system are PEOPLE HARDWARE DATA

Old and new quantifiers are available only in row triggers TRUE

Function must have at least one return statement TRUE

User defined functions can not be used in, order by or group by classes FALSE

SQL statements are case sensitive FALSE

Anonymous blocks doesn't have any name TRUE

top down design SET DATA

This design first identifies the data items and then groups them together in data sets BOTTOM UP

Distinct key word is used to eliminate duplicate rows TRUE

Data dictionary provides information about ROW

Match The Following
Question
Fires when an even occurs with a particular application
APP TRIGGER, DATABASE ROW STATEMENT

Question
feasibility study PLANNING
user requirements ANALYSIS/DATA MODEL
detailed system - DESIGN
coding, testing -implementation

This command permanently stores data changes COMMIT

Count function in SQL returns the number of ROW

Reference variable is used to store index address TRUE