Which two statements are correct about database transportation?()
AThe source and target platforms must be the same
BRedo logs,control files and temp files are also transported
CThe transported database must have the same database identifier (DBID) as the source database and cannot be changed
DThe COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
ERecovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format
相关问题推荐
-
1. import java.io.*; 2. public class Foo implements Serializable { 3. public int x, y; 4. public Foo( int x, int y) { this.x = x; this.y = y; } 5. 6. private void writeObject( ObjectOutputStream s) 7. throws IOException { 8. s.writeInt(x); s.writeInt(y) 9. } 10. 11. private void readObject( ObjectInputStream s) 12. throws IOException, ClassNotFoundException { 13. 14. // insert code here 15. 16. } 17. } Which code, inserted at line 14, will allow this class to correctly serialize and deserialize?()
A、 s.defaultReadObject();
B、 this = s.defaultReadObject();
C、 y = s.readInt(); x = s.readInt();
D、 x = s.readInt(); y = s.readInt();
-
How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has alreadycompleted?()
A、Issue the ALTER DISKGROUP ... ADD DISK command.
B、Issue the ALTER DISKGROUP ... UNDROP DISKS command.
C、Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
D、Retrieve the disk from the Recycle Bin after the operation completes
-
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?()
A、SQL Repair Advisor
B、SQL Optimizer
C、SQL Access Advisor
D、SQL Tuning Advisor
-
What methods of point-in-time recovery are available?()
AChange-based
BCancel-based
CTime-based
DSequence number-based
ETransaction number-based
-
A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following error message: Which is the recommended sequence of operations you need to perform for the query successfully?()
A、 Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
B、 Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and then bring it online.
C、 Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
D、 Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.