Oracle TM Interview Questions and Answers [ STEP-IN ]

Last updated on 18th Nov 2021, Blog, Interview Questions

Oracle TM Professionals and expert trainers from ACTE systems are providing you with the important questions and answers that might be asked when you face an Oracle TM Interview. These questions and answers will help you in the preparation of the interview. Questions are relevant to Oracle TM and its applications. The following list includes the best important Oracle TM questions for freshers as well as Oracle TM questions and answers for experienced candidates to help them prepare for the interview. This complete guide of Oracle TM interview questions will encourage you to crack your Job interview easily.

1. What are the responsibilities of the database administrator’s tasks?

Ans:

• Installing and upgrading the Oracle server and application tools.
• Allocating system storage and planning future storage requirements for the database system.
• Creating primary database storage structures known as tablespaces after application developers have designed an application.
• Creating primary objects such as tables, views, indexes once application developers have designed an application.
• Modifying the database structure, as necessary, from information given by application developers.
• Enrolling users and maintaining system security.
• Ensuring compliance with your Oracle license agreement.
• Controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.
• Planning for backup and recovery of database information.
• Maintaining archived data on tape.
• Backing up and restoring the database.
• Contacting Oracle Corporation for technical support.

2. You want to find out how many users are defined in the password file and what privileges those users have. How would you accomplish this?

Ans:

You can get the information about the existing users in the password file querying the “v$pwfile_users” view.

Execute the SQL query below:

• Sql> SELECT * FROM v$pwfile_users;
• The query above will return four columns for each user in the password file.The column names are USERNAME,SYSDBA, SYSOPER and SYSASM.
• The USERNAME column displays the username of the user in the password file
• The SYSDBA column displays whether the user has SYSDBA privileges or not
• The SYSOPER column displays whether the user has SYSOPER privileges or not
• The SYSASM column displays whether the user has SYSASM privileges or not

3. What are the roles of DBA?

Ans:

A DBA has the authority to create new users, remove the existing users, or modify any of the environment variables or privileges assigned to other users. The roles of DBA include:

• Manage database storage.
• Administer users and security.
• Manage schema objects.
• Monitor and manage database performance.
• Perform backup and recovery.
• Schedule and automate jobs.

4. What are the common Oracle DBA tasks?

Ans:

The following tasks are carried out by Oracle DBA:

• Installing Oracle software.
• Creating Oracle databases.
• Performing upgrades of the database and software to a new release level.
• Starting up and shutting down the database.
• Managing the database’s storage structures.
• Managing users and security.
• Managing schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Proactively monitoring the database’s health and taking preventive or corrective actions as required.
• Monitoring and tuning performance.

5. Name the various Oracle database objects?

Ans:

The various Oracle database objects are:

• Sequences.
• Views.
• Tables.
• Tablespaces.
• Indexes.

6. List out the three essential components of the GL set of a book?

Ans:

Accounting calendar	Charts of account	Currencies
The accounting calendar usually refers to the accounting year and the periods. It includes information about the accounting year and their periods. It also helps you define the multiple calendars and assign the different calendars to each set of books.	The chart of accounts is the structure of the account that helps you define the specific needs of your business or organization. It allows you to choose a number of account segments along with the length name and order of each segment.	Currencies allow you to select the functional currency for your set of works and also the other currencies that you would like to use to transact the business and report the same.

7. What are the contents of the control file?

Ans:

Every Oracle database has a control file. A control file is a small binary file that records the physical structure of the database and includes:

• The database name.
• Names and locations of associated datafiles and online redo log files.
• The timestamp of the database creation.
• The current log sequence number.
• Checkpoint information.

8. List out the tools for administering the database.

Ans:

The following tools are the products, tools and utilities used for administering the database:

• Oracle Universal Installer(OUI).
• Database Configuration Assistant(DBCA).
• Database Upgrade assistant.
• Oracle Net Manager.
• Oracle Enterprise Manager.

9. What are the dictionary tables used to monitor a database space?

Ans:

