Oracle DBA Interview Questions and Answers for Experienced - 3
Question: 11
How many columns can be used to create a composite index?
A composite index can support 32 columns as long as total size of the columns does not exceed DB_BLOCK_SIZE.
Question: 12
What command would you use to encrypt a PL/SQL application?
The WRAP command can be used to encrypt a PL/SQL application.
Question: 13
How would you determine the time zone under which a database was operating?
You can determine the time zone under which a database was operating by using the select DBTIMEZONE from dual; statement.
Question: 14
What does coalescing a tablespace do?
Coalescing is used to combine fragmented space into larger extents.
It is valid for dictionary managed tablespace and defragments space by coming neighboring free extends into larger single extents.
Question: 15
Can you disable and enable primary key?
Yes, you can use the following statements to enable and disable primary key constraints
Alter table <table_name> enable constraint <constraint_name>;
Alter table <table_name> disable constraint <constraint_name>;
GATE Chemical Engineering Questions and Answers More
GATE 2024-2025 Question Paper Pdf Download More
Banking Awareness Questions 2024-2025 More
Computer Quiz Questions for Bank Exams More
Computer Quiz Questions for Bank Exams More
Structural Organisation in Animals Question and Answers More
Computer Quiz Questions with Answers for Class 11 More
1000+ Electrical and Electronics Engineering (EEE) Online Test More
1000+ TNPSC Physics Gk Questions and Answers More
1000+ IBPS PO Previous Year Question Paper Online Test More