ORACLE Interview Questions -4

1. Which keyword should be used in the CREATE INDEX command to create a function –based index? A. CREATE FUNCTION INDEX… B. CREATE INDEX … ORGANIZATION INDEX C. CREATE INDEX… FUNCTION BASED … D. None of the above
2. Fill in the blank: The parameter MAXTRANS specifies the maximum number of concurrent transactions per ____________ _______.
3. The initialization parameter file has LOG_CHECKPOINT_ INTERVAL = 60; What does this mean?
4. You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB?
5. Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
6. Which parameter specifies the number of transaction slots in a data block?
7. Describe a parallel server configuration.
8. When validating a constraint, why would you specify the EXCEPTIONS clause?
9. When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
10. What is the difference between groupby and orderby?
11. If the application is running very slow? At what points you need to go about the database in order to improve the performance?
12. Which event trigger from the following cannot be created at the database level?
13. A constraint is created with the DEFERRABLE INITIALLY IMMEDIATE CLAUSE. What does this mean?
14. What packages are associated with the LogMiner utility?
15. Choose the right hierarchy, from largest to smallest, from this list of logical database structures.
16. Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?
17. Profiles cannot be used to restrict. a. CPU time used b. Total time connected to the database c. Maximum time a session can be inactive d. Time spent reading blocks
18. 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 database b. Future roles granted to John will not be default roles c. All of John’s roles are enabled, except the roles with passwords d. All of John’s roles are enabled when connecting to the database
19. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.
20. Which of the following statements may require a temporary segment? a. CREATE TABLE b. CREATE INDEX c. UPDATE d. CREATE TABLESPACE