当前分类： 1z0-043
问题：You are the Database Administrator （DBA） of your company. Yo...
查看答案
问题：单选题You are creating a cluster. The tables in the cluster have a relatively uniform distribution of values in the index column and the queries against the clustered table will almost use an equality operator to retrieve the desired row. Which type of clust...
问题：单选题You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does th...
问题：单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： $ rman target / What would be the effect of this command...
问题：The database is currently running in the NOARCHIVELOG mode. ...
问题：单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. ...
问题：单选题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the A...
问题：单选题Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an in...
问题：单选题The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN REPORT OBSOLETE； What would you see in the output？（）A a list of all those files that have been de...
问题：You issue the following code： EXEC DBMS_RESOURCE_MANAGER_...
问题：You lost a data file that belongs to an index tablespace in ...
问题：Your database is running in the automatic Program Global Are...
问题：Using the LIST command in Recovery Manager （RMAN）， which two...
问题：单选题You have configured your database to use RMAN for backup and recovery. You must back up the datafile contained in the TS1 tablespace. The size of the datafile in the TS1 tablespace is 200 MB. You issue the following command from the RMAN prompt to per...
问题：单选题Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）A modify the HASH_AREA_SIZE initialization p...
问题：单选题You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）A FRENCH_AIB FRENCH_CIC AI_FRENCHD CI_FRENCH...
问题：单选题You were recently hired by an organization as a database administrator. You are asked to find out whether the currently functional listener process， named L1， has been password protected or not. You are not familiar with the file system of the new orga...
问题：单选题You issued the following block of code： SQLBEGIN DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（ ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）； END； SQL/ Which option is NOT a result of executing the above code？（）A The swi...
问题：单选题Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space-related problem？（）A functionsB packageC procedureD database triggerE anonymous PL/SQL block...
问题：One of the tablespaces is read/x7fonly in your database. The...
