Questions
Which of the following objects in distributed database is a set of tables and views that are used as a read-only reference for the database?
- Member methods
- Schema
- Data dictionary
- Overriding
- Final
Which of the following options in Startup command of oracle starts up the database using the static non-default parameter file to startup the database?
- OPEN
- PFILE
- MOUNT
- RECOVER
- RESTRICT
Which of the following processing systems is the one in which several autonomous processors and data stores supporting processes and databases interact in order to cooperate and achieve an overall goal?
- Distributing processing system
- Multiprocessing system
- Multiprogramming system
- Relational database system
- UNIX system
Which of the following files in oracle database is present in multiple copies in the database on separate disks?
- Datafiles
- Redo Log Files
- Control Files
- The password file
- The archive file
Which of the following types of schema in the reference architecture for distributed database defines the mapping between the global relations and fragments?
- Allocation schema
- Fragmentation schema
- Global schema
- Local mapping schema
- Relational schema
Which of the following is the logical structure that can classify or group database objects?
- Segment
- Extent
- Schema
- Database block
- Instance
Which of the following phases in the database design process is the one in which we design the specifications for the stored database in terms of physical storage structures to record placement and indexes?
- Conceptual database design
- Data model mapping
- Physical database design
- Database system implementation
- Database tuning
Which of the following activities in database application system life cycle comprises of the process of specifying the conceptual, external and internal database definition?
- System definition
- Database design
- Loading or data conversion
- Database implementation
- Application conversion
Which of the following measures of database systems allows the same data to be used for multiple applications, with each application having its own view of the data?
- Data independence
- Physical schema
- External schema
- Conceptual schema
- Data storage
Which of the following operations on Object-Oriented databases allows operations and method names to be overloaded to apply to different object types with different implementations?
- Extents
- Encapsulation of operations
- Polymorphism and Operator Overloading
- Type constructors
- Object identity
Which of the following background processes resolves distributed transactions that are pending due to a network or system failure in a distributed database?
- Process monitor
- Archiver
- Recoverer process
- Dispatchers
- System monitor
Which of the following segments in oracle are created by oracle for use by SQL statements that need a temporary work area?
- Data segments
- Index segments
- Rollback segments
- Temporary segments
- Display segments
Which of the following components of data block in oracle uses the bulk of the space in the data block?
- Row directory
- Row data
- Free space
- Table directory
- Header
Which of the following characteristics in the database design phase specifies that the model should have a small number of basic concepts that are distinct and non-overlapping in meaning?
- Expressiveness
- Simplicity and understandability
- Minimality
- Formality
- Validation and acceptance testing
Which of the following phases in the information system life cycle has two aspects, the design of the database system and the design of the application systems that uses and processes the database?
- Feasibility analysis
- Requirement collection and analysis
- Design
- Implementation
- Validation and acceptance testing
Which of the following table level lock in oracle permits other users to concurrently query, insert, update or even lock other rows in the same table?
- Fixed lock
- Share lock
- Design
- Share Update lock
- Exclusive lock