You have calibrated your RDF.When compiling the calibration table,the correction to be applied to any future RDF bearings is listed against the ______.
A.true bearing of the transmitter
B.relative bearing of the transmitter
C.heading of the vessel
D.time of reception
第1题:
第2题:
第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题:
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?()
第5题:
You are shrinking the SCOTT.EMP table by executing the ALTER TABLE SCOTT.EMP SHRINK SPACE CASCADE statement. What is a prerequisite for shrinking the SCOTT.EMP table?()
第6题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()
第7题:
average row size
last analyzed date
size of table in bytes
size of table in database blocks
number of free blocks in the free list
number of extents present in the table
第8题:
Helping students do self-correction.
Indirect correction.
Tolerating correction.
第9题:
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
第10题:
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.
第11题:
One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
None of the tables are recovered from the Recycle Bin, and the statement returns an error.
第12题:
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
第13题:
第14题:
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?()
第15题:
While designing your database, you have created the EMPLOYEES table as an index-organized 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?()
第16题:
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; ()
第17题:
You work as a database administrator for Certkiller .com. In your transaction application, you have scheduled a job to update the optimizer statistics at05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
第18题:
Average row size
Last analyzed date
Size of table in bytes
Size of table in database blocks
Number of free blocks in the free list
Number of extents present in the table.
第19题:
Helping students do self-correction.
Indirect correction.
Tolerating correction.
Encouraging students to do peer correction.
第20题:
true bearing of the transmitter
relative bearing of the transmitter
heading of the vessel
time of reception
第21题:
Export and import the mapping table.
Drop and re-create the mapping table.
Truncate the mapping table and reinsert the values.
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
第22题:
You must enable the block change tracking feature.
You must have enable the flashback feature.
You must use the OMF in your database.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
第23题:
export and import the mapping table
drop and re-create the mapping table
truncate the mapping table and reinsert the values
use the ALTER TABLE···REBUILD command to defragment the mapping table