Que.1. Setting of which parameter can affect the performance of the database?
A. Initialization parameter
B. SGA parameter
C. Memory Parameter
D. Both a and b
Right Answer: C
Que.2. All of the following can ONLY be used with numeric data types except:
A. AVG
B. COUNT
C. CUM
D. STDDEV
Right Answer: B
Que.3. What is the difference between Oracle Forms and App Forms?
A. Oracle forms runs server – side PL/SQL while app forms run client side.
B. App forms use uses exact positioning while Oracle forms don’t.
C. Oracle forms run client – side PL/SQL while app forms run server side.
D. Oracle forms Flash Charts as its integrated charting engine while app forms don’t.
Right Answer: C
Que.4. Which utility is used to find version of any file?
A. ADIDENT UTILITY
B. ADID UTILITY
C. ADIDENTVER UTILITY
D. ADIDVER UTILITY
Right Answer: A
Que.5. The IMPORT IGNORE option tells import to ignore “already exists” errors.
A. IMPORT
B. IGNORE
C. Both a and b
D. Ignore_error
Right Answer: C
Que.6. PFILE is simply a text based file.
A. False
B. True
Right Answer: B
Que.7. In which of the files below are parameters stored?
A. PFILE
B. SPFILE
C. PARFILE
D. Both a and b
Right Answer: D
Que.8. What happens if a tablespace clause is left off of a primary key constraint clause?
A. This results in the index that is automatically generated being placed in then users default tablespace.
B. This can cause serious performance problems.
C. Both a and b
D. There is no effect.
Right Answer: C
Que.9. What is iAS Patch used for?
A. To fix bugs associated with IAS_ORACLE
B. To fix bugs associated with IAS_ ORACLE_HOME.
C. To fix bugs associated with ORACLE_HOME
D. To fix bugs associated with IAS_ORACLE_PATCH
Right Answer: B
Que.10. A database is a collection of logical structures of data, or schema objects.
A. True
B. False
Right Answer: B
Que.11. An ALL_DICTIONARY view is used for
A. Displays all the information accessible to the current user.
B. Displays all relevant information in the entire database.
C. Displays all the information from the schema of the current user.
D. All of above
Right Answer: A
Que.12. Tables in recycle bin can be resolved back into database by using.
A. Flashback
B. Flashback Drop
C. Revoke
D. Revoke_Table
Right Answer: B
Que.13. Which of the following is the root directly for oracle?
A. ORACLE_HOME
B. ORACLE_ROOT
C. ORACLE_BASE
D. ORACLE_SERVER
Right Answer: C
Que.14. What do the schema objects comprise of?
A. Table
B. Index
C. Cluster
D. All choices are correct.
Right Answer: D
Que.15. DBA_DATA_FILES is used for?
A. Look at all data files.
B. Look at all the characters of a data file
C. Both b and d
D. Look at the size of a data file.
Right Answer: D
Que.16. Which process is an instance made of?
A. Oracle background processes
B. Memory processes
C. Data processes
D. All of the above.
Right Answer: A
Que.17. Privileges are assigned to users through ______________.
A. DBA
B. Role
C. Table
D. Dictionary
Right Answer: B
Que.18. What TRUNCATE and DELETE commands does
A. To retrieve rows in a table
B. To remove some part of a table
C. To get rid of all rows in a table.
D. To recover all the rows deleted in a table.
Right Answer: C
Que.19. When a user process fails, what background process clean up after it?
A. PCLEAN
B. PFAIL
C. PMON
D. Both a and c
Right Answer: C
Que.20. What is the System Global Area.
A. Memory area that contains data shared between all database users.
B. Memory area that contains data shared between selected database users.
C. Remote Memory area that contains data shared between one database users.
D. Remote Memory area that contains data shared between all users.
Right Answer: A
A. Initialization parameter
B. SGA parameter
C. Memory Parameter
D. Both a and b
Right Answer: C
Que.2. All of the following can ONLY be used with numeric data types except:
A. AVG
B. COUNT
C. CUM
D. STDDEV
Right Answer: B
Que.3. What is the difference between Oracle Forms and App Forms?
A. Oracle forms runs server – side PL/SQL while app forms run client side.
B. App forms use uses exact positioning while Oracle forms don’t.
C. Oracle forms run client – side PL/SQL while app forms run server side.
D. Oracle forms Flash Charts as its integrated charting engine while app forms don’t.
Right Answer: C
Que.4. Which utility is used to find version of any file?
A. ADIDENT UTILITY
B. ADID UTILITY
C. ADIDENTVER UTILITY
D. ADIDVER UTILITY
Right Answer: A
Que.5. The IMPORT IGNORE option tells import to ignore “already exists” errors.
A. IMPORT
B. IGNORE
C. Both a and b
D. Ignore_error
Right Answer: C
Que.6. PFILE is simply a text based file.
A. False
B. True
Right Answer: B
Que.7. In which of the files below are parameters stored?
A. PFILE
B. SPFILE
C. PARFILE
D. Both a and b
Right Answer: D
Que.8. What happens if a tablespace clause is left off of a primary key constraint clause?
A. This results in the index that is automatically generated being placed in then users default tablespace.
B. This can cause serious performance problems.
C. Both a and b
D. There is no effect.
Right Answer: C
Que.9. What is iAS Patch used for?
A. To fix bugs associated with IAS_ORACLE
B. To fix bugs associated with IAS_ ORACLE_HOME.
C. To fix bugs associated with ORACLE_HOME
D. To fix bugs associated with IAS_ORACLE_PATCH
Right Answer: B
Que.10. A database is a collection of logical structures of data, or schema objects.
A. True
B. False
Right Answer: B
Que.11. An ALL_DICTIONARY view is used for
A. Displays all the information accessible to the current user.
B. Displays all relevant information in the entire database.
C. Displays all the information from the schema of the current user.
D. All of above
Right Answer: A
Que.12. Tables in recycle bin can be resolved back into database by using.
A. Flashback
B. Flashback Drop
C. Revoke
D. Revoke_Table
Right Answer: B
Que.13. Which of the following is the root directly for oracle?
A. ORACLE_HOME
B. ORACLE_ROOT
C. ORACLE_BASE
D. ORACLE_SERVER
Right Answer: C
Que.14. What do the schema objects comprise of?
A. Table
B. Index
C. Cluster
D. All choices are correct.
Right Answer: D
Que.15. DBA_DATA_FILES is used for?
A. Look at all data files.
B. Look at all the characters of a data file
C. Both b and d
D. Look at the size of a data file.
Right Answer: D
Que.16. Which process is an instance made of?
A. Oracle background processes
B. Memory processes
C. Data processes
D. All of the above.
Right Answer: A
Que.17. Privileges are assigned to users through ______________.
A. DBA
B. Role
C. Table
D. Dictionary
Right Answer: B
Que.18. What TRUNCATE and DELETE commands does
A. To retrieve rows in a table
B. To remove some part of a table
C. To get rid of all rows in a table.
D. To recover all the rows deleted in a table.
Right Answer: C
Que.19. When a user process fails, what background process clean up after it?
A. PCLEAN
B. PFAIL
C. PMON
D. Both a and c
Right Answer: C
Que.20. What is the System Global Area.
A. Memory area that contains data shared between all database users.
B. Memory area that contains data shared between selected database users.
C. Remote Memory area that contains data shared between one database users.
D. Remote Memory area that contains data shared between all users.
Right Answer: A
No comments:
Post a Comment