Correct Answer: Tablespaces, segments, extents, and Oracle blocks
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Oracle 9i Administration Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Oracle 9i Administration MCQ Questions
While preparing to create a database, you must ensure that there is sufficient disk space for the database files. When you calculate the space requirements, you may need to multiplex some of the files. Which of the following types of files would you plan to multiplex?
Which of the following storage structures provides a way to manually store the rows (from more than one table) in the same data block?
Which of the following constraint states prevents new data (that violates the constraint) from entering into the table, but allows invalid data to exist in the table?
The current password file allows five entries. New DBAs have been hired and five more entries need to be added to the file. How can you increase the allowed number of entries in the password file?
Which of the following constitute the advantages that the server parameter file (SPFILE) provides while managing initialization parameters?
When is SGA created in an Oracle database environment?
You have a database with DB_NAME set to STUD and ORACLE_SID set to STUD. These files are in default location for the initialization files: -init.ora -initSTUD.ora -spfile.ora -spfileSTUD.ora The database is started with the command: SQL> startup Which of the following options contain the correct names and sequence of the initialization files that Oracle Server attempts to read?
The information for a dynamic performance view is gathered from the control file.
Which of the following methods is correct for starting an instance to create a database?
You need to drop two columns from a table. Which of the following sequence of SQL statements is used to drop the columns and limit the number of times the rows are updated?