Oracle Forum
- How to Check whether the Database is Running or not from the OS level ?
Answered
Hello Experts, I have this below question which is asked in a interview May I know how to check whether the database is running or not from the ... - How to Find the Parameter Whether its Static or Dynamic?
Hello Friends,How to find the parameter whether its static or dynamic? Do you know any solution for my above mentioned query? If yes then please expl ... - Difference between NETCA and NETMGR
Answered
Hello Everyone,What is difference between NETCA & NETMGR.Both Utilities work on oracle 10g and 11g.Then what is the differences ?Please share your ... - Difference Between Dictionary Managed and Locally Managed Table space.
Answered
Dictionary Managed Tablespace vs Locally Managed TablespaceHello Experts,What is the difference between Dictionary Managed and Locally Manag ... - Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? (Choose four.)
Q. Evaluate the SQL statement DROP TABLE DEPT; Which four statements are true of the SQL statement? (Choose four.) A. You cannot roll back this statem ... - Mark for review Which two statements are true about WHERE and HAVING clauses? (Choose two.)
Q. Mark for review Which two statements are true about WHERE and HAVING clauses? (Choose two.) A. A WHERE clause can be used to restrict both rows ... - Which SQL statement returns a numeric value?
Q. Which SQL statement returns a numeric value? A. SELECT ADD_MONTHS(MAX(hire_Date), 6) FROM EMP; B. SELECT ROUND(hire_date)FROM EMP; C. SEL ... - Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHAR(30) SALARY NUMBER(8,2) Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only if the minimum salary is less than 5000 and maximum salary is more than 15000?
Q.Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) ... - What is necessary for your query on an existing view to execute successfully?
Q. What is necessary for your query on an existing view to execute successfully? A. The underlying tables must have data. B. You need SELECT p ... - Difference between SYSDBA Privileges and SYSOPER Privileges
Answered
Sysdba Privileges vs. Sysoper PrivilegesHello everyone,Why SYSOPER has limited session privilege?SQL> show user;USER is "SYS"SQL> ... 
Difference between Bulk Collect and Forall
Answered
Bulk Collect vs ForallHello Experts,May I know what is the difference between Bulk Collect and FORALL?Suppose I am inserting 10000 records due to some ...- Import Table from Different Schema
Answered
Hello Experts,May i know how to import table to different schema?please share your valuable thoughtsthanks in advance. ... - Oracle Database EBS RAC Environment Error on DB1
I am getting the following errors on my Node1 of DB. I am using RAC Environment. Database 11g EBS 12.3 R2 This is Node1 which is not running th ... - How Can I Delete Duplicate Records Without Using ROW ID?
Answered
Hello Experts,May I know that how can i delete duplicate records without using rowid and how many ways to find duplicate records?Kindly share your val ... - Oracle Startup Error - Unable to Open File
Answered
Hi , Last week we had a preventive maintenance shutdown at our data center. After that activity when we tried to bring back our servers we started f ... - Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"?
Q. Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? A. SELECT TO_CHAR ... - What Exactly PMON Process do And What will Happen if we Kill It Forcefully?
Answered
Hello Experts,May I know that what exactly pmon process do and what will happen if we kill it forcefully?Kindly share your valuable views here, so i c ... - Which Background Processor Writes to alertlog File?
Answered
Hello Experts,I am having this query that which background processor writes to alertlog file?Kindly share your valuable views here, so i can proceed ... - How to Get Back Dropped Column of A Table?
Hello Users,I made a mistake and I bhave droped(student_address) a column from a table. Now I want to get back so can anyone from you guys tell me tha ... - ORA-12154 PING(ARC2): Heartbeat failed to connect to standby Error in dataguard configuration
Answered
Hello Experts,Could you please explain me that why I am getting this error (ORA-12154 PING(ARC2): Heartbeat failed to connect to standby) while config ... - Is It Possible To Get the Table Name for a Given ROWID ?
Answered
Hi all, Is it possible to get the table name for a given rowid ? if it is possible then how ? Please help . Thanks in advance . ... - Oracle SQL: WARNING: Inbound Connection Timed Out (ORA-3136)
I have Oracle 10g database. Database performance has been quite slow for the past days. Below is part of my alert log. Was wondering if the select ... - which three statements correctly describe the functions and use of constraints? (Choose three)
Q. which three statements correctly describe the functions and use of constraints? (Choose three) A. constraints provide data independence B. co ... - ORA-00205: Error in Identifying Control File after Restart the Database
Answered
Hello Experts,I have created database manually and it is created. After restart the database i am seeing the error:SQL> startupORACLE instance star ... - Interpreting v$segment_statistics
Hello all ;' I am trying to check Information about segment level statistics. but I cannot interpret statistics # , and it's value. Can a ... - How to Use Nested Table in Dynamic SQL
Answered
Hi, I'm trying to build dynamic SQL string, in which I'm using Nested Table as one of the tables. Following is an excerpt: S ... - If Control File is Corrupted then What will happen to Database?
Answered
Hello Experts,If two control files are there for one database, one user already connected to the database, he will do some transactions on database,un ... - What is the Estimate Size of Incremental Backup Size and Compressed Backup Size for 750 GB DB?
Hello Oracle Experts,If db size is 750gb, what is the estimate size of incremental backup size and compressed backup size? If anyone knows then please ... - Recovery of Dropped User
Answered
by mistake i have run the following command drop user hr cascade and i do not have flashback on. please suggest how to recover it. thanks ... - SQL Plus Closes Automatically
Answered
Hi, I have installed oracle 10g. After installation, I have opened sql plus after entering scott and tiger it closes automatically. ...
×