AWS support engineer interview for database administrators

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

1) What is the difference between primary key and unique key?
Primary key uniquely identifies a row. Unique keys are created in columns that will the unique row values. Primary key is unique and not null however unique key can have null values
2) Why are you considering AWS while you have current job as DBA?
This is a very common interpersonal question. You can answer whatever you think of as the answer. But provide an answer that discusses advantage of cloud over on-perm systems. Also, mention that databases in future will be 100% hosted in cloud
3) Why AWS instead of oracle cloud or azure environment?
If your current database profile is oracle DBA, SQL Server DBA the companies that have designed, developed, marketed your databases have their properitor platform for hosting the databases in cloud. To choose AWS over the other vendors major reason is that AWS is a decade old firm , growing extremely fast, stable that is much needed for sustainability of enterprise businesses. They cant choose a vendor for price reasons and waste money on migration projects later
4) What is cloud computing?
This is a very common question that will be part of not only cloud dba but also other cloud support roles. Cloud computing in plain terms is migration of your data center to be taken care of by Amazon
5) What are the many different AWS services supporting databases?
AWS RDS the relational database service supports many databases like mysql, postgresql, oracle, sql server and many more. Amazon dynamodb is popular nosql database. Amazon aurora comes in mysql as well as postgressql flavors that is developed, currently heavily marketed by amazon
6) What is DMS?
The data migration service is a GUI from amazon that supports migration of current databases onto AWS cloud Aurora database. Interestingly feasibility , problems that could be encountered during migration including packages, objects that could be impacted post-upgrade will be listed while making use of DMS. This tool is used for migration of databases

Free AWS Associate exam dumps . Enter your email address:

Delivered by FeedBurner

AWS Certified Associate Exams On Sale



Oracle applications interview questions

