Oracle Financial interview questions

If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true?A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bri

To grant the SELECT privilege on the table CUSTOMER to all users in the database, which statement would you use?a. GRANT SELECT ON CUSTOMER TO ALL USERS;b. GRANT ALL ON CUSTOMER TO ALL;c. GRANT SELECT ON CUSTOMER TO ALL;d. GRANT SELECT ON CUSTOMER TO PUBL

The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE ?C:/DATA01.DBF?;If you create an object in the database without specifying any storage parameters, what will be the size o

Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE;B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS;C. ALTER ROLLBACK SEGMENT RO1 SHRINK;D. ALTER ROLLBACK SEGMENT RO1 SIZE 10

User JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table?ALTER USER JAMES QUOTA 0 ON USERS;a. No more rows can be added to the JOBS tableb. No blocks can be allo

What is the difference when Flex mode is mode on and when it is off?

Choose the option that is not true.a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially

Do you feel pressure in your job? Tell me about it.

Which statement is false?A. Dictionary-managed temporary tablespace can be made permanent.B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A loc

What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written

Can yu delete an employee from a table?.

How effective has your company been in adapting its policies to fit a changing environment?

What is a property clause?

Which data dictionary view can be queried to see whether a user has the EXECUTE privilege on a procedure?a. DBA_SYS_PRIVSb. DBA_TAB_PRIVSc. DBA_PROC_PRIVSd. SESSION_PRIVS

What was the most significant change made in your company in the last six months which directly affected you, & how successfully do you think you implemented this change?

What was the most important idea or suggestion you received recently from your employees? What happened as a result?

How many flexfields are there in total modules

What do you think about the continuous changes in company operating policies & procedures?

What is the difference when confine mode is on and when it is off?

How can you call a form on a form

What is the date tracked option and how to use it?

What does the parameter DIRECT=Y in the export parameter file signify?a. When exporting table data, bypass the SQL buffer cache and read the data blocks directly form the disk to the export file. b. When exporting table data, bypass the SQL processing lay

What is accomplished when you issue the following statement?ALTER USER JOHN DEFAULT ROLE ALL;a. John is assigned all the roles created in the databaseb. Future roles granted to John will not be default rolesc. All of John's roles are enabled, except the

I'm new to oracle apps...please tell me...What is integration between modules? What modules in Order management can be integrated with Financemodules ? How this integration is done?

What has been the highest pressure situation you have been under in recent years? How did you cope with it?

Choose two reasons why you would use a direct ?path load instead of a conventional-path load. a. To restrict users from performing b. To perform parallel loadsc. To disable the generation of redo log entries if the database is in ARCHIVELOG mode. d. The t

How do you enable a role?a. ALTER ROLEb. ALTER USERc. SET ROLEd. ALTER SESSION

Is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string...what should i do with login.sql script.. i Put it in /Bin directory..but not working.. What should I do?

How do u create custom program for chargeback,null,,null,i tried with the API ,arp_process.crate _chargeback,.,null,,but its not working,null,,null,any other method or suggestions to do this,null,,null,plz respond

Choose the statement that is not true. Direct-path load a. Disables insert triggers on the table and enables them after the load completes. b. Disables referential integrity constraints and enables them after the load completes. c. Disables unique const