MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What should be done to use a function-based index? |
| A. | The table must be analyzed after the index is created |
| B. | The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes |
| C. | Both A & B |
| D. | None of the above |
| Answer» B. The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes | |
| 2. |
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:a) High availability of datab) Faster primary key access to the table datac) Compact storage for the tableWhich type of tables would you use to achieve these objectives? |
| A. | Heap tables |
| B. | Object tables |
| C. | Partitioned tables |
| D. | Index-organized tables (IOTs) |
| Answer» D. Index-organized tables (IOTs) | |
| 3. |
Which of the following condition is true to create an index in your own schema? |
| A. | The table or cluster to be indexed is in another schema |
| B. | You don t have INDEX privilege on the table to be indexed |
| C. | You have CREATE ANY INDEX system privilege |
| D. | None of the above |
| Answer» D. None of the above | |
| 4. |
In ALTER TABLE Mainte ce Operations for Table Partitions which mainte ce operation partition is used by range, hash, list, composite(range/hash), composite(range/list) from the following? |
| A. | Coalescing Partitions |
| B. | Dropping Partitions |
| C. | Adding partitions |
| D. | Both A & B |
| Answer» D. Both A & B | |
| 5. |
In the following example which method is used to partition the index-organized table, sales?CREATE TABLE sales(acct_no NUMBER(5),acct_name CHAR(30),amount_of_sale NUMBER(6),week_no INTEGER,sale_details VARCHAR2(1000),PRIMARY KEY (acct_no, acct_name, week_no))ORGANIZATION INDEXINCLUDING week_noOVERFLOWPARTITION BY HASH (week_no)PARTITIONS 16STORE IN (ts1, ts2, ts3, ts4)OVERFLOW STORE IN (ts3, ts6, ts9); |
| A. | List |
| B. | Hash |
| C. | Range |
| D. | None of the above |
| Answer» C. Range | |
| 6. |
What benefits does creating an index with NOLOGGING have? |
| A. | Space is saved in the redo log files |
| B. | The time it takes to create the index is decreased |
| C. | Performance improves for parallel creation of large indexes |
| D. | All mentioned above |
| Answer» E. | |
| 7. |
Which key have automatically indexes, but you might want to create an index on a foreign key? |
| A. | Primary |
| B. | Unique |
| C. | Both A & B |
| D. | None of the above |
| Answer» D. None of the above | |
| 8. |
What Enables you to quickly change storage and tablespace parameters without having to drop the original index? |
| A. | Coalesce Index |
| B. | Rebuild Index |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 9. |
Which partition forms of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values? |
| A. | Range-Hash Partition |
| B. | Range-List Partition |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 10. |
Which type of partition will be done for the following?1. Partition description identifying partition bounds. |
| A. | Range Partition |
| B. | Hash Partition |
| C. | List Partition |
| D. | Range-Hash Partition |
| Answer» B. Hash Partition | |
| 11. |
Indexes may be marked UNUSABLE for which table type, the index behavior for adding partition is?1) For local indexes, the behavior is the same as for heap tables.2) All global indexes remain usable. |
| A. | Regular (Heap) |
| B. | Index-organized |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 12. |
What does the database let you do if you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints? |
| A. | Specify a new index that the database is to use to enforce the constraint |
| B. | Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |
| 13. |
How many partitioning keys columns are specified for range-and-hash-partitioning tables? |
| A. | 18 |
| B. | 14 |
| C. | 16 |
| D. | 17 |
| Answer» D. 17 | |