Oracle DBA Interview Questions and Answers - 1
Question: 1
What is the significance of pseudo column in oracle?
- Pseudo column is an Oracle assigned value used in the same context as a column.
- It is an item of data, which is treated like a table column even though it does not exist as part of the definition of any table.
- CURRVAL, NEXTVAL, USER, SYSDATE, LEVEL, ROWID, and ROWNUM are the examples of pseudo column.
- A pseudo column can be queried but Data Manipulation Language (DML) cannot be applied to a pseudo column.
Question: 2
What is a global index and local index?
- A global index is associated with the entire table and gets affected when any one of the partitions is modified.
- Local indexes are associated with individual partitions.
- Therefore, only a person of the index gets affected when a table partition is modified.
Question: 3
What is the difference between DELETE and TRUNCATE statements?
- DELETE is a Data Manipulation Language (DML) statement and can be rolled back while TRUNCATE is a DDL statement and cannot be rolled back.
- You can delete data selectively by using the DELETE statement while TRUNCATE statement removes all data in the table.
- DELETE does not affect High Water Mark (HWM) while TRUNCATE moves HWM to the beginning of the table.
Question: 4
Can you import objects from Oracle version 7.3 to 9i?
Yes, you can use the exp or imp utilities to import the objects from Oracle version 7.3 to 9i.
Question: 5
Can you pivot the results of a query?
You can use hierarchical query with the sys_connect_by_path function in Oracle 9i and above to pivot the result.
Related Questions
Recent Articles
Basic IT Quiz Questions and Answers 2027-2028 More
Latest Computer Questions for Competitive Exams 2027-2028 More
CUET Online Mock Test 2027-2028 More
Computer Quiz Online 2026-2027 More
CBT Exam Sample Questions with Answers Pdf More
Computer GK Questions 2027-2028 Pdf More
November-12-2026
| Meritnotes
Latest Computer Questions for Competitive Exams 2027-2028 More
November-06-2026
| Meritnotes
CUET Online Mock Test 2027-2028 More
October-30-2026
| Meritnotes
Computer Quiz Online 2026-2027 More
October-26-2026
| Meritnotes
CBT Exam Sample Questions with Answers Pdf More
October-16-2026
| Meritnotes
Computer GK Questions 2027-2028 Pdf More
October-07-2026
| Meritnotes
Trending Posts
7000+ Antonyms Worksheets with Answers for Class 10 More
7000+ Economics MCQ Questions and Answers 2024 - 2025 Pdf More
100+ Tally ERP 9 Interview Questions & Answers Pdf More
Oracle Streams 11g Interview Questions and Answers More
MCQ Questions on Digital Electronics Pdf More
Reading Comprehension Passages with Questions and Answers More
October-01-2023
| Meritnotes
7000+ Economics MCQ Questions and Answers 2024 - 2025 Pdf More
August-07-2023
| Meritnotes
100+ Tally ERP 9 Interview Questions & Answers Pdf More
November-26-2019
| Meritnotes
Oracle Streams 11g Interview Questions and Answers More
August-28-2019
| Meritnotes
MCQ Questions on Digital Electronics Pdf More
April-03-2025
| Meritnotes
Reading Comprehension Passages with Questions and Answers More
April-23-2023
| Meritnotes