Register
Login
What is Oracle? Oracle Training Tutorials for BeginnersDifference Between Oracle 11g and 12c and 10g Import 12c Oracle Dump to 11gOra 28001 The Password Has Expired ErrorCache and Nocache in Oracle SequenceBR*Tools DocumentationORA-01455: Converting Column Overflows Integer DatatypeOracle Wait Events Interview QuestionsDifference Between Primary, Secondary and Clustered Indexes in DBMSDifference Between Hot and Cold BackupOracle Partitioning Interview QuestionsUpdate Statement Works in Oracle ArchitectureDifferences Between SAP HANA and OracleGroup Functions Ignore Null Values in Processed ColumnORA-10458: Standby Database Requires RecoveryOracle Interview Questions
Tutorials
- What is Oracle?
- Oracle Training Tutorials for Beginners
- Difference Between Oracle 11g and 12c and 10g
- Import 12c Oracle Dump to 11g
- Ora 28001 The Password Has Expired Error
- Cache and Nocache in Oracle Sequence
- BR*Tools Documentation
- ORA-01455: Converting Column Overflows Integer Datatype
- Oracle Wait Events Interview Questions
- Difference Between Primary, Secondary and Clustered Indexes in DBMS
- Difference Between Hot and Cold Backup
- Oracle Partitioning Interview Questions
- Update Statement Works in Oracle Architecture
- Differences Between SAP HANA and Oracle
- Group Functions Ignore Null Values in Processed Column
- ORA-10458: Standby Database Requires Recovery
- Oracle Interview Questions
Oracle Forum
- Impdp Multiple Dump Files in Oracle 11G Standard Edition
Hi friends, I am facing issue while importing multiple dump files in Oracle 11G Standard Edition. I did export using expdp with parameter filesi ... - Difference between CRSCTL and SRVCTL
Answered
CRSCTL vs. SRVCTLHello Experts,May I know What is difference between CRSCTL and SRVCTL ?Please share your views.Thanks in advance. ... - ORA-02021: DDL Operations Are Not Allowed On a Remote Database
Answered
Hi, I am getting following error when I try to create a table in remote database. ORA-02021: DDL operations are not allowed on a remote database ... - Which syntax turns an existing constraint on?
Q. Which syntax turns an existing constraint on? A. ALTER TABLE table_name ENABLE constrain_name B. ALTER TABLE table_name STATUS = ENABLE CON ... - In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed statement?
Q. In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed statement? A. immediately after the SELECT clause B. b ... - Difference Between Select * from sys.dba_users and Select * from dba_users
Answered
Select * from sys.dba_users vs Select * from dba_usersHello Experts,What is the difference between Select * from sys.dba_users and Select * from dba_u ... - Oracle DBA Interviews Question Asked By WIPRO
Answered
Hello Experts,1) In DG stand_file_management=manual what is the meaning of this parameter?2) We can restore the backup in the same mount point by usin ... - What are two reasons to create synonyms?
Q. What are two reasons to create synonyms? (Choose two.) A. You have too many tables. B. Your tables are too long. C. Your tables have diffic ... - What is true about sequences?
Q. What is true about sequences? A. Once created, a sequence belongs to a specific schema. B. Once created, a sequence is linked to a specific t ... - How to check utlrp.sql running in background or not?
Hi All, How to check utlrp.sql running in background or not? Recently executed utlrp.sql 2 hours later session got disconnected. Now I want to know ... - You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator"=" What happens when the main query is executed?
Q. You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator"=" What happens when the main query is ... - Resolving Fragmentation in Tablespace in Oracle 11g
Answered
Hi All, I have been asked by my senior to identify the fragmentation in the tablespace and the also resolve the same. Please help me out how to d ... - Mark for review Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed?
Q. Mark for review Evaluate the SQL statement: SELECT ROUND(45.953, -1), TRUNC(45.936, 2) FROM dual; Which values are displayed? A. 46 and 45 B. ... - Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000?
Q. Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater than 5000? A. ORDER BY SALARY ... - For which two constrains does the Oracle Server implicitly create a unique index? (Choose two
Q. For which two constrains does the Oracle Server implicitly create a unique index? (Choose two) A. NOT NULL B. PRIMARY KEY C. FOREIGN KEY D. ... - Mark for review Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)
Q. Mark for review Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.) A. It releases t ... - You are granted the CREATE VIEW privilege. What does this allow you to do?
Q. You are granted the CREATE VIEW privilege. What does this allow you to do? A. create a table view B. create a view in any scheme C. create ... - Which two statements about creating constraints are true? (Choose two)
Q. Which two statements about creating constraints are true? (Choose two) A. Constraint names must start with SYS_C. B. All constraints must be ... - Which SQL statement defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?
Q. Which SQL statement defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table? A. CREATE TABLE EMP (empno NUMBER(4), ename VARCHA ... - Mark for review In which two cases would you use an outer join?
Q. Mark for review In which two cases would you use an outer join? (Choose two.) A. The tables being joined have NOT NULL columns. B. The table ... - Which four statements correctly describe functions that are available in SQL? (Choose four)
Q. Which four statements correctly describe functions that are available in SQL? (Choose four) A. INSTR returns the numeric position of a named ch ... - Which Process reads and write data from Datafiles?
Answered
Hello Experts,May I know that which process reads and write data from Datafiles?Kindly share your valuable views here.Thanks in advance. ... - Which three SELECT statements display 2000 in the format "$2,000.00"? (Choose three.)
Q. Which three SELECT statements display 2000 in the format "$2,000.00"? (Choose three.) A. SELECT TO_CHAR(2000, '$#,###.##') FROM dua ... - ORA-01749 Error - GRANT/REVOKE privileges to/from yourself
I can query data from two user but create a view with that view in Oracle 11g.Error as ORA-01749 you may not GRANT/REVOKE privileges to/from yourself. ... - Change to DEFAULT value affects only subsequent insertions to the table
Q. The EMPLOYEES table has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALA ... - Which SQL statement displays last names of those employees?
Q. You need to display the last names of those employees who have the letter "A" as the second character in their names. Which SQL statement ... - How to Change DDIC Passwords in 000 Client on SYBASE ASE Database?
Hello Experts,I am getting login issues with sap* and DDIC passwords in 000 client on SYBASE ASE database. And the issue is that how to change those p ... - Which two statements accurately describe a role in Oracle?
Q. Which two statements accurately describe a role? (Choose two) A. a role can be given to a maximum of 1000 usersB. a user can have access to a maxim ... - Difference between Listener and Scan Listener
Answered
Hello Experts,My question is about,What is the difference between listener and scan listener?Need help regarding above.thanks ... - In which scenario would an index be most useful?
Q. In which scenario would an index be most useful? A. The indexed column is declared as NOT NULL. B. The indexed columns are used in the FROM c ...
×