Database Management Systems Fundamentals and Oracle Architecture
Quiz covering core DBMS theoretical concepts including schema architecture, utilities, and operations, plus traditional Oracle physical storage and memory management components
Questions
Which of the following role is not performed by DBA in DBMS?
- Schema definition
- Liaising with users
- Defining security and integrity checks
- Defining backup/Recovery procedures
- Specifying primary key
Which of the following terms in DBMS is the set of all values that can be taken by the attribute in a relation?
- Tuple
- Attribute
- Cardinality of a relation
- Domain of an attribute
- Primary key
Which of the following services of database in DBMS must furnish a mechanism to ensure that both the data in the database and changes to the data follow certain rules?
- Recovery services
- Authorization services
- Integrity services
- Concurrency control services
- Transaction support
Which of the following operations in DBMS is used to retrieve a combination of tuples in two relations based on a common field in both the relations?
- UNION
- INTERSECT
- JOIN
- PRODUCT
- DIFFERENCE
Which of the following is not the property of a relation in DBMS?
- Tuples are unordered
- Attributes are unordered
- Attribute values are atomic
- Duplicate tuples
- Presence of a primary key
Which of the following views in Three-Schema Architecture of DBMS is the information model of the enterprise that contains the view of the whole enterprise without any concern for the physical implementation?
- External view
- Conceptual view
- Internal view
- Users view
- Physical view
Which of the following database system utilities can be used to restore the database in case of catastrophic failure?
- Loading
- Authorisation services
- Integrity services
- Backup
- Transaction support
Which of the following is not the advantage of database processing?
- Sharing of data
- Controlled redundancy
- Consistency
- Integrity
- Not Secured
Which of the following database system utilities is used to reorganize a database file into a different file organization to improve performance?
- Loading
- Backup
- File reorganization
- Performance monitoring
- Maintenance
Which of the following DBMS interfaces accepts requests written in english or some other language and attempts to understand them?
- Graphical User Interfaces
- Natural Language Interfaces
- Menu Based Interfaces
- Form Based Interfaces
- Interfaces for Parametric Users
Which of the following DBMS component modules processes schema definitions specified in the DDL and stores descriptions of the schemas in the DBMS catalog?
- Run time database processor
- DDL compiler
- Query compiler
- DML precompiler
- Stored data manager
Which of the following objects in oracle is a group of records from one or more tables physically stored in a mixed file?
- Sequence
- Cluster
- Indexes
- Synonyms
- Program units
Which of the following segments in oracle have nonclustered table and each cluster holds all its data?
- Index segments
- Temporary segments
- Data segments
- Rollback segments
- Query segments
Which of the following oracle instances keeps the most recently accessed data blocks from the database?
- Redo Log Buffer
- Shared pool
- Database buffer cache
- User processes
- Program Global Area
Which of the following background processes resolves distributed transactions that are pending due to a network or systems failure in a distributed database?
- Recoverer process
- Archiver
- Process monitor
- System monitor
- Log writer