Oracle Database and True Incorrect Correct

Only available on StudyMode
  • Topic: Oracle Database, SQL, Data Manipulation Language
  • Pages : 6 (859 words )
  • Download(s) : 176
  • Published : July 31, 2012
Open Document
Text Preview
Oracle-Architecture Test Breakdown:
1. How many layers does the Oracle database have?
Correct

2. Which of the following components comprise an oracle architecture? Correct

3. A _______________ is used to logically group data together Correct

4. Oracle automatically creates the SYSTEM tablespace
Correct

5. A _____________ is a set of tables physically stored together as one table that shares a common column Correct

6. What is the use of an index?
Correct

7. Which is the smallest unit of storage in an Oracle database? Correct

8. Identify, which of the following below are types of segments? You answered: All of the above
Incorrect

Correct answer: Data Segment

9. Which of the following segment is destroyed when the SQL statement is finished? Correct

10. Which of the following is the most probable use of an extent? You answered: Stores user data within the database
Incorrect

Correct answer: Minimize the amount of wasted (empty) storage

11. The basic memory structures associated with Oracle are the System Global Area (SGA) and the Program Global Area (PGA). Correct

12. The redo log buffer and Shared pool are elements of?
Correct

13. What is the use of Library cache?
Correct

14. The ____________ contains a set of tables and views that Oracle uses as a reference to the database. Correct

15. The size and content of the PGA is independent on the Oracle server options installed You answered: True
Incorrect

Correct answer: False

16. Which area of PGA stores binding variables and runtime buffers information? You answered: Session area
Incorrect

Correct answer: Private SQL area

17. Where is the data dictionary kept?
Correct

18. Can there be more than one datafile per tablespace?
Correct

19. What do the schema objects comprise of?
Correct

20. Which processes is an instance made of?
You answered: All of the above
Incorrect

Correct answer: Oracle background processes

1. What is the System Global Area?
Correct

2. Privileges are assigned to users through ________________ Correct

3. Tables in recycle bin can be recovered back into database by using You answered: Flashback
Incorrect

Correct answer: Flashback Drop

4. When a user process fails, what background process cleans up after it? Correct

5. DBA_DATA_FILES is used for?
You answered: Both b and d
Incorrect

Correct answer: Look at the size of a data file

6. An ALL_ DICTIONARY view is used for
You answered: Displays all relevant information in the entire database Incorrect

Correct answer: Displays all the information accessible to the current user

7. The IMPORT IGNORE option tells import to ignore "already exists" errors You answered: IMPORT
Incorrect

Correct answer: Both a and b

8. Which utility is used to find version of any file?
Correct

9. What is iAS Patch used for?
You answered: To fix bugs associated with ORACLE_HOME
Incorrect

Correct answer: To fix bugs associated with IAS_ORACLE_HOME

10. PFILE is simply a text based file
Correct

11. In which of the files below are parameters stored?
You answered: PARFILE
Incorrect

Correct answer: Both a and b

12. A database is a collection of logical structures of data, or schema objects You answered: True
Incorrect

Correct answer: False

13. What happens if a tablespace clause is left off of a primary key constraint clause? You answered: There is no effect.
Incorrect

Correct answer: Both a and b

14. In which of the files below are parameters stored?
You answered: PARFILE
Incorrect

Correct answer: Both a and b

15. Each tablespace in an Oracle database consists of one or more files called Correct

16. Recycle bin can be turned on or off in the recyclebin=on/off in Correct

17. The ______________ records all changes made to data
Correct

18. Even though a table space may be dropped, the objects and data in it are still available You answered: True
Incorrect

Correct...
tracking img