Define the SGA and: How you would configure SGA for a
mid-sized OLTP environment? What is involved in tuning the SGA?
No Answer is Posted For this Question
Be the First to Post Answer
What is the relationship among database, tablespace and data file?
How to select some columns from a table in oracle?
How to load data through external tables?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Explain the different normalization forms?
What is the simplest tool to run commands on oracle servers?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How to create a new user account in oracle?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
how to get last monday of a month?
what is the scenario where you take the database to NoArchivelog mode?
what are corelated subqueries