A.media B.instance C.statement D.user process
单项选择题You configured automatic archive logging for the database. On the next startup the database runs for a while, but then hangs. After checking the alert log, you determine that all the online redo logs need archiving. Which step was skipped when you set up automatic archive log?()
A.LOG_ARCHIVE_DEST was not set in the parameter file. B.LOG_ARCHIVE_START was not set in the parameter file. C.alter database archivelog; was not executed in MOUNT mode. D.LOG_ARCHIVE_MAX processes were not set in the parameter file.
单项选择题A client server application has been configured to use local naming. The client and server run on separate machines. When the client tries to connect, it receives a TNS error. By carefully examining the environment, a tnsnames.ora is found only on the Oracle server machine, among other things. After copying this tnsnames.ora onto the client machine, the client is able to connect to the server. Which statement is true?()
A.tnsnames.ora must be on the client machine for local naming. B.tnsnames.ora must be removed from the server for the connection to work. C.tnsnames.ora must be on both the client and server machines for local naming. D.tnsnames.ora is not required for local naming; the problem was not fixed by copying the file to the client.
单项选择题You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database: SET UNTIL TIME = ’2000-12-09:11:44:00’; RESTORE DATABASE; RECOVER DATABASE; How should the commands be executed? ()
A.Only the SET command must be within a RUN block. B.All commands should be executed at the RMAN prompt. C.All three commands must be within a single RUN block. D.Only the RESTORE and RECOVER commands must be within a single RUN block.
单项选择题When importing a table into a database,the import process performs these tasks: 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap, functional, and or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed?()
A.2,3,4,1,6,5 B.3,2,4,1,6,5 C.3,2,6,4,1,5 D.4,2,3,1,5,6
多项选择题ThedatabaseisrunninginNOARCHIVELOGmode.Adatafileislost.Whichtwoarevalidoptionsforrecover?()
A.Restore the data file and perform incomplete recovery. B.Restore the data file and perform point-in-time recover. C.Drop the tablespace and lose all data in the tablespace. D.Restore the database and lose all data since the last backup.