CMS专题
单选题Which is the correct command to put the database in ARCHIVELOG mode？（）Aalter database archivelogBalter system enable archivelog modeCalter database enable archiveDalter database archivelog enableENone of the above
题目
alter database archivelog
alter system enable archivelog mode
alter database enable archive
alter database archivelog enable
None of the above
相似问题和答案
第1题：
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command： RESTORE CONTROLFILE FROM AUTOBACKUP； Which of the following statements is true？（）
- A、 The command restores only the missing control file.
- B、 The command restores all the control files.
- C、 The command fails because the database is running.
- D、 This is the correct way to address this problem.
- E、 This is not the correct way to address this problem.
正确答案:C,E
第2题：
If a log file becomes corrupted， it may cause the database to stall. How would you correct such a situation？（）
- A、 Recover the online redo log from backup.
- B、 Delete and re-create the log file.
- C、 Use the alter database clear logfile command to clear the log file.
- D、 Shut down the database and restart it.
- E、 Shut down the database and then mount it. Clear the log file with the alter database clear logfile command and then restart the database with alter database open resetlogs.
正确答案:C
第3题：
A. All the objects of scott are moved to the Recycle Bin.
B. Any objects in the Recycle Bin belonging to scott are purged.
C. All the objects owned by scott are permanently dropped from the database.
D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.
第4题：
Which command will result in a trace file being created with the create controlfile command contained in it？（）
- A、 alter database backup controlfile
- B、 alter database backup controlfile to trace
- C、 alter database controlfile backup
- D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
- E、 alter database begin controlfile backup
正确答案:B
第5题：
Which command is used to open the database after an incomplete recovery？（）
- A、 alter database open
- B、 alter database open repairlog
- C、 alter database open resetlogs
- D、 alter database open resetlog
- E、 alter database resetlogs open
正确答案:C
第6题：
Which command do you use to generate a report of database incarnations？（）
- A、 list incarnation of database
- B、 report incarnation of database
- C、 list database incarnation
- D、 database incarnation list
- E、 report database incarnation
正确答案:A
第7题：
In computer security， AAA stands for authentication， authorization and accounting. Which optionabout the AAA authentication enable default group radius enable command is correct？（）
- A、If the radius server returns an error， the enable password will be used
- B、If the radius server returns a ’failed’ message， the enable password will be used
- C、The command login authentication group will associate the AM authentication to a specifiedinterface
- D、If the group database is unavailable， the radius server will be used
正确答案:A
第8题：
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）
A. 1,6,5,4,7
B. 6,5,4
C. 6,2,3,7
D. 1,6,3
E. The database cannot be recovered
第9题：
Which command would you use to determine what database backups are currently available for restore？（）
- A、 list database backup
- B、 report database backup
- C、 list backup of database
- D、 list summary backup
- E、 report backup of database
正确答案:C
第10题：
Which is the correct command to back up the database， back up the archived redo logs， and then remove the backed-up archived redo logs？（）
- A、 backup database
- B、 backup database and archivelogs
- C、 backup database plus archivelogs
- D、 backup database plus archivelog delete input
- E、 backup database and archivelog delete input
正确答案:D