What is relationship between rapid clone and autoconfig?
Cloning a critical task that an Oracle applications DBA performs on a regular basis, is the process of creating replicas of source instance.
It is a need to create replica of production instance along with data for the testing team to test some modifications before the changes become live.
In such cases cloning is the process used to create replica of production instance.
Autoconfig had been used in earlier releases of 11i to perform cloning.
Rapid clone is an automated cloning technique which uses Autoconfig internally to perform cloning.
Give details on FNDCPASS, FND Functionality is a functionality in Oracle 11i and R12 :-
FND functionality is use to change the passwords of application user, product schema password, APPS password.
The executable used for performing this task is FNDCPASS.
Directory Location : $FND_TOP/bin
Usage of FNDCPASS and options available can be obtained by typing FNDCPASS in command prompt.
$FNDCPASS
Report Review Agent — FNDFS is a text viewer used by Oracle applications for viewing the log and output files of Concurrent Manager requests.FNDFS executable uses the Report Review Agent Listener in the 8.0.6 Oracle Home installed on the application tier.
The report review agent uses two major configuration files :
1) listener.ora
2) tnsnames.ora
Location of these files — $ORACLE_HOME/network/admin
FNDFS listener is automatically configured by the system.When a user makes a request to view a report, FNDFS program is launched.FNDFS connectivity can be configured by configuring the tnsnames.ora file.
Location of tnsnames.ora file — $TNS_ADMIN/tnsnames.ora
An alias is created for FNDFS_nodename.The tnsnames.ora file defines connections to the FNDFS listener adn it contains the address list of all the services that we can connect to from the client.
FNDFS_nodename=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)
(HOST=hostname)
(PORT=portnumber))
(CONNECT_DATA=(SID=FNDFS))
)
What are different oracle applications database objects?
Different kinds of objects can be stored in the oracle applications database (oracle e-business suite R12). It can be :
1) Materialized view objects – These are hybrid objects. They are used to store and process data
2) Database objects – These objects store data. It includes tables, index, sequence, IOT (Index-organized tables)
3) Code objects – These are program codes. It includes PL/SQL objects such as PL/SQL package, java-stored procedure, synonym, triggers
What is significance of opmn process manager notification server?
Oracle Process Manager And Notification Server (OPMN) is a new feature added in Oracle Applications R12 (release 12) tech stack.OPMN has the primary function of managing oracle application server 10g components including Oracle HTTP Server, OC4J (Oracle For Java) etc..
OPMN is composed mainly of the following three components :
1) Oracle Process Manager
2) Oracle Notification Server
3) Process Manager(PM) Modules
The script to manage OPMN is – adopmnctl.sh
Parameters that can be used with this script – start, stop, status
This script creates the logfile – adopmnctl.txt
Location of logfile – central location of all the logs
Logfile is created when we supply parameters start, stop, status with the adopmnctl.sh script
How to start apps middletier?
Whenever we want to start Oracle middle tier the first step is to start the listener. We can make use of Oracle supplied scripts to start the middle tier listener.. The script adalnctl.sh can be used to start/stop listener to manage the middle tier.The name of middle tier listener is of format APPS_
adalnctl.sh can be used with 3 parameters – start, stop, status
Give details on Oracle application territory support :-
Territory selected sets the defaults for day and week numbering (In USA Sunday is day 1, In Germany and many european countries Monday is Day 1)
It sets defaults for credit and debit symbols, date format, decimal and group numeric seperators, currency symbols
This has profound effect on the way in which application software behaves
How to create schema independent users in oracle OID?
Shared Schemas / Schema Independent Users are the users that are registered and maintaned in a LDAP repository.
LDAP – Lightweight directory access protocol – is the standard that is used by Oracle to implement directory service likInternet Directory(also called as Oracle Internet Directory(OID)).
There is one common schema.Users are saved in directory service.OID has details on user roles assigned at the time of login.Centralized user mangement is achieved using OID.
Give details on oracle e-business proxy authentication:-
Oracle e-business suite and several applications make use of tiered architecture.Database layer is the backend wherein data is stored.Middle-tier is the application tier which is usually made of Web Servers.
When a user tries to access the database data connection has to pass through the application layer/middle tier.
Proxy authorization comes into picture .
SQL>alter user user-name
grant connect through application-user authenticated using password;
The statement mentioned above demands password.For a user to be authenticated at the middle tier use:
SQL>alter user username grant connect through application-user;
What are credit or debit memos?
Credit or debit memos are used to record the credit for goods/services purchased. They are netted with invoices at payment time.
What is use of Oracle management service in middle tier?
The Oracle Management Service(OMS) is the middle tier. Before we can start using the grid control interface, we must firsmake sure that the middle tier OMS is running.At the end of the Grid Control software installation, the OMS should be automatically started by the installer.We can use the following command to check whether the OMS is running:
$ emctl status oms
If server is up we get the message as “Oracle Management Server is up”
If the OMS isn’t running start it up this way:
$ emctl start oms
The server starts with the message “Oracle Management Server is Up”
Give details on oracle coherence datagrid solution:
Oracle coherence 3.6 is the in-memory datagrid solution that has become a component of Oracle Fusion Middleware 11g. Oracle coherence 3.6 is used to address scaling challenges that are common in complex, mission-critical applications in a cost-effective fashion.
1) Oracle coherence provides support for distributed transactions
2) Oracle coherence quorum helps in capacity management, resource management in the grid and cloud frameworks
3) Security is enhanced through the Secure Socket Layer (SSL) connectivity
4) Coherence SQL language CohQL is used to improve efficiency and productivity in development
How to create JMS Resources Create JMS Queue in Oracle SOA?
We can create a JMS resource by using a Weblogic Server console.We create resources in the following order :
JMS queue and connection factory -> connection pool for that connection factory
Follow the steps for creating JMS resources :
1) Ensure that Weblogic server is started. If the Weblogic Server is not opened, open http://localhost:7001/console to start the WEblogic Server Console(WSLS Console). Login using weblogic/welcome1.
Note : Hostname, ports, username, password can be supplied according to your configuration.
2) In the Weblogic Server Console, on the left navigation bar, expand Services/Messaging. Click on JMS Modules
3) A new table popsup. The table is the summary of resources. This table is titled “Customize this table”. On this Summary of resources table, click on New tab.
4) Select the resource type : Queue. Click Next
5) Enter the Name as “ABCDYourValueQueue” and JNDI name as jms/ABCDYourValueQueue, Template : None
6) Click on Next
7) From the subdeployment list, select the SOASubDeployment
8) Under Targets section, from the JMS Servers list, select SOAJMSServer
9) Click on Finish tab.
Give details on Oracle bounda amount types financials:-
The combinations of amount types and boundaries that the system supports are as follows:
If the amount type is PTD, boundary can be Period.
If the amount type is QTD, boundary can be Period or Quarter.
If the amount type is YTD, boundary can be Period, Quarter or Year.
If the amount type is PJTD, boundary can be Period, Quarter, Year, or Project.
Oracle fusion middleware configuration wizard:-
I wanted to install and configure oracle fusion middleware 11g in my laptop. I’ve windows 7 installed in it. I started with downloading and installing Oracle database 10g Express Edition. Next I downloaded the repository creation utility and installed the sample schemas. I installed Oracle Weblogic Server and created middleware home at C:OracleMiddleware. Within the Middleware home Oracle weblogic server is installed. Now weblogic server home usually referred to as WL_HOME is inside the Oracle Fusion Middleware home C:OracleMiddleware. I have my weblogic server binary wlserver_10.3 installed in C:OracleMiddlewarewlserver_10.3. I invoked Quick Start From Start->All Programs->Oracle Weblogic and  I’ve included the middleware configuration wizard step by step screenshot. We start with creating a simple domain, creating an administration server, starting domain in development mode, finally deploying application. Finally we start the weblogic server and access the GUI at http://localhost:7001/
Concurrent Requests programs managers oracle applications:-
Oracle applications – Concurrent Requests, Concurrent Programs, Concurrent Processes, Concurrent Managers will be discussed here.Concurrent manager is an important term that an Oracle Applications DBA encounters frequently.Managing and maintaining concurrent manager is an essential role/function of a DBA.
What is concurrent processing?
Concurrent processing is the process of executing programs in background simultaneously with the online operations (i.e executing foregroun abd background operations simultaneously. In LINUX/UNIX, we can get list of foreground operations using the command fg, background operations using the command bg).
Concurrent processing facility is available in Oracle applications.Most of the background operations are report generation programs.A person with the system administrator responsibility has the privilege to control the number of OS processes associated with running a program.
What is a concurrent request?
When a program is scheduled to be run as a background job, the program to generate the report/program to be run is the concurrent request.Lets say a shell script report.sh is to be run
shell# ./report.sh – concurrent request – this invokes process and can be looked at by issuing :
shell#ps -ef|grep report.sh – This outputs a process lisitng. It is concurrent request.
What is a concurrent program?
The script report.sh is the concurrent program.
What is a concurrent manager?
To start a concurrent program we need a concurrent manager. whenever there is a request to start a concurrent program, the request is inserted into a database table. The request is uniquely identified by a request ID. These requests from tables are read by the concurrent manager. Concurrent managers definition has information on how many operating system (OS)processes are to be dedicated to run the concurrent requests. These processes are referred to as target processes

