Oracle and DBMS
Quiz covering Oracle database features including data types, constraints, partitioning, and general DBMS concepts such as normalization, query optimization, concurrency control, and distributed transactions.
Questions
Which of the following normal forms is depicted when a relation where primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key?
- 1 NF
- 2 NF
- 3 NF
- 5 NF
- BCNF
Which of the following data types in Informix Universal Server database is used to extend an existing type through inheritance?
- Opaque type
- Row type
- Distinct type
- Collection type
- Varchar2 type
Which one of the following objects in object-oriented databases has a type hierarchy and set/subset constraints have been enforced on it?
- Inheritance
- Operator overloading
- Extents
- Polymorphism
- Encapsulation
Which one of the following objects in Oracle is a group of records from one or more tables is physically stored in a mixed file?
- Synonyms
- Sequence
- Indexes
- Cluster
- Triggers
Which of the following objects in the processing of a high-level query has the task of producing an execution plan?
- Query optimiser
- Query code generator
- Runtime database processor
- Query parser
- DML compilers
Which one of the following DBMS software modules processes and checks the specification of a database scheme in the DDL and stores that description in the catalog?
- Query and DML compilers
- Query and DML optimiser
- DDL compilers
- Query and DML parser
- DBA
Which one of the following failures in a database may decide to abort the transaction to be restarted later because it violates serialisability or because several transactions are in a state of deadlock?
- Computer failure
- A transaction or system error
- Local errors
- Concurrency control
- Disk failure
Which of the following data type is used in Oracle to store unstructured information such as sound clips, video files etc. in an Oracle table?
- Long raw
- CLOB
- Date
- LOB
- BLOB
Which of the following is the simplest and also substantial means to improve performance of Oracle using partitioning?
- Partition-wise joins
- Partitioning pruning
- Global partitioned indexes
- Composite range hash partitioning
- Global non-partitioned indexes
Which of the following constraints is used in Oracle to prevent the duplication of values within the rows of specified column or a set of columns in a table?
- Domain integrity constraints
- Check constraints
- Unique constraints
- Referential integrity constraints
- Tuple constraints
Which of the following cost components for query execution is the cost of searching for reading and writing data blocks that reside on secondary storage mainly on disks?
- Storage cost
- Computation cost
- Memory usage cost
- Access cost to secondary storage
- Communication cost
Which of the following components of select command is used to summarize the data of the table?
- From
- Select
- Where
- Order by
- Group by
Which of the following attribute of cursor command in Oracle is used to return no more records from the cursor when it is failed?
- %FOUND
- %NOT FOUND
- %ISOPEN
- %ROWCOUNT
- %COUNT
Which of the following is/are used in Oracle to connect to non-Oracle data stores by using either a Heterogeneous Services ODBC agent or a Heterogeneous Services OLE DB agent?
- Transparent Gateway Agents
- Database link
- Generic connectivity
- Cursor
- Triggers
Which one of the following transactions is a transaction that includes one or more statements that, individually or in a group update, data on two or more distincts of a distributed database?
- Remote transaction
- Two-Phase commit mechanism
- Distributed transaction
- SNMP
- Enterprise manager