Below are some important Oracle Database interview questions which are asked in most MNC company interviews for beginners or professionals.
21. What Is Transport Network Substrate (TNS) in Oracle?
TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.
22. What Is Open Database Communication (ODBC) in Oracle?
ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems.
Oracle offers ODBC drivers to allow Windows applications to connect Oracle server through ODBC.
23. What is Oracle Database 10g Express Edition?
Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer.
Oracle Database XE is a great starter database for:
* Developers working on PHP, Java, .NET, and Open Source applications
* DBAs who need a free, starter database for training and deployment
* Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
* Educational institutions and students who need a free database for their curriculum
24. What Are the Limitations Oracle Database 10g XE?
Oracle Database XE is free for runtime usage with the following limitations:
* Supports up to 4GB of user data (in addition to Oracle system data)
* Single instance only of Oracle Database XE on any server
* May be installed on a multiple CPU server, but only executes on one processor in any server
* May be installed on a server with any amount of memory, but will only use up to 1GB RAM of available memory
25. What Operating Systems Are Supported by Oracle Database 10g XE?
Oracle Database 10g Express Edition is available for two types of operating Systems:
* Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu
* Microsoft Windows
26. How To Download Oracle Database 10g XE?
If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technology/software/products/database/xe/.
If you are using Windows systems, there are downloads available for you:
* Oracle Database 10g Express Edition (Western European) - Single-byte LATIN1 database for Western European language storage, with the Database Homepage user interface in English only.
* Oracle Database 10g Express Edition (Universal) - Multi-byte Unicode database for all language deployment, with the Database Homepage user interface available in the following languages: Brazilian Portuguese, Chinese (Simplified and Traditional), English, French, German, Italian, Japanese, Korean and Spanish.
* Oracle Database 10g Express Client
You need to download the universal edition, OracleXEUniv.exe, (216,933,372 bytes) and client package, OracleXEClient.exe (30,943,220 bytes).
27. How To Install Oracle Database 10g XE?
To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process.
You should take notes about:
* The SYSTEM password you selecte: atoztarget.
* Database server port: 1521.
* Database HTTP port: 8080.
* MS Transaction Server port: 2030.
* The directory where 10g XE is installed: oraclexe
* Hard disk space taken: 1655MB.
28. How To Check Your Oracle Database 10g XE Installation?
If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8080/apex/.
You will see the login page. Enter SYSTEM as the user name, and the password (atoztarget), you selected during the installation to log into the server.
Visit different areas on your 10g XE server home page to make sure your server is running OK.
You can also get to your 10g XE server home page by going through the start menu. Select All Programs, then Oracle Database 10g Express Edition, and then Go To Database Home Page
29. How To Shutdown Your 10g XE Server?
If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server.
Select OracleServiceXE, and use the right mouse click to stop this service. This will shutdown your 10g Express Edition server.
You can also shutdown your 10g XE server through the start menu. Select All Programs, then Oracle Database 10g Express Edition, and then Stop Database.
30. How To Start Your 10g XE Server?
Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.
21. What Is Transport Network Substrate (TNS) in Oracle?
TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.
22. What Is Open Database Communication (ODBC) in Oracle?
ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems.
Oracle offers ODBC drivers to allow Windows applications to connect Oracle server through ODBC.
23. What is Oracle Database 10g Express Edition?
Based on Oracle Web site: Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer.
Oracle Database XE is a great starter database for:
* Developers working on PHP, Java, .NET, and Open Source applications
* DBAs who need a free, starter database for training and deployment
* Independent Software Vendors (ISVs) and hardware vendors who want a starter database to distribute free of charge
* Educational institutions and students who need a free database for their curriculum
24. What Are the Limitations Oracle Database 10g XE?
Oracle Database XE is free for runtime usage with the following limitations:
* Supports up to 4GB of user data (in addition to Oracle system data)
* Single instance only of Oracle Database XE on any server
* May be installed on a multiple CPU server, but only executes on one processor in any server
* May be installed on a server with any amount of memory, but will only use up to 1GB RAM of available memory
25. What Operating Systems Are Supported by Oracle Database 10g XE?
Oracle Database 10g Express Edition is available for two types of operating Systems:
* Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu
* Microsoft Windows
26. How To Download Oracle Database 10g XE?
If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technology/software/products/database/xe/.
If you are using Windows systems, there are downloads available for you:
* Oracle Database 10g Express Edition (Western European) - Single-byte LATIN1 database for Western European language storage, with the Database Homepage user interface in English only.
* Oracle Database 10g Express Edition (Universal) - Multi-byte Unicode database for all language deployment, with the Database Homepage user interface available in the following languages: Brazilian Portuguese, Chinese (Simplified and Traditional), English, French, German, Italian, Japanese, Korean and Spanish.
* Oracle Database 10g Express Client
You need to download the universal edition, OracleXEUniv.exe, (216,933,372 bytes) and client package, OracleXEClient.exe (30,943,220 bytes).
27. How To Install Oracle Database 10g XE?
To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process.
You should take notes about:
* The SYSTEM password you selecte: atoztarget.
* Database server port: 1521.
* Database HTTP port: 8080.
* MS Transaction Server port: 2030.
* The directory where 10g XE is installed: oraclexe
* Hard disk space taken: 1655MB.
28. How To Check Your Oracle Database 10g XE Installation?
If you want to check your fresh installation of 10g Express Edition without using any special client programs, you can use a Web browser with this address, http://localhost:8080/apex/.
You will see the login page. Enter SYSTEM as the user name, and the password (atoztarget), you selected during the installation to log into the server.
Visit different areas on your 10g XE server home page to make sure your server is running OK.
You can also get to your 10g XE server home page by going through the start menu. Select All Programs, then Oracle Database 10g Express Edition, and then Go To Database Home Page
29. How To Shutdown Your 10g XE Server?
If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server.
Select OracleServiceXE, and use the right mouse click to stop this service. This will shutdown your 10g Express Edition server.
You can also shutdown your 10g XE server through the start menu. Select All Programs, then Oracle Database 10g Express Edition, and then Stop Database.
30. How To Start Your 10g XE Server?
Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.
More Questions & Answers :-
No comments:
Post a Comment