Oracle and DBMS
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?
Which of the following data types in Informix Universal Server database is used to extend an existing type through inheritance?
Which one of the following objects in object-oriented databases has a type hierarchy and set/subset constraints have been enforced on it?
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?
Which of the following objects in the processing of a high-level query has the task of producing an execution plan?
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?
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?
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?
Which of the following is the simplest and also substantial means to improve performance of Oracle using partitioning?
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?
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?
Which of the following components of select command is used to summarize the data of the table?
Which of the following attribute of cursor command in Oracle is used to return no more records from the cursor when it is failed?
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?
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?