The following are the dictionary tables used in monitoring a database’s space:

• DBA_FREE_SPACE.
• DBA_SEGMENTS.
• DBA_DATA_FILES.

10. What is an introduction for Oracle TM?

Ans:

11. Explain Briefly Shared Server Architecture?

Ans:

This architecture removes the need for a dedicated server process for each connection. A dispatcher routes various incoming network session requests to a shared server processes pool. An idle shared server process from a shared pool of server processes chooses a request from a common queue,which means a small number of shared servers can do the same amount of processing as many dedicated servers.

It is because of the amount of memory required for each user is comparatively small, less memory and process management are required, and more users can be supported

12. What Is An Index?

Ans:

Indexes are structures associated with tables and clusters. You can create indexes on one or more columns of a table to enhance the speed of SQL statement execution on that table. Just as the index in the Oracle manual helps you to locate information faster than if there were no indexes. An Oracle index provides a faster access path to table data.

13. What Is A Control File?

Ans:

Control file is a binary file which stores Database name, associated data files, redo files, DB creation time and current log sequence number. Without control file databases cannot be started and can hamper data recovery.

14. Explain Sequence Generator In Oracle?

Ans:

The sequence generator gives a sequential series of numbers.The sequence generator is especially useful for generating unique sequential numbers. Sequence numbers are Oracle integers of up to 38 digits defined in the database.A sequence definition provides information, such as:

• The sequence name ascending or descending sequence.
• The interval between numbers.
• Whether Oracle should cache sequence numbers in memory.
• Sequence numbers are generated independent of any tables. The same sequence generator can be used for many tables. Sequence number generation can be used to produce primary keys for your data automatically.
• Oracle stores the definitions of all sequences for a particular database as rows in data dictionary table in the SYSTEM table- space

15. What Is A Dimension?

Ans:

A dimension is hierarchical relationships between pairs of columns or column sets. Each value at the child level is tied with one value at the parent level.A dimension is a container of logical relationships between columns and it does not contain any data.

16. What Is A Tablespace

Ans:

Oracle uses Tablespace for logical data Storage. Physically, data will get stored in Datafiles. Datafiles will be connected to tablespace. A tablespace can have multiple datafiles. A tablespace can have objects from different schemas and a schema can have multiple tablespaces. Database creates “SYSTEM tablespace” by default during database creation. It contains read only data dictionary tables which contains the information about the database.

17. What Contains Oracle Physical Database Structure?

Ans:

It contains:

• Datafiles
• Control Files
• Redo Log Files
• Archive Log Files
• Parameter Files
• Alert and Trace Log Files
• Backup Files

18. How Oracle Works?

Ans:

• An instance has started on the database server.
• A client established a connection to the server, using the proper Oracle Net Services driver.
• The server creates a dedicated server process on behalf of the user process.
• The user executes SQL statements and commits the transaction.
• The server process receives the statement and checks for any shared SQL area that contains a similar SQL.
• The server process retrieves data from datafile (table) or SGA.
• The server process modifies data in the SGA area. The DBWn process writes modified blocks permanently to disk. The LGWR process records the transaction in the redo log file.
• The server process sends a message to the application.

19. How Views Are Used?

Ans:

It provides security by restricting access to a predetermined set of rows or columns of a table. It hides data complexity. It simplifies statements for the user.

An example would be the views, which allow users to select data from multiple tables without actually knowing how to perform a join.

It presents the data in a different perspective from that of the base table. It isolates applications from changes in definitions of base tables. It saves complex queries

20. Define the overview of the Oracle application?

Ans:

21. What Are The Several Tools For Interacting With The Oracle Database Using Sql?

Ans:

There are several tools for interfacing with the database using SQL

• Oracle SQL*Plus and iSQL*Plus
• Oracle Forms, Reports, and Discoverer
• Oracle Enterprise Manager
• Third-party tools

22. What Is An Oracle Instance?

Ans:

When you start, the database instance comes into picture into system memory. Combination of the SGA and the Oracle processes is called an Oracle instance.

