Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()
第1题:
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16?()
第2题:
Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database?()
第3题:
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
第4题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
第5题:
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
第6题:
renaming the control files
dropping a user in your database
enabling or disabling redo log archiving
dropping a tablespace in your database
re-creating the control files, after you lost all the control files in your database
第7题:
Use the database link.
Use the SQL*Loader utility.
Use the Oracle Data Pump utility.
Create an external table and leave the data in the flat file
第8题:
configure the database to run in ARCHIVELOG mode
configure the Flash Recovery Area to enable automatic database backup
schedule the database backup using DBMS_JOB package after creating the database
schedule the database backup using Recovery Manager (RMAN)commands after creating the database
schedule the database backup using Database Configuration Assistant (DBCA)while creating the database
第9题:
Restore and recover the datafile.
Restore and recover the tablespace.
Restore and recover the database.
Restore and recover the control file.
Restore and recover the parameter file.
第10题:
The database opens normally.
The database prompts for a database recovery.
The database writer writes to a trace file, indicating that the temporary file is not found.
The database gets mounted and throws an error indicating that the temporary file requires recovery.
第11题:
Database replay
SQL Tuning Advisor
SQL Access Advisor
SQL Performance Analyzer
Automatic Workload Repository compare reports
第12题:
The database is in mount state.
One of the tablespaces is offline.
One of the tablespaces is read only.
The database operates in ARCHIEVELOG mode.
The database operates in NOARCHIEVELOG mode.
第13题:
For which database operation would you need the database to be in the MOUNT state()
第14题:
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?()
第15题:
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?()
第16题:
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()
第17题:
renaming the control files
re-creating the control files
dropping a user in your database
dropping a tablespace in your database
configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
第18题:
backup database all
backup compressed database
backup as compressed backupset database
backup as compressed backup database plus archivelog all
backup as compressed backupset database plus compress archivelog all
第19题:
The time when the last flashback operation in your database was performed.
The time when the first flashback operation in your database was performed.
A list of flashback operations performed in your database using SCN and time.
The approximate time and the lowest system change number (SCN) to which you can flash back your database.
第20题:
Restore and recover the datafile.
Restore and recover the tablespace.
Restore and recover the database.
Restore and recover the control file.
Restore and recover the parameter file.
第21题:
Yes, if the database is in ARCHIVELOG mode
Yes, if the database is in NOARCHIVELOG mode
No, the backup is not usable in any way
Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE
第22题:
by using the RMAN utility
by using the export/import utility
by using the ALTER DATABASE command
by enabling the change tracking feature
第23题:
the time when the last flashback operation in your database was performed
the time when the first flashback operation in your database was performed
a list of flashback operations performed in your database using SCN and time
the approximate time and the lowest system change number (SCN) to which you can flash back your database
第24题:
Reregistering the target database in recovery catalog
Transporting the new tablespaces to the recovery catalog database
Syncronizing the recovery catalog with the target database control file
Performing a fresh backup of the target database to include the new data files in the catalog database