A primary key must have been created.
A mapping table must have been created.
An overflow tablespace must have been specified.
The PCTTHRESHOLD option must have been specified.
第1题:
If you create your database using Oracle Managed Files (OMF), what is true?()
第2题:
You are maintaining your database in Oracle10g. While performing an incremental backup of the database, you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database?()
第3题:
While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第4题:
heap tables
object tables
partitioned tables
indexorganized tables (IOTs)
第5题:
One tablespace has only one datafile
Many tablespaces can share one datafile
One tablespace can have many datafiles
One datafile can contain many tablespaces
第6题:
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
第7题:
The baseline, once created, cannot be removed.
Disable the baseline metrics in the Database Control Manage Metrics page.
The baseline will be automatically removed once the database performance has been optimized.
Drop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.
第8题:
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; ()
第9题:
the CREATE TABLE .. command
sorting of the SYSTEM tablespace’s data
sorting of data required by recursive SQL statements
the CREATE TABLE .. ORGANIZATION EXTERNAL .. command
sorting of data if the users have not been allocated temporary tablespace explicitly
sorting of data if the users have been allocated temporary tablespace explicitly
第10题:
The database will operate normally without generating any redo.
The database will hang, and you must shut down and restart the instance.
The database will crash, and you must recover the database from the point of failure.
The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.