Database Administration · Unit 10
Advanced Database Features and Tools
Exam-focused notes for Advanced Database Features and Tools (Database Administration, BIT352): what the TU syllabus asks and how it has actually been tested, with 7 solved past questions from this unit.
What this unit covers
- SQL*PLUS definition and functionalities
- DBA functionalities in SQL*PLUS
- Oracle RAC concepts
- Oracle ASM concepts
- Oracle Data Pump overview
- Data Pump export procedures
- Data Pump import procedures
- Container database concepts
- Portable database concepts
- Oracle Net service components
- Listener definition and purpose
- Listener.ora file configuration
- Tnsnames.ora file configuration
Listener definition and purpose
What is listener? Explain about listener.ora and tnsnames.ora file in oracle database. [5]
--- A listener is a server-side network process in Oracle Database that listens for incoming client connection requests on a specific network protocol (usually TCP/IP) and a specific port (default port: 1521). When a client wants to connect to an Oracle dat...
Full solved answer →SQL*PLUS definition and functionalities
What is SQLPLUS? Also explain the functionalities of SQLPLUS that the ORACLE DBA can use. [5]
SQL\PLUS is an interactive and batch query tool (command-line interface) provided by Oracle Corporation that comes bundled with the Oracle Database software. It allows users and Database Administrators (DBAs) to: - Interact directly with the Oracle database...
Full solved answer →Oracle RAC concepts
Explain the term oracle RAC and oracle ASM. [5]
Note: The reference notes did not contain material on this topic. The following answer is based on standard Oracle database concepts as taught in database administration courses. --- Oracle RAC is a cluster database option that allows multiple computers (no...
Full solved answer →Oracle Net service components
Explain the different oracle net service components. [5]
Note: The reference notes did not contain this topic directly. The following answer is based on standard Oracle Net Services curriculum as taught in TU BSc CSIT Database Administration courses. --- Oracle Net Services is a suite of networking components tha...
Full solved answer →Oracle Data Pump overview
What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump. [5]
Oracle Data Pump is a high-speed utility introduced in Oracle 10g that allows fast bulk data and metadata movement between Oracle databases. It is an improved replacement for the older exp/imp utilities. Data Pump uses server-side processing, meaning the ex...
Full solved answer →Write short notes on: a. Data Pump b. Container Database [5]
Note: Reference notes were not available for this topic. The following answer is based on standard Oracle Database concepts as covered in BSc CSIT Database Administration curriculum. --- Oracle Data Pump is a high-speed utility introduced in Oracle 10g that...
Full solved answer →Container database concepts
Explain the concept of Container database and Portable database. [5]
Note: The reference notes did not contain specific content on this topic. The following answer is based on standard Oracle Database 12c and later architecture concepts, which is the standard curriculum topic for TU BSc CSIT Database courses. --- A Container...
Full solved answer →Make Unit 10 stick
Practice BIT352 with flashcards & quizzes