Oracle Forum
- Error ORA-10458: Standby Database Requires Recovery?
Answered
Hello DBA Experts,Can anyone help me to solve the following query faced me:SQL> startup mount;ORACLE instance started.Total System Global Area 1140 ... - How does Update Statement Works in Architecture Level?
Answered
Hello Experts, I have this query How does update statement works in architecture level? please share your valuable thoughts. &nb ... - Group Functions on Columns ignore NULL Values
Answered
Q. What is true of using group functions on columns that contain NULL values? A. Group functions on columns ignore NULL values.B. Group functions on c ... - Importing Multiple Schema to Another User using IMPDP
Answered
Oracle IMPDP remap_schema Hello Experts, May I know How to import multiple schemas to another user using the impdp? I have tried the followin ... 
Import Oracle 12C Dump in 11.2 Database?
Answered
How to Import Oracle 12C Dump in 11.2 Database? Hello Experts, I want to import Oracle 12c Dump in 11.2 Database but it showing incompatible ver ...- PLS-00352: Unable to Access another Database 'DB_LINK_NAME'
Hello all, Please check procedure and suggest how to resolve it? Procedure: create or REPLACE PROCEDURE hostname (host_name in varchar2,user_na ... - How to Check What Execution Plan the Query Used Yesterday or Some days Back?
Answered
Hello Experts,Today I had an issue for slow running query for one of our warehouse database, where tables and indexes has latest stats yesterday no ne ... - Sum Salary Department Wise
Answered
Hello Experts,Please tell me the solution that how to sum salary department wise as per image: Thanks in Advance! ... - Which clause should you use to exclude group results?
Clause Use to Exclude Group Results Q. Which clause should you use to exclude group results? A. WHERE B. HAVING C. RESTRICT D. GROUP BY E. ... - What is true about joining tables through an equijoin?
Q. What is true about joining tables through an equijoin? A. You can join a maximum of two tables through an equijoin.B. You can join a maximum of two ... - Which SELECT statement will get the result 'elloworld' fromt the string 'HelloWorld'?
Q. Which SELECT statement will get the result 'elloworld' fromt the string 'HelloWorld'? A. SELECT SUBSTR ('HelloWorld',1) ... - In which case would you use a FULL OUTER JOIN?
Q. In which case would you use a FULL OUTER JOIN? A. Both tables have NULL values. B. You want all unmatched data from one table. C. You wan ... - Any Script to Check the Status of Gather stats of a Table/Schema in Percentage (%).
Answered
Hello Experts,Please update me if anybody have any script to check the status of gather stats of a table/schema in percentage (%).Kindly share your va ... - Configuring Content Server to use a File System or Alternative Database Technologies
With Kpro, the opportunity exists to manage electronic documents of different formats within a content repository, using the content server functional ... - How to solve Tablespace Full Issue?
Hi All, I have a tablespace full issue in my environment. Some are saying adding datafiles is good, some are saying resizing datafiles is good. I am ... - Which three statements about subqueries are true?
Q. Which three statements about subqueries are true? (Choose three). A. A single row subquery can retrieve only one column and one rowB. A single row ... - We Run catalog.sql, catproc.sql, pupbld.sql. Why?
Answered
Hello Experts, May I know that During manual DB creation we run catalog.sql, catproc.sql, pupbld.sql. Why? What happend in background ? Pleas ... - Which two statements about views are true? (Choose two)
Q. Which two statements about views are true? (Choose two) A. A view can be created as read onlyB. A view can be created as a join on two or more tabl ... - Mark for review Which two are true about aggregate functions? (Choose two.)
Q. Mark for review Which two are true about aggregate functions? (Choose two.) A. You can use aggregate functions in any clause of a SELECT statem ... - Which two statements about subqueries are true? (Choose two.)
Q.Which two statements about subqueries are true? (Choose two.) A. A single row subquery can retrieve data from only one table. B. A SQL query ... - What is Meaning of Cache and Nocache in Sequence?
Hello friends,I am new to this field and I want to know that what is meaning of cache and nocache in sequence? If anyone is familiar with these terms ... - Difference between AWR and ASH Reports
Answered
Hello Experts,May I know what is the difference between awr and ash?AWR vs ASH ReportsKindly share your valuable thoughts,Thanks in advance, ... - Which two statements are true regarding the ORDER BY clause? (Choose two)
Q. Which two statements are true regarding the ORDER BY clause? (Choose two) A. The sort is in ascending order by default B. The sort is in des ... - What is the purpose of using a subquery?
Q. A subquery can be used to _________. A. create groups of data B. sort data in a specific order C. convert data to a different format D. retr ... - Warning:You are no longer connected to ORACLE.
Answered
Hello Experts,How to fix this problemSQL> conn sys/sys@db11g as sysdbaERROR:ORA-12154: TNS:could not resolve the connect identifier specifiedWarnin ... - Which four are attributes of single row functions? (Choose four.)
Q. Which four are attributes of single row functions? (Choose four.)A. cannot be nestedB. manipulate data itemsC. act on each row returnedD. return on ... - Which operator can be used with a multiple row subquery?
Answered
Q. Which operator can be used with a multiple-row subquery? A. = B. LIKE C. BETWEEN D. NOT IN E. Is F. <> Answer: D Q. What are th ... - Difference between TNS and LDAP Connection
Answered
Hello Experts,My Query is aboutWhat is difference between TNS Connection and LDAP Connections?Need a proper answer for the above.thanks in advance.&nb ... - Which two tasks can you perform using only the TO_CHAR function? (Choose two.)
Q. Which two tasks can you perform using only the TO_CHAR function? (Choose two.) A. convert 10 to 'TEN' B. convert '10' to 10 C. convert ... - You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use?
Q. You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? A. SELECT TO_DATE ( ...
×