Free Oracle Database Articles, Tips, Jobs :

Delivered by FeedBurner

What is the use of identity.obj file in oracle applications?

The identity.obj file is saved in the admin node. Admin node has the configuration files and other important files such as application’s environment file, identity.obj file, DBC (database connectivity) file.The identity.obj file is located in the $HOME directory of the application owner.
The identity.obj file is the identity database file that holds trusted digital certificates.Problems to identity.obj file may cause the failure of the jar applications that are regenerated after patching. The error that occurs after patching that may require the identity.obj file to be recreated is the :
Error Message : ERROR: Javakey subcommand exited with status 1
If this error occurs recreate the identity.obj file and use adctrl to restart the failed workers.
A yellow bar will appear at the bottom of the application screens.
We can re-create identity.obj file using the command “adjkey”
$ adjkey -initialize
This command will prompt for an entity name and an organization name.
What is BPEL (Business Process Execution Language)?
1) BPEL expands to Business Process Execution Language
2) This standard emerged in 2003
3) BPEL was developed to enable orchestration of web services using an executab;e XML-based language
4) BPEL allows us to seperate out the definition of our process from the implementation of the services that it orchestrates
5) BPEL provides process flow operators such as conditional branching, parallel flow(split/join), looping etc
6) BPEL process can be exposed as a web service,hence can be included in other business processes