当前分类: 1Z0-032
问题:单选题You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database?()A SYSDBAB SYSOPERC No system privileges are requi...
查看答案
问题:单选题The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement?()A Only MEMORY is updated.B Only SPFILE values are updated.C Only init.ora parameters are upd...
问题:单选题Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system?()A CHANGEB RESYNCC C...
问题:单选题Which RMAN command is used to verify the status of a backup or copy, and also updates the repository when files have been deleted using operating system commands?()A CHANGEB RESYNCC CATALOGD CROSSCHECK...
问题:单选题Users complain SQL statements using a particular index fail. Using DBVERIFY, you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large. What is the least disruptive recover strat...
问题:单选题Which tool can be used to create and configure listeners to receive client connections?()A Oracle Net ManagerB Oracle Net Control UtilityC Oracle Net Configuration Assistant...
问题:单选题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 belo...
问题:单选题Which statement is true regarding Oracle Shared Server architecture?()A A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher. B Under the Oracle Shared Server architecture,...
问题:单选题You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()A ADDRESS_LISTB SID_NAMEC LISTENERD SERVICE_LIST...
问题:单选题What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?()A It is NOT possible to switch unless no active transaction exist in UNDO1. B It is possible to switch to UNDO2; but current active tran...
问题:单选题Which of the following statement is incorrect regarding RMAN?()A It detects corrupt blocks.B It performs only offline database backups.C It omits empty blocks during backups.D It performs tablespace point-in-time recovery (TSPITR)....
问题:单选题What is the maximum database block size supported for the Oracle9i database?()A 16KBB 32KBC 64KBD 128KB...
问题:单选题What is the new Oracle Shared Server?()A An improved version of multithreaded server configuration. B A connection pooling configuration where several clients are connected to the same server process. C Two more database servers, which share data by me...
问题:多选题Oracle Net is responsible for establishing and maintaining the connection between the client application and the server. On the client side, Oracle Net is responsible for which three connectivity issues?()AThe location of the server.BThe Oracle user be...
问题:单选题Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users?()A IGNORE=YB DIRECT=YC CONSISTENT=YD BUFFER=Y...
问题:单选题Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you...
问题:单选题The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this?()A mediaB instanceC statementD user process...
问题:多选题Which four occur during the processing of a request using Oracle Shared Server?()AThe dispatcher returns the response to the user.BThe dispatcher places the request into the request queue.CThe shared server places the response in the response queue.DTh...
问题:单选题After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command, what has been accomplished?()A Retain the data file backup for 7 days.B Run the recover process every 7 days.C Destroy the physical backup files every 7 days.D Destroy t...
问题:单选题You have configured the following: RMAN CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters: CONFIGURE DEFAULT DEVICE TYPE TO ’sbt’; new RMAN configuration parameters are successfully stored RMAN SHOW DEVICE TYPE; RMAN configura...