SGBD Quiz

A modern, abstract illustration of databases and coding with visual elements representing SQL and data security, featuring vibrant colors and a tech-inspired design.

SGBD Quiz: Test Your Database Knowledge

Welcome to the SGBD Quiz, where you can assess your knowledge of database management systems! This quiz contains 10 carefully crafted questions that cover various aspects of SQL procedures, data integrity, and Codd's rules.

Whether you’re a seasoned database professional or a student eager to learn, you can challenge yourself and expand your understanding of database management.

10 Questions2 MinutesCreated by QueryMaster204

1. Which of the following statements about procedures are true:

A) Can contain OUT parameters

B) Can’t contain COMMIT or ROLLBACK

C) Are always part of a package

D) Can be executed using CALL

E) Can’t be executed using EXEC

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

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

A) Some information in the database should not be represented as relational tables

B) The system must support at least one non-relational language

C) The system should isolate all application programs (and end user accesses) from the logical structure of the database.

D) Low-level (record-at-a-time) interfaces can bypass relational security or integrity constraints of the system.

E) All data stored in the database must be logically addressable by specifying the relation, the related attribute(s), and the primary key-value

5. 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?

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

A) Return PL/SQL types

B) Don’t contain COMMIT or ROLLBACK

C) Are part of a package

D) Store overloaded subprograms

E) Used in UPDATE or DELETE on a table, they can’t contain DML statements on the same table

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

A) Compared to nested tables do not have a maximum length declared upfront

B) Assures logical data independence and physical data independence

C) Can be sparse

D) Can be created at schema level

E) The subscript type is an integer

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

A) Some information in the database should not be represented as relational tables

B) The DBMS is required to have a consistent way of representing and treating so-called “missing information”

C) A system qualifies as a relational, database, and management if it uses its relational facilities non-exclusively to manage its database

D) The system must support set-wise DML operation

E) All views that are theoretically updateable must be updateable by the system

10. 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?

SGBD Quiz

SGBD Quiz: Test Your Database Knowledge

More Quizzes