23. When Oracle Allocates An Sga?

Ans:

When Oracle starts, it reads the initialization parameter file to determine the values of initialization parameters. After this, it allocates an SGA and creates background processes

24. What Are Data Blocks?

Ans:

Oracle stores data in data blocks also called logical blocks, Oracle blocks or pages. A data block represents specific number of bytes of space on disk.

25. What do you know about the target and offset accounts in the allocation formula?

Ans:

Target	Offset
This option allows you to enter the account in the target line to give the information about the destination for your allocation.The value that you use in the target should be the same parent value that is used in the B and C lines of the formula.	This option allows you to enter the account in the observed line to represent the account to use for allocation of the offsetting debit or credit.The official account usually refers to the same account as the formula line A to reduce the cost by the allocated amount.

26. What Is An Extent?

Ans:

An extent is a specific number of consecutive data blocks allocated for storing a specific type of information

27. What Is Grid Management Feature?

Ans:

The Grid Management feature of Oracle Enterprise Manager 10g provides a single console to manage multiple systems together as a logical group.

28. What Is Storage Virtualization?

Ans:

The Oracle Automatic Storage Management (ASM) is a feature of Oracle Database 10g which provides a virtual layer between the database and storage so that group of disks can be treated as a single disk group and disks can be dynamically added or removed while keeping databases online.

29. What Is Server Virtualization?

Ans:

Oracle Real Application Clusters 10g (RAC) enables a single database to run across multiple clustered nodes in a grid, pooling the processing resources of several standard machines.

30. What is the overview of Oracle TM architecture?

Ans:

31. Do SQL-based metrics support external scripts?

Ans:

No, they don’t support the same. Users need to enter the SQL in the enterprise manager directly and this is done at the time of the creation of the metric. It can even be done at a later stage. However, there are problems with the time and storage allocation which make even simple tasks very complex and users have to adopt other paths to keep up the pace in this matter.

32. What do you know about the user-defined metrics in Oracle?

Ans:

When it comes to enterprise manager monitoring, the reach and strength of the same can easily be extended up to a great extent. You might have no idea but the fact is this enables organizations to derive certain benefits. Almost all the conditions which are specific or which seem to be specific for a task can simply be met.

33. What is the logical structure of the disk resources?

Ans:

Following is the logical structure of the disk resources:

Data block: The data block refers to the smallest logical storage unit. Size of a data block is a multiple of the operating system block size.

Extent: It refers to the contiguous set of data blocks, which is allocated as a unit to a segment.

Tablespace: The tablespace refers to the final logical storage unit. It is mapped to the physical datafile.

Segment: The segment allocates a logical structure, such as a table. It is a set of extents, which are stored in the same tablespace.

34. How do you find the total database size in the database?

Ans:

You can use the following database views to get the information on database size:

Dba_segments: It provides information about the used space. You can take a total of all the bytes in the dba_segments view to get the used space.

Dba_data__files: It provides information on space allocated to datafiles for permanent tablespaces.

v$log: It provides information on redo log files.

35. Differentiate between Oracle DBA and Oracle Developer.

Ans:

Oracle DBA	Oracle developer
The key role of an Oracle DBA is about managing the Databases.	The key role of Oracle Developer is to develop the code.
It contains streamlined tasks. The working environment maintains the databases.	It contains a wide range of tasks. The working environment develops databases.
It works on the backend database management area.	It works on the frontend development area.
Other tasks include Backup, recovery, server connectivity, etc.	Other tasks include Coding, designing UI, etc.

36. What are the main aspects of Oracle database security management?

Ans:

• Controlling access to data(authorization).
• Restricting access to legitimate users (authentication).
• Ensuring accountability on part of the users(auditing).
• Safeguarding key data in the database(encryption).
• Managing the security of the entire organizational information structure (enterprise security).

37. Which tools can you use to start up an Oracle database?

Ans:

You can start up a database with three tools.

