SGBD Quiz
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.
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:
A) Are unbounded
B) Can be sparse
C) Can be created at schema level
D) The subscript type can be a string
E) Can be processed outside PL/SQL blocks
3. Data security can be assured using:
A) Backup/recovery
B) Semantic Constraints
C) Encryption
D) Views
E) Concurrent access
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?
A) An exception
B) A compilation-time error
B) A compilation-time error
D) -1, 1 or NULL
E) -1, 1 or NULL for each employee
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
8. Data integrity can be assured using:
A) Encryption
B) Backup/recovery
C) Semantic Constraints
D) Views
E) APEX
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?
A) An exception
B) A compilation-time error
C) Always NULL
D) -1, 1 or NULL
E) -1, 1 or NULL for each employee
{"name":"SGBD Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"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.","img":"https:/images/course5.png"}