当前分类： 1Z0-032
问题：单选题What is the maximum database block size supported for the Oracle9i database？（）A 16KBB 32KBC 64KBD 128KB...
查看答案
问题：单选题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...
问题：单选题How can you make a shared server-side initialization parameter file available to all instances of a Real Application Clusters database？（）A Include an SPFILE parameter in each instance-specified initialization file.B Create an SPFILE copy on each client...
问题：多选题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...
问题：单选题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...
问题：单选题Using the command shown here， what time format must you specify to recover the database until a point-in-time？（） SQL RECOVER DATABASE UNTIL TIME ’’；A YYYY-DD-MM:HH24:SS:MI B YYYY-DD-MM:HH24:SS:MM C YYYY-MM-DD:HH24:MI:SS D YYYY-DD-MM:SS:MI:HH24...
问题：单选题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...
问题：单选题What is true about version-enabled tables？（）A The unit of versioning is the schema.B It is possible to version enable a table pertaining to SYS.C There are as many segments as versions for the same base table.D It is possible to create workspaces if th...
问题：单选题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...
问题：单选题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 two SQL*Loader instructions are used to assemble logical records？（）AWHENBINFILECCONTINUEIFDCONCATENATEETRAILING NULLCOLS...
问题：单选题You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to recover the data files but discover that the archived redo log file with sequence number 45， which is needed to perform complete recovery， is inva...
问题：单选题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...
问题：单选题What does the Metadata Application Programming Interface （API） allow you to do？（）A Repair damaged data dictionary entries.B Delete data dictionary information about database objects you no longer need.C Extract data definition commands from the data di...
问题：单选题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...
问题：单选题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...
问题：多选题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...
问题：单选题The listener uses dynamic information about the database and instance it has received through service registration before using information statically configured. Some services such as heterogeneous services and external procedures require the use of i...
问题：多选题Which two are true regarding direct-path exports？（）ADirect-path export is typically faster.BDirect-path export can be invoked interactively.CDirect-path export is character set independent.DDirect-path export bypasses the SQL-command processing layer.E...
问题：单选题You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing？（）A LIST EXPIREDB DELETE EXPIREDC DELETE OBSOLETED CHANGE...
