SGBD
SGBD Knowledge Quiz
Test your understanding of database management systems (DBMS) with our comprehensive quiz! Strike a balance between theoretical knowledge and practical application through diverse questions designed to challenge your expertise.
- Covers fundamental concepts of DBMS
- 23 engaging questions
- Multiple choice and checkbox formats
A database system has the components:
Software
Data
Operating system
Compilers
Physical component
DBMS has the following objectives:
Data usage facilities
Increasing data redundancy
Data independency to programs
Data tunability
Reducing the integrity of data
In DBMS evolution we can observe:
2 generations
3 generations
1 generation
Changing the fundamental aspects
Data usage facilities are reduced
The access time increases
Improving data organizing in the external momory
The enhancement of data usage facilities
DMBS clasification is based on:
The computing system implemented
Increasing external memory
Increasing internal memory
Data localization
Microprocessor speed
Any data base system has the components:
Conceptual level
Data
Physical level
Auxiliar elements
Operating system
Any DBMS:
Is a recovery language
Assures the link between all other components of the DBS
Is a database of a certain type
Is the software component of a DBS
Manages all the files from a computing system
Realizes the inrface between a database and its users
The fundamental functions of any DBMS are:
Compiling the programs
Data sorting
Data description
Generating programs
Relational transformation
Data usage
Which one is correct:
Any DBMS implements the relational model
Databases have evolved into files
Some databases are organized in the external memory
Any DBMS allows mananging data at conceptual level
Any DBMS has a DDL
Any DMBS implements a logical data model
Codd's rules refer to:
Granting the accsess to programs
The facilities of the programming languages used
Conceptual independence of data
The facilities of the procedural programming languages
Physical independence of data
Updating virtual tables
Geographical distribution of data
Codd's rules can be classified based on:
Data integrity
Data destination
Data manipulation
Data source
Data independence
Which of the following conditions are necessary for functions to be used in SQL statements:
Don’t contain COMMIT or ROLLBACK
Are part of a package
Used in UPDATE or DELETE on a table, they can’t contain DML statements on the same table
Store overloaded subprograms
Return PL/SQL types
Data integrity can be assured using:
Views
APEX
Backup/recovery
Semantic constraints
Encryption
Concurrent access via transactions
Which of the following statements about Variable-size arrays (VARRAY) are true:
Can be created at schema level
Compared to nested tables do not have a maximum length declared upfront
The subscript type is an integer
Can be sparse
Are always dense
Assures logical data independence and physical data independence
Which of the following statements are true according to Codd’s rules?
The DBMS is required to have a consistent way of representing and treating so-called “missing information”
Some information in the database should not be represented as relational tables
The system must support set-wise DML operation
A system qualifies as a relational, database, and management if it uses its relational facilities non-exclusively to manage its database
All views that are theoretically updateable must be updateable by the system
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?
An exception
-1, 1 or NULL
A compilation-time error
Always NULL
-1, 1 or NULL for each employee
Which of the following statements about procedures are true:
Can’t contain COMMIT or ROLLBACK
Can be executed using CALL
Can't be executed using EXEC
Can contain OUT parameters
Are always part of a package
Data security can be assured using:
Encryption
Backup/recovery
Structural constraints
Views
Procedural constraints
Which of the following statements about index-by tables are true:
Can be sparse
Can be dense
Can be created at schema level
Can be processed outside PL/SQL blocks
The subscript type can be a string
Which of the following statements are true according to Codd’s rules?
Low-level (record-at-a-time) interfaces can bypass relational security or integrity constraints of the system.
The system should isolate all application programs (and end user accesses) from the logical structure of the database.
Some information in the database should not be represented as relational tables
All data stored in the database must be logically addressable by specifying the relation, the related attribute(s), and the primary key-value
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?
-1, 1 or NULL for each employee
An exception
A compile-time error
-1, 1 or NULL
Always NULL
{"name":"SGBD", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your understanding of database management systems (DBMS) with our comprehensive quiz! Strike a balance between theoretical knowledge and practical application through diverse questions designed to challenge your expertise.Covers fundamental concepts of DBMS23 engaging questionsMultiple choice and checkbox formats","img":"https:/images/course1.png"}