SQL*Plus: This is the most widely used option. You first connect to an idle instance with SQL*Plus and then startup the instance with the “startup” command.

Oracle Enterprise Manager: This is another way of starting up a database. You can logon to Oracle Enterprise Manager even if the database is stopped. OEM will detect the status of the down database and will present you with a “Startup” button. You can start the database by clicking this button.

RMAN: This is rather a less used tool for starting up a database but it is possible to startup a database from the Recovery Manager command line.

38. Which components of your database environment can be protected by an “Oracle Restart” configuration?

Ans:

Database Instances and Automatic Storage Management (ASM): Database instances and ASM instances will be restarted if they crash somehow.

Oracle NET Listener: Oracle NET Listener will be started if it crashes and stops listening for an incoming connection.

ASM Disk Groups: Oracle Restart will mount ASM Disk groups if they are dismounted.

Database Services: Non-default database services will be started by the Oracle Restart feature.

Oracle Notification Services (ONS): This is another Oracle component that can be protected by Oracle Restart.

39. What is a Resource Plan?

Ans:

The resource plan lays how resource consumer groups will allocate the resources. Each resource plan contains a set of resource consumer groups that belong to this plan, together with instructions as to how resources are to be allocated among these groups.

For instance, a resource plan may dictate CPU resources be allocated among three resource consumer groups so that the first group gets 60 per cent and the remaining two groups get 20 per cent each of the total CPU time.

40. Define Oracle TM ATG Web commerce?

Ans:

41. What are the uses of a database Resource Manager?

Ans:

The database resource manager enables us to limit the length of time a user session can stay idle and to automatically terminate long-running SQL statements and user sessions.

We can set initial login priorities for various consumer groups by using the database resource manager.

We can specify the maximum number of concurrent active sessions for a consumer group by using the concept of active session pool. The Database resource manager will automatically queue all the subsequent requests until the currently running sessions complete.

42. What do you mean by recovery catalog?

Ans:

A recovery catalogue is a database plan that holds the metadata used by RMAN for reinstallation and healing processes. It stores information on:

• Data files & their backup file.
• Incarnation.
• Stored scripts.
• Backup history.
• Archived Redo Logs & their backup sets.

43. What does RMAN backup consist of?

Ans:

RMAN backup consists of a backup of all or part of a database.

This results from issuing an RMAN backup command.

A backup consists of one or more backup sets.

44. What are the architectural components of RMAN?

Ans:

Following are the architectural components of RMAN:

• RMAN executable.
• Server processes.
• Channels.
• Target database.
• Recovery catalog database.
• Media management layer.
• Backups, backup sets and backup pieces.

45. What is a backup set?

Ans:

A backup set is a logical grouping of backup files that are created when you issue an RMAN backup command.

It is RMAN’s name for a collection of files associated with a backup. A backup set is composed of one or more backup pieces.

46. Which files must be backed up?

Ans:

The following files must be backed up:

• Database files.
• Control files.
• Archived log files.
• Password files.
• INIT.ORA.

47. What is instance recovery?

Ans:

Instance recovery is used in Real Application Cluster (RAC) environments only.

It occurs in an open database when one instance detects that another instance has crashed.

48. Explain the procedure of restoring RMAN for the recovery if all the instances are down.

Ans:

Following is the procedure of restoring RMAN for the recovery:

• Bring all the nodes down.
• Start a node.
• Restore all the data files and archive logs.
• Recover the node.
• Open the database.
• Bring other nodes up.
• Confirm that all nodes are operational.

49. What is an ASM Disk Group?

Ans:

It is a group of disks that ASM manages as a unit. Within the disk groups, a file system interface maintains the Oracle database files. ASM simplifies database storage by consolidating disks into disk groups. This reduces I/O overhead.

50. What is Oracle gate architecture?

Ans:

51. What is an ASM instance?

Ans:

It is an instance that manages ASM disk groups. It comprises the System Global Area(SGA) and background processes. ASM instance mounts a disk group that is made available to the database instance. An ASM instance manages the metadata of a disk group and provides file layout information to the database instances.

