多选题What are four capabilities of the mysql client program?（）ACreating, dropping, and modifying tables and indexesBInitiating a binary backup of the database by using the START BACKUP commandCDisplaying replication status informationDShutting down the server by using the SHUTDOWN commandECreating and dropping databasesFCreating and administering users
多选题
What are four capabilities of the mysql client program?（）
A
Creating, dropping, and modifying tables and indexes
B
Initiating a binary backup of the database by using the START BACKUP command
C
Displaying replication status information
D
Shutting down the server by using the SHUTDOWN command
E
Creating and dropping databases
F
Creating and administering users
参考解析
解析：
暂无解析
相关考题：
What are four capabilities of the mysql client program?() A.Creating, dropping, and modifying tables and indexesB.Initiating a binary backup of the database by using the START BACKUP commandC.Displaying replication status informationD.Shutting down the server by using the SHUTDOWN commandE.Creating and dropping databasesF.Creating and administering users
Your network consists of a single Active Directory domain.You install a new backup program. The backup program requires a service account.You create a service account in the domain.You need to ensure that the service account can back up all member servers and client computers in the domain.You must ensure that the service account cannot be used to restore files and folders.What should you do?（）A. Add the service account to the domain Backup Operators group.B. Add the service account to the Backup Operators group on every server and every client computer.C. Assign the Back up files and directories user right by using a Group Policy object (GPO).D. Assign the Impersonate a client after authentication user right by using a Group Policy object (GPO).
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file？（） a. Shut down the database. b. Restore a control-file copy from backup media. c. Use the create control file command to create a new control file. d. Copy the backup control file into place. e. Create a new copy of the control file from one of the surviving control files. f. Recover the database using the recover database using backup control file command. g. Start up the database. A、a， b， f， gB、c， f， gC、a， d， f， gD、a， f， gE、a， e， g
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）A、A backup of the target database when it is mountedB、A backup of online redo log files when the database is openC、A backup of only used data blocks in the file beingbeingbackup upD、A backup of online， read/write data files when the database is openE、A backup of only those data blocks that have changed since a previous backupF、A backup of online， read/write data files when the database is in the NOMOUNT state.
Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning，media failure resulted in corruption of a data file belonging to the TOOLS tablespace. Backups are taken on every Sunday. What would you do in this situation？（）A、recover using Oracle Flashback Database technologyB、restore the data files from backup and perform a complete recoveryC、restore only the corrupted data file and perform tablespace recoveryD、restore the data files from backup and perform cancel-based recoveryE、restore the entire database from the most recent backup and start the instance and open the database
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）A、 take data files from the read-only tablespace offline before performing a recoveryB、 recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the databaseC、 drop the read-only tablespace and re-create the tablespace after recoveryD、 perform a recovery； status of the tablespace in control file will be changed automatically
While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）A、configure the database to run in ARCHIVELOG modeB、configure the Flash Recovery Area to enable automatic database backupC、schedule the database backup using DBMS_JOB package after creating the databaseD、schedule the database backup using Recovery Manager （RMAN）commands after creating the databaseE、schedule the database backup using Database Configuration Assistant （DBCA）while creating the database
Your database is in NOARCHIVELOG mode. You start to do a backup， but your users complain that they dont want you to shut down the database to perform the backup. What options are available to you？（） A、 Put the database in hot backup mode and perform an online backup，including backing up the archived redo logs.B、 Just back up the database datafiles without shutting down the database.C、 You will have to wait until you can shut down the database to perform the backup.D、 Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up.E、 Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the course of the remaining backup
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）A、The backup will consist of used data blocks only.B、The database must be shut down to accomplish the backup.C、The backup can be accomplished without shutting down the database.D、The backup will contain all database files that have never been backed up.
You issued the following RMAN command： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； What is NOT an impact of using the above command？（）A、 When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.B、 When a structural change is made to the database， then a backup of the current control file is performed.C、 When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.D、 When a structural change is made to the database， then a backup of the alert log file will be performed.
You have a read/x7fonly tablespace on read/x7fonly media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read/x7fonly tablespace was read/write when the control file was backed up. What should you consider？（）A、drop the readonly tablespace and recreate the tablespace after recoveryB、take data files from the readonly tablespace offline before performing a recoveryC、perform a recovery; status of the tablespace in control file will be changed automaticallyD、recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
Which view provides information on the backup status of the datafiles in the database?（）A、V$BACKUPB、V$BACKUP_STATUS C、V$BACKUP_DATAFILE D、V$DATAFILE_BACKUP E、V$TABLESPCE_BACKUP
Adam is working as a Database Administrator （DBA） for TeleSoft Corporation. His database is running in the ARCHIVELOG mode. During database startup， he discovers that one of the disks crashed， resulting in the permanent loss of a read-write USERS tablespace. The USERS01.dbf datafile belongs to the USERS tablespace and is 500 MB in size. He needs to recover the USERS tablespace from the backup. While reviewing the backup details， he discovers that the most recent available backup is five days old. This backup was taken when the USERS tablespace was read-only. After correcting the hardware problem that caused the failure， what should Adam do to recover the USERS tablespace？（）A、 Restore the USERS01.dbf file from the backup， and open the database using the STARTUP command.B、 Restore the USERS01.dbf file using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.C、 Restore the USERS01.dbf file from the backup， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.D、 Restore the USERS01.dbf file from the backup and change the status of the USERS tablespace from read-only to read-write using the ALTER TABLESPACE USERS READ WRITE statement. Then， recover the USERS tablespace using the RECOVER TABLESPACE command， and open the database using the ALTER DATABASE OPEN statement.
You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）A、The backup status will be marked expired in RMAN recovery catalog.B、The backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.C、The backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery cataloglD、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.E、The backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
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？（）A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all
You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days， you want to change the status of the database backup and you issued the following command： RMANCHANGE BACKUPSET 231 NOKEEP； What is the implication of this command？（）A、 The backup is deleted.B、 The backup is marked unavailable.C、 The backup overrides the backup retention policy.D、 the backup becomes eligible for deletion according to the existing retention policy.
You need to recommend a backup strategy for Hyper-V. What should you recommend？（）A、Take a snapshot of each VM， and then run a full backup of the Hyper-V hosts by using Windows Server Backup.B、Shut down the VMs，and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.C、From each VM,run a full backup by using Windows Server Backup， and then run a full backup of the Hyper-V hosts by using Windows Server Backup.D、From each VM,run a full backup by using Windows Server Backup. Shut down the VMs， and then run a full backup of the Hyper-V hosts by using Windows Server Backup. Restart the VMs when the backup is complete.
Your network consists of a single Active Directory domain. You install a new backup program. The backup program requires a service account. You create a service account in the domain. You need to ensure that the service account can back up all member servers and client computers in the domain. You must ensure that the service account cannot be used to restore files and folders. What should you do?（）A、Add the service account to the domain Backup Operators group.B、Add the service account to the Backup Operators group on every server and every client computer.C、Assign the Back up files and directories user right by using a Group Policy object (GPO).D、Assign the Impersonate a client after authentication user right by using a Group Policy object (GPO).
What are four capabilities of the mysql client program?（）A、Creating, dropping, and modifying tables and indexesB、Initiating a binary backup of the database by using the START BACKUP commandC、Displaying replication status informationD、Shutting down the server by using the SHUTDOWN commandE、Creating and dropping databasesF、Creating and administering users
多选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） to perform backups in your databases. Which four backup operations can be performed using RMAN？（）AA backup of the target database when it is mountedBA backup of online redo log files when the database is openCA backup of only used data blocks in the file beingbeingbackup upDA backup of online， read/write data files when the database is openEA backup of only those data blocks that have changed since a previous backupFA backup of online， read/write data files when the database is in the NOMOUNT state.
多选题What are four capabilities of the mysql client program?（）ACreating, dropping, and modifying tables and indexesBInitiating a binary backup of the database by using the START BACKUP commandCDisplaying replication status informationDShutting down the server by using the SHUTDOWN commandECreating and dropping databasesFCreating and administering users
单选题Which view provides information on the backup status of the datafiles in the database?（）AV$BACKUPBV$BACKUP_STATUS CV$BACKUP_DATAFILE DV$DATAFILE_BACKUP EV$TABLESPCE_BACKUP
多选题What are two methods of taking a binary backup of a Mysql Server using InnoDB storage engine?（）AFile system snapshotsBMysqldumpslowCMysqlhotcopyDMysqldump with – binary-data optionEMysql Enterprise Backup
单选题You work as a database administrator for Supportcenter.cn. You are using Recovery Manager （RMAN） for backup and recovery of your database. You executed the delete command in RMAN to delete a backup of a tablespace. Which statement is true in this scenario？（）AThe backup status will be marked expired in RMAN recovery catalog.BThe backup status will be marked deleted in RMAN recovery catalog after you execute the crosscheck command.CThe backup will be deleted physically from the OS （Operating system）and the backup information is removed from the recovery cataloglDThe backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）.EThe backup status will be marked deleted and you must delete the backup file manually from the OS （Operating system）， if you are not using Oracle Managed Files （OMF）.
单选题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？（）A backup database allB backup compressed databaseC backup as compressed backupset databaseD backup as compressed backup database plus archivelog allE backup as compressed backupset database plus compress archivelog all
单选题Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）AThe backup will consist of used data blocks only.BThe database must be shut down to accomplish the backup.CThe backup can be accomplished without shutting down the database.DThe backup will contain all database files that have never been backed up.
单选题You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command: RMANCHANGE BACKUPSET 231 NOKEEP; What is the implication of this command?（）AThe backup is deleted.BThe backup is marked unavailable.CThe backup overrides the backup retention policy.Dthe backup becomes eligible for deletion according to the existing retention policy
多选题What are three facts about backups with mysqldump?（）ACan back up a remote database serverBAllow a consistent backup to be takenCAre always faster to restore than binary backupsDAre able to back up specific items within a databaseECreate automatically compressed backupsFWill lock all storage engines for duration of backup