SGBD

A database system has the components:

Types of architectures for DBMS are:

DBMS has the following objectives:

In DBMS evolution we can observe:

DMBS clasification is based on:

Architectures for DMBS are:

Any data base system has the components:

Any DBMS:

The fundamental functions of any DBMS are:

Which one is correct:

Data description commands are at:

Codd's rules refer to:

Codd's rules can be classified based on:

Which of the following conditions are necessary for functions to be used in SQL statements:

Data integrity can be assured using:

Which of the following statements about Variable-size arrays (VARRAY) are true:

Which of the following statements are true according to Codd’s rules?

Given the function: CREATE OR REPLACE FUNCTION check_salary_n (p_id employees.employee_id%type, p_sal number) RETURN number IS v_salary employees.salary%type; BEGIN SELECT salary into v_salary from employees where employee_id=p_id; IF p_sal > v_salary then return 1; ELSE return -1; end if; EXCEPTION WHEN no_data_found THEN return NULL; end; What will select check_salary_n(109,5000) from dual return?

Which of the following statements about procedures are true:

Data security can be assured using:

Which of the following statements about index-by tables are true:

Which of the following statements are true according to Codd’s rules?

Given the function: CREATE OR REPLACE FUNCTION check_salary_n (p_id employees.employee_id%type, p_sal number) RETURN number IS v_salary employees.salary%type; BEGIN SELECT salary into v_salary from employees where employee_id=p_id; IF p_sal > v_salary then return 1; ELSE return -1; end if; EXCEPTION WHEN no_data_found THEN return NULL; end; What will select first_name,check_salary_n(employee_id,5000) from employees return?