52. What are the dynamic performance views? Who has the access to these views?

Ans:

Dynamic performance views are also called V$ views. These views provide information about the sessions. Any Oracle user can get information from dynamic performance views if the user has to select any table privilege. This privilege is generally granted through the SELECT_CATALOG_ROLE role.

53. What are the differences between EBU and RMAN?

Ans:

EBU	RMAN
Enterprise Backup Utility (EBU) is a functionally rich, high-performance interface for backing up Oracle databases. It is sometimes referred to as OEBU for Oracle Enterprise Backup Utility.	The Oracle Recovery Manager (RMAN) utility that ships with Oracle8 and above is similar to Oracle7’s EBU utility. However, there is no direct upgrade path from EBU to RMAN.

54. Why is performance tuning a menacing area for DBA’s?

Ans:

The performance tuning field can’t be automated like other features of exp/imp, backup recovery.This is an area that requires more detective work to be carried on part of application programmers and DBA’s to check how some process is running slower than expected, why can’t we scale applications to a larger number of users without problems like performance degradation etc. This is an area where the technical knowledge must be used along with constant experimentation and observation.

55. What are the different levels of auditing?

Ans:

There are three different levels of auditing:

Statement Auditing: It allows you to track who is issuing a specific type of statements. The AUDIT statement form of the AUDIT command allows you to specify any SQL statement to be audited.

Privilege Auditing: It lets you track the use of system privileges. In the AUDIT command, you can specify any system privilege. An audit record will be generated any time you exercise the specified system privilege.

Object Auditing: It is the auditing of accesses to specific schema objects without regard to the user. It can audit all SELECT and DML statements permitted by object privileges, such as SELECT or DELETE statements on a particular table.

56. Is it possible to define new metrics with the help of a custom operating system in Oracle ™?

Ans:

Yes, this is possible. Generally, the operating system-based approach is considered for this purpose and users can always make sure of authenticity in this task

57. For what purpose can you use OS-based metrics?

Ans:

These are generally considered when it comes to monitoring a specific condition. A custom script can easily be written with the help of which this task can easily be accomplished. The script will be specified each time when the enterprise manager is evaluated. However, it depends largely on the script for returning its value.

58. What are the types of user-defined metrics that can be used for extending the monitoring capabilities?

Ans:

These are:

Operating system based user Defined metrics

SQL based user-defined metrics

59. What is the role of custom scripts of SQL queries in Metrics?

Ans:

SQL queries, custom calls as well as custom scripts are deployed for the same purpose and i.e. for the purpose of monitoring metrics and triggering the alerts. This makes sure of the smooth flow of the operations in the shortest possible manner and without calling any extra functions for the same.

60. Define Oracle application integration?

Ans:

61. Can you register your script in the console? When is it generally done?

Ans:

Yes, it’s possible for the users to perform this task. However, under normal conditions, it is not done. When there are some critical warnings or a specific threshold is reached, registration in the console is then done. The fact is there are restrictions for registrations at the other locations and the console can be used as the last option for this task.

62. What is the first step for the execution of a script after it is created?

Ans:

It is necessary that the scripts must have the starting point as em_results for a new line wherever it is mentioned. If this condition is not fulfilled, there is always a runtime error on the screen and users have to pay attention to a number of facts for the clearance of the same. Thus it must be considered on priority.

63. Can the user submit multiple em_message tags to the metrics?

Ans:

Yes, users can do so. However, the next message always remains under the queue until the first one is completely executed. Also, it is not possible in all cases. In a few cases, users are not allowed to do so. This is common with the scripts that have multiple tags already with them by default.

64. When situation represents a metric error in the metrics and how this can be eliminated?

Ans:

When the non-zero value is displayed on the screen or when the STDOUT and STDERR messages are not available on the exact location, this indicates the error. Users either need to execute the task again or there is a need for them to reconcile the activities which are considered to eliminate the same.

65. What do you know about the script location in Oracle ™?

Ans:

