You issue this SQL statement：  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’；  What does this SQL statement do？（）

A . It will display a list of files that need incremental backup B . It will display a list of files that need backup after five days C . It will display a list of files that were backed up in the last five days D . It will display a list of files that have not been backed up in the last five days E . It will apply the current retention policy to determine the files that need to be backed u

A .  Enables all fiber-optic LAN ports for Unidirectional LINK Detection （UDLD） B .  Enables all copper media LAN ports Unidirectional Link Detection （UDLD） C .  Overrides the default UDLS setting for all ports D .  Globally enables all ports on the device for Unidirectional Link Detection （UDLS） E .  None of the other alternatives apply

A . The database must have multiplexed redo logs for the flashback to succeed. B . The database must be MOUNTED for the flashback to succeed. C . The database must use block change tracking for the flashback to succeed. D . The database must be opened in restricted mode for the flashback to succeed. E . The database must be opened with the RESETLOGS option after the flashback is complete. F . The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.

A .  It will display a list of files that need incremental backup B .  It will display a list of files that need backup after five days C .  It will display a list of files that were backed up in the last five days D .  It will display a list of files that have not been backed up in the last five days E .  It will apply the current retention policy to determine the files that need to be backed u

A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command. B .  The command will not execute successfully because resumable space allocation is enabled at the session level. C .  The command will execute successfully and resumable space will be allocated at the session level. D .  The command will execute successfully and resumable space will be allocated at the instance level.

A .  The control file will be multiplexed. B .  The control file will be recreated. C . The script containing the CREATE CONTROLFILE statement will be created. D .  The binary backup of the control file will be created.

A . A text copy of the control file. B . A binary copy of the control file. C . A file containing a SQL statement which will re-create the database. D . A file containing a SQL statement which will re-create the control file.

A . IEEE 802.10 B . Misconfigured NIC C . User configuration D . IEEE 802.1Q E . None of the other alternatives apply

A .  creating a table in your schema and you exceed your allocated space quota on the tablespace B .  executing a long query that involves a sort operation and the statement runs out of temporary space C .  loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit D .  creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

A . No privileges. B . Only the SELECT privilege. C . Only the CONNECT privilege. D . All the privileges of a default user.

A .  To indicate the location of the auxiliary-instance online redo logs. B .  To indicate the location of the target database datafiles. C .  To indicate the location of the auxiliary-instance control file and online redo logs. D .  To indicate the location of the auxiliary-instance database datafiles. E .  This is not a valid parameter when duplicating a database.

A . No privileges. B . Only the SELECT privilege. C . Only the CONNECT privilege. D . All the privileges of a default user.

A . Updating B . Viewing C . Deleting D . Inserting E . Truncating

A . $ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql B . Mysql＞ INSERT INTO t1 VALUES FROM '/tmp/t1.sql' C . $ mysql – u root – p – h localhost test ＜ /tmp/t1.sql D . Mysql＞ LOAD DATA INFILE '/tmp/t1.sql' INTO TABLE t1 E . $ mysqlinport – u root – p – h localhost test /tmp/t1.sql

A . The tablespace must be locally managed. B . The tablespace must have only one temp file. C . The tablespace must be made nondefault and offline. D . The tablespace can remain as the default but must have no active sort operations.

A . backup database plus archivelog B . backup database plus archivlog until time ‘10:00‘ C . backup database plus archivelog timeout ‘10:00‘ D . backup database plus archivelog duration 10:00

A .  An incremental backup strategy will be used automatically. B .  Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria. C .  RMAN will configure itself for maximum performance at the cost of CPU. D .  RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database. E .  RMAN will automatically compress backups.

A .  when all the control files are missing and only a binary backup of the current control file exists B .  when a multiplexed copy of the current control file is missing C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists D .  when the SPFILE is missing

A .  After two days，a backup will be marked obsolete B .  After two days，a backup will be deleted from the media C .  If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media. D .  If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

A . All data along with the table structure is deleted  B . The pending transaction in the session is committed  C . All indexes on the table will remain but they are invalidated  D . All views and synonyms will remain but they are invalidated  E . All data in the table are deleted but the table structure will remai

A . After two days, a backup will be marked obsolete B . After two days, a backup will be deleted from the media C . If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media. D . If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

A .  The tablespace must be locally managed. B .  The tablespace must have only one temp file. C .  The tablespace must be made nondefault and offline. D .  The tablespace can remain as the default but must have no active sort operations.

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/48e2bbf7dc66a1983e0c43f256ecc7a7.jpg' /> A.A B.B C.C D.D