You have a login.ascx control and to display it in a view which method u would use()
第1题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server?()
第2题:
Which two statements are true regarding the database in ARCHIVELOG mode?()
第3题:
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
第4题:
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?()
第5题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal?()
第6题:
Use the command PURGE BINARY LOGS and specify a binary log file name or a date and time to remove unused files
Execute the PURGE BINARY LOGE NOT USED command
Remove all of the binary log files that have a modification date earlier than today
Edit the .index file to remove the files you want to delete
Ensure that none of the attached slaves are using any of the binary logs you want to delete
第7题:
net.exe
logoff.exe
taskmgr.exe
compmgmt.msc
第8题:
The online redo log file Is not allowed to be overwritten.
The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
第9题:
log01.log
logORCL01.log
1_2.logALTER ROLLBACK SEGMENT
ora_1_asdf1234.log
第10题:
When a new log group is added, it would have one member in each disk group.
When a new log group is added, it would have two members in each disk group.
When a new tablespace is added, it would have one data file in each disk group.
When a new log file is added, it would have one member spread across the disk groups.
第11题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第12题:
in
on
in to
off to
第13题:
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
第14题:
You have configured the flash recovery area to store online redo log files, control files, archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it?()
第15题:
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()
第16题:
You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()
第17题:
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now you get an order from your company CIO, you have to identify whether a database integrity check (DBCC CHECKDB) was run for a particular database. Which log file should you examine?()
第18题:
“Did you log in with an administrator account?”
“Have you been to any inappropriate websites?”
“What have you changed since the optical drive worked properly?”
“What has changed since the optical drive worked properly?”
第19题:
increase the size of the redo log buffer
increase the number of redo log groups
increase the number of log writer processes
increase the number of ARCn processes
change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location
第20题:
ALTER DATABASE DROP LOGFILE GROUP 1;
ALTER DATABASE CLEAR LOGFILE GROUP 1;
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
第21题:
multiplexed control files
RMAN obsolete backups
multiplexed online redo log files
archived redo logs that have not been copied to tape
第22题:
When a new log group is added, it would have one member in each disk group.
When a new log group is added, it would have two members in each disk group.
When a new tablespace is added, it would have one data file in each disk group.
When a new log file is added, it would have one member spread across the disk groups.
第23题:
You should perform a log switch
You should make a backup of the database
You should switch the database to the NONARCHIVELOG mode
You should shut down the database instance and perform a complete database recovery
第24题:
The backup fails because one of the archived redo log files is missing.
The backup succeeds but it would be without the missing archived log.
During backup,you are prompted for the alternative destination for the missing archived redo log file.
The backup succeeds because it fails over to one of the alternative archived redo log destinations.