Well, it is recommended that the OS scripts which are user-defined must remain at a location that should be outside the agent’s home. Actually, it makes sure that no harm is caused to the script when the agent is updated. This always makes sure that the script remains operational under all the conditions. When you have to register it in the control console, the full path must be specified to the script. In some cases, users are not allowed to use the default properties.

66. What Is The Difference Between Large Dedicated Server And Oracle Grid?

Ans:

Dedicated server	Oracle server
It has expensive components.	It has low cost modular components.
High incremental costs.	Low incremental costs
It has a single point of failure.	It has no single point of failure.

67. What do you need to do to make the features available in metrics after creating the same?

Ans:

Well, in Oracle TM, users need not worry about the same. This is because once the metrics get created, all the required features become available automatically. This is one of the best things about creating metrics that can be deployed for any purpose under the defined conditions.

68. From where you can access the SQL-based metrics?

Ans:

Basically, it is accessed through the target home pages of the databases. When it comes to custom database management, they are generally called for deployment purposes. In case the time-saving approach is to be considered, the functions can also be called in a very easy manner to fulfill similar or parallel tasks without deriving the extra time.

69. Can you name a few important features that are available in metrics?

Ans:

These are:

• Notifications related to the current tasks
• System alerts
• Corrective actions taken by the users
• Historical collections
• Metric monitoring
• Allocation related features

70. What is Oracle database server architecture?

Ans:

71. Tell something about the script runtime environment?

Ans:

Upon the evaluation of user-defined metrics, the script also gets executed and is generally specified at the same time when the script is registered in the EM console. Users need to make sure that the information provided for the authentication purpose must belong to a valid or an active account.

72. What is Echo in Oracle Mediator?

Ans:

To make it act or respond to a callable service that uses an echo option for that reason.It significantly contributes to the smooth running of the Oracle Mediator without the need for a particular route to operate the operation. The responsible Oracle Mediator performs numerous tasks, such as assignment, transformation, scheduling and much more. This will ultimately help make the Oracle Mediator echo back to the submission.

73. How about the audit feature in Fusion Application?

Ans:

The Oracle Fusion Middleware Audit Process extends to all sorts of work-related activities of the Fusion Application. Responsibility for any work process is greatly controlled solely by the audit feature.

74. Briefly describe the purpose of the state journal?

Ans:

A Stat journal is used to associate the statistical amounts with the monetary amount by making use of the statistical units of measure. It also provides the flexibility to enter both the statistical and the monetary amount in a single journal entry line.

75. Briefly list out the value set security types?

Ans:

The following are the value set security types available:

No security: This security type means that the security is disabled for this value set.

Hierarchical security: This security type provides the features of the valued security and the value hierarchy and combines them. This Security feature makes sure that any security that is applied to the parent value will also be applicable to the child value.

Non-hierarchical security: In the non-hierarchical security type, the security is enabled, but the rules of the hierarchical security are not applicable.

76. Are Oracle Fusion Applications Available for Purchase?

Ans:

Oracle Fusion Application is extremely available to buy by the consumer in any market place. Clients can simply purchase and update it for a fixed period of time, based on their preference option. The actual system needs to be carried out under Oracle Certified Certification for all such migration/purchase programmes.

In its initial publication, the Oracle authority will only review and study the customer’s expectations.

77. Give a brief idea about flex field qualifiers in GL?

Ans:

There are different types of flex field qualifiers in GL. They are represented below:

Natural account: You need to know that each accounting flex field structure should contain only one natural account segment. You will need to indicate the type of the account as asset or liability, owners equity, expense or revenue when you are setting up the values.

Balancing account: Each flex field structure should contain only one balancing account. Oracle GL is very keen about ensuring all the journals balance for each balancing segment.

Cost centre: It is required by the Oracle assets which are used in many of the Oracle assets reports and by the Oracle workflow. It is used to generate the account numbers. You can also utilize the cost Centre segment that allows or provides you with the Oracle apps training and Oracle purchasing.

