A.data files B.control file C.password file D.online redo log files E.initialization parameter file
多项选择题WhichfouroccurduringtheprocessingofarequestusingOracleSharedServer?()
A.The dispatcher returns the response to the user. B.The dispatcher places the request into the request queue. C.The shared server places the response in the response queue. D.The response is handed off to the next available dispatcher. E.A shared server picks up the request from the request queue and processes the request.
单项选择题You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log; GROUP# SEQ# BYTES ARC STATUS FIRST_NAME 1 60 153600 NO INACTIVE 01-03-09:19:34 2 61 153600 NO CURRENT 01-03-09:19:50 You then perform an incomplete recover. You receive this message: ORA-00279: change 309141...03 09 01 19:50:14 Needed for thread 1 ORA-00289: suggestion : disk1 archive arch_61.rdo ORA-00280: change 309043 for thread 1 is in sequence #61 Specify log: {=suggested | filename | AUTO | CANCEL} How should you respond to this message?()
A.Enter the keyword AUTO. B.Enter the keyword CANCEL. C.Press the Enter or Return key. D.Enter the filename ’/disk1/archive/log2a.rdo’.
单项选择题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk; it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available?()
A.Only bring the tablespace back online. B.Only recover the tablespace and then bring the tablespace back online. C.Shut down the database, recover the data file and then start up the database. D.Issue the ALTER DATABASE RENAME FILE command, recover the tablespace, and then bring the tablespace online. E.Recover the tablespace, issue the ALTER DATABASE RENAME FILE command, and then bring the tablespace online.
多项选择题Whichtwoarecharacteristicsofuser-managedbackupandrecoveryoperations?()
A.Recovery is initiated using SQL*Plus. B.Database files are backed up using SQL commands. C.Database files are backed up with Recovery Manager. D.Database files are restored using Recovery Manager. E.Database files are backed up using operating system commands.
单项选择题WhichcomponentoftheOraclenetworkingarchitectureprovidescharactersetanddatatypeconversionbetweendifferentcharactersetsontheclientandserver?()
A.SQL*Plus B.Oracle Net C.Two-Task Common (TTC) D.Oracle Protocol Support (OPS)