出自:Oracle认证

Given: What is the result?（）
A:The value "4" is printed at the command line.
B:Compilation fails because of an error in line 5.
C:Compilation fails because of an error in line 9.
D:A NullPointerException occurs at runtime.
E:A NumberFormatException occurs at runtime.
F:An IllegalStateException occurs at runtime.
（）类型的表通常用来创建可扩展的的应用程序，并且对大型表来说是有用的，这个表可以被几个并发过程查询或操作。
A:有规则的表（Regular table）
B:簇表（Clustered table）
C:分区表（Partitioned table）
D:索引组织表（Index-organized table）
While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）
A:Activating the MySQL Enterprise thread pool plugin
B:Relocating your data and log files to separate storage devices
C:Disconnecting idle localhost client sessions
D:Implementing storage engine data compression options
You issued the following RMAN command：  RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON；     What is NOT an impact of using the above command？（）
A: When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed.
B: When a structural change is made to the database， then a backup of the current control file is performed.
C: When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed.
D: When a structural change is made to the database， then a backup of the alert log file will be performed.
You would like to create an RMAN recover catalog in which to store information about your DB01 database. You want to use the database named RCDB for the storage of your recovery catalog. The six steps you will follow to create a recover catalog are not displayed in the correct order. Which displays the correct order？（） 1. Grant the appropriate privileges （CONNECT and RESOURCE） and roles  （RECOVERY_CATALOG_OWNER） to the user responsible for performing backup and recover operations.  2. Register the target database in the catalog.  3. Create the catalog using the RMAN command line interpreter.  4. Create a user and schema which will own the recovery catalog.  5. Create tablespace to hold the catalog in the database you have dedicated for your RMAN recovery catalog.  6. Connect to the target database using SYSDBA privileges.
A:4，1，5，6，3，2
B:4，3，1，5，6，2
C:4，5，1，3，2，6
D:5，4，1，3，2，6
E:5，4，1，3，6，2
Which two database operations can be performed at the MOUNT stage of database startup？（）
A:renaming of data files
B:dropping the database user
C:renaming of control files
D:multiplexing of control files
E:configuring the database in ARCHIVELOG mode
Oracle数据库的工作模式有哪两种？它们之间有有何区别？
Which of the following files cannot be cataloged using the CATALOG command？（）
A:Data files
B:Control files
C:Archived log files
D:Files storing RMAN scripts
（）包用于显示pl/sql块和存储过程中的调试信息。
A:Dbms_output
B:Dbms_standadr
C:Dbms_Input
D:Dbms_session
You are managing an Oracle Database 11g database. The database is open， and you plan to perform Recovery Manager （RMAN） backups.  Which three statements are true about these backups（）
A:The backups would be consistent.
B:The backups would be inconsistent.
C:The backups would be possible only if the database is running in ARCHIVELOG mode.
D:The backups would be possible only if the database is running in NOARCHIVELOG mode.
E:The backups need to be restored and the database has to be recovered in case of a media failure
Which three SELECT statements displays 2000 in the format “$2,000.00”?（）
A:SELECT TO CNAR(2000,  ‘$#,###.##’)   FROM dual;
B:SELECT TO CNAR(2000,  ‘$0,000.00’)   FROM dual;
C:SELECT TO CNAR(2000,  ‘$9,999.00’)   FROM dual;
D:SELECT TO CNAR(2000,  ‘$9,999.99’)   FROM dual;
E:SELECT TO CNAR(2000,  ‘$2,000.00’)   FROM dual;
F:SELECT TO CNAR(2000, ‘$N,NNN.NN’)   FROM dual;
Which built-in allows you to update the screen display to reflect the information that Forms has in its internal representation of the screen? （）
A:SYNCHRONIZE 
B:UPDATE_FORM 
C:SYNCHRONIZE_FORM 
D:GET_MEMORY_DISPLAY 
E:SET_MEMORY_DISPLAY
What does the output on this report indicate？（）   RMAN> report need backup；  RMAN retention policy will be applied to the command  RMAN retention policy is set to redundancy 1  Report of files with less than 1 redundant backups  File #bkps Name  5 0 C:///ORACLE/ORADATA/ORCL/MY_DATA_01.DBF  
A: The my_data_01.dbf datafile is corrupted and needs to be restored.
B: The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
C: The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
D: The my_data_01.dbf datafile no longer meets the retention criteria for backups.
E: Datafile 5 is missing.
DRAG DROP Click the Task button.
If a job references a schedule that has been disabled, what will be the result?（）
A:The job will be automatically disabled.
B:The job will never execute.
C:The job will attempt to execute but will fail.
D:The job will inherit the DEFAULT_SCHEDULE schedule.
E:A schedule object cannot be disabled.
You have executed this command to change the size of the database buffer cache： SQL> ALTER SYSTEM SET DB_CACHE_SIZE=2516582； System altered.  To verify the change in size， you executed this command： SQL> SHOW PARAMETER DB_CACHE_SIZE NAME TYPE VALUE  ------------------- ----------- ------------------  db_cache_size big integer 4194304  （4M）  Why is the value set to 4194304 and not to 2516582（）
A:because 4194304 is the granule size
B:because 4194304 is the standard block size
C:because 4194304 is the largest nonstandard block size defined in the database
D:because 4194304 is the total size of data already available in the database buffer cache
Tape streaming is not happening while performing RMAN tape backup. On investigation， you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup？（）  
A: Configure backup optimization
B: Configure the channel to increase MAXOPENFILES
C: Configure the channel to increase the capacity with the RATE parameter
D: Configure the channel to adjust the tape buffer size with the BLKSIZE option
Given that the current directory is empty, and that the user has read and write privileges to the current, and the following: Which statement is true?（）
A:Compilation fails.
B:Nothing is added to the file system.
C:Only a new file is created on the file system.
D:Only a new directory is created on the file system.
E:Both a new file and a new directory are created on the file system.
When shrinking a table segment， you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use？（）
A: INCLUDING DEPENDENCIES
B: INCLUDING DEPENDENCIES CASCADE
C: COMPACT
D: CASCADE
E: None of the above
Given： Which code， inserted at line 14， allows the Sprite class to compile？（）
A:Direction d = NORTH；
B:Nav.Direction d = NORTH；
C:Direction d = Direction.NORTH；
D:Nav.Direction d = Nav.Direction.NORTH；
You have two databases， FINDB and PAYDB， on single operating system and using Optimal Flexible architecture （OFA）. FINDB is functional and is currently being accessed by the users. While starting up the instance for the PAYDB database you get the following error： ORA-01081： cannot start - already running ORACLE - shut it down first Which environmental variable would you set before starting up the PAYDB database to overcome this error？（）
A:ORA_PATH
B:ORACLE_SID
C:ORACLE_BASE
D:ORACLE_HOME
E:LD_LIBRARY_PATH
How is block-change tracking enabled?（）
A:With alter database enable block change tracking
B:With alter system enable block change tracking 
C:With an init.ora parameter change 
D:With an spfile parameter change 
（）可以让用户在事务处理中建立标记点，从而能够用于支持用户的事务处理。
A:保存点
B:事务点
C:回滚点
D:提交点
You are maintaining the PROD database of TeleSoft Corporation. You have initialized the following DB_BLOCK_CHECKING parameter in the init.ora file：  DB_BLOCK_CHECKING = TRUE；  What will be the result of setting this parameter？（）
A: Only data blocks of the SYSTEM tablespace will be checked.
B: Only data blocks of the SYSAUX tablespace will be checked.
C: A checksum will occur only on the checkpoint.
D: A checksum will occur every time a block is modified.
You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）
A:FULL
B:SCHEMAS
C:REMAP_SCHEMA
D:REMAP_DATAFILES
E:REMAP_TABLESPACE
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?（）
A:An upper limit on how far you can flash back the database, depending on the information in the redo logs
B:An upper limit on how far you can flash back the database, depending on the information in the undo tablespace
C:The amount of time for which the flashback data is to be kept in the flash recovery area, provided that there is enough space
D:The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace, provided that there is enough space
What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)
A:It cannot generate recommendations that support multiple workload queries.
B:It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
C:It can recommend partitioning only on tables that have at least 10,000 rows.
D:It can recommend only B-tree indexes and not bitmap or function-based indexes
What is true about the WITH GRANT OPTION clause?（）
A:It allows a grantee DBA privileges.
B:It is required syntax for object privileges.
C:It allows privileges on specified columns of tables.
D:It is used to grant an object privilege on a foreign key column.
E:It allows the grantee to grant object privileges to other users and roles.
在Oracle中，使用下列的语句产生序列： CREATE SEQUENCE id； Oracle服务器会预开辟内存并维持的序列值有（）个。
A:0
B:10
C:20
D:100
下面哪个参数不能在STORAGE子句中进行设置（）。
A:INITIAL
B:PCTUSED
C:MINEXTENTS
D:NEXT
首页 <上一页 36 37 38 39 40 下一页> 尾页