Intercompany: The Oracle GL is flexible as it automatically uses intercompany segments to track the intercompany transactions taking place with a single set of books. This segment maintains the same value set and the same values as the balancing segment.

78. How about the Approval Management in Fusion Application?

Ans:

In Fusion Applications, the human workflow is handled exclusively by AMX,which serves as the assignment manager to model the approval pattern based on the job needs and preferences.

79. How is security for Oracle Fusion Application?

Ans:

The application is highly protected with commonly recognised features such as:

• Security of data
• RBAC’s
• Privacy policy
• Protection Feature
• Access provisioning and identity management

80. What is Oracle database internal mechanism?

Ans:

81. How can administrators add custom features in metrics?

Ans:

Well, this approach is simple. For this, administrators can simply add their custom monitoring scripts library by integrating the same with the enterprise manager. A user-defined metric can be considered for the effective integration and the good thing is users can simply make sure of quality results. The SQL-based metric is commonly considered for this purpose.

82. Name the two steps which are common in creating the operating System based user-defined metrics

Ans:

These are:

• First creating the Operating system monitoring script
• Registering the script as a user define metric
• It is also possible in some cases to use it without registration. However, its capabilities remain limited under such a condition.

83. On a particular file system, is it possible that the exact amount of free space can be calculated?

Ans:

Yes, this is possible and is generally done with the help of defined logic that is responsible for running the code. Users are free to access the same anytime they want and the good thing is it can be customized for extending its capabilities. If the scripts contain a lot of sections or files, there are chances that the displayed information regarding the memory could be wrong and thus appropriate actions are required for the same.

84. Which value is to be returned by the script after monitoring the object? What does this indicate?

Ans:

The script should return the value which is associated with the monitoring object. This indicates that there is nothing wrong with the object and the same can be executed further. Returning of this value also states that all the warnings which are related to the object have also been considered. Sometimes it takes extra time for returning this value and under such conditions, users can manually fetch the same with the metric allocation tools.

85. Do you think there is anything which is common in all the monitoring scripts used in the metrics?

Ans:

Yes, they all must contain the code for performing some basic functions. The two very important ones are Code for the purpose of checking the status of objects monitored. The second is the code to return the script outcomes to the enterprise manager. Users are free to keep similar information in them if they are meant to perform similar tasks.

86. Name one interpreter that scripts generally require? Where should it be installed?

Ans:

Perl is the interpreter that scripts generally need. It must be installed on the host system.

87. What is the significance of configuring the script runtime environment?

Ans:

This actually makes sure that all the scripts can simply be adopted by the management agent for the considered purpose. In case it is not confirmed, scripts always have a limit on their functionality. There are also chances that a few of them don’t work in the way they have to be. In addition to this, configuring the script runtime always makes sure that multiple metrics can be created at the same time without the use of maximum features or tools.

88. Is there any condition on the location of scripts that generally run with user-defined metrics?

Ans:

Yes, there is a basic condition and i.e. they all should be placed in a directory to which the agent must have complete access. Any script outside the directory is generally ignored and users will not be able to use the same unless it is specified in the directory. In case the directory is full, users have the provision to create a new directory and assign the name as per their wish

89. Are users free to consider the scripting language of their choice for creating a script?

Ans:

When it comes to creating a script that has the information or commands for the purpose of checking the condition under monitoring, users are always free to use the scripting language of their choice. This is one of the best things about metrics that are available with the Oracle ™.

90. What is the Oracle business concept?

Ans:

91. How can you improve the performance of Sql*loader?

Ans:

You can use direct path load to improve the performance. Indexes and constraints make inserts slow. Removing indexes and constraints improve performance of inserts; and therefore, of SQL*Loader.

92. What Is Oracle Database?

Ans:

Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated from each other

93. Explain Oracle Grid Architecture?

Ans:

Grid computing is an information technology architecture that provides lower cost enterprise information systems. Using grid computing, independent hardware, and software components can be connected and rejoined on demand to meet the changing needs of businesses. It also enables the use of smaller individual hardware components