Statement接口的execute （)方法的返回类型是int型。

A . It will display a list of files that need incremental backup B . It will display a list of files that need backup after five days C . It will display a list of files that were backed up in the last five days D . It will display a list of files that have not been backed up in the last five days E . It will apply the current retention policy to determine the files that need to be backed u

A . A syntax error will result as you cannot specify more than one partition in the same statement B . All data in p1 and p3 partitions are removed and the table definition is changed C . All data in p1 and p3 partitions are removed, but the table definition remains unchanged D . Only the first partition (p1) will be dropped as only one can be dropped at any time

A . The EMPLOYEES table will be changed to read-only mode during the shrink operation. B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

A .  It will display a list of files that need incremental backup B .  It will display a list of files that need backup after five days C .  It will display a list of files that were backed up in the last five days D .  It will display a list of files that have not been backed up in the last five days E .  It will apply the current retention policy to determine the files that need to be backed u

A . The plan baselines are verified with the SQL profiles. B . All fixed plan baselines are converted into nonfixed plan baselines. C . All the nonaccepted SQL profiles are accepted into the plan baseline. D . The nonaccepted plans in the SQL Management Base are verified with the existing plan baselines.

A . Oracle Managed Files are used for this instance. B . The USER_DATA tablespace is managed using FET$/UET$ tables. C . The COMPATIBLE initialization parameter must be 9.0.0 or higher. D . Space within segments in the USER_DATA tablespace is managed with freelists.

A .  The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy. B .  The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup. C .  Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN. D .  Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.

A . The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy B . The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup C . Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf D . Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fail

A . DISPATCHER  B . USER  C . SERVER  D . LGWR  E .  DBW0

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

A . You cannot create a table form within Forms.  B . You must use the FORMS_DDL built-in to create the table.  C . You must use the DBMS_DYNAMIC_DDL package to create the table.  D . You can write the CREATE TABLE statement directly into the trigger.

A . None of these objects are eligible for garbage collection. B . Only the object referenced by booth is eligible for garbage collection. C . Only the object referenced by snoog is eligible for garbage collection. D . Only the object referenced by snooch is eligible for garbage collection. E . The objects referenced by snooch and booth are eligible for garbage collection.

A . The data in the segment will be compacted but the high water mark will not be adjusted  B . The EMPLOYEES table will be changed to read-only mode during the shrink operation  C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation  E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio

A . It would return information regarding only the last committed transaction. B . It would return only the active transactions in all the undo segments in the database. C . It would return only the committed transactions in all the undo segments in the database.  D . It would return both active and committed transactions in all the undo segments in the database. E . It would return information regarding the transactions that began and were committed in the last 30 minutes.

A . It deletes all binary log files, except 'mysql-in.010' B . It deletes all binary log files up to and including 'mysql-bin.010' C . It deletes all binary log files before 'mysql-bin.010' D . It deletes all binary log files after 'mysql-bin.010'

A .  It would return information regarding only the last committed transaction. B .  It would return only the active transactions in all the undo segments in the database. C .  It would return only the committed transactions in all the undo segments in the database. D .  It would return both active and committed transactions in all the undo segments in the database. E .  It would return information regarding the transactions that began and were committed in the last 30 minutes.

A .  It will display a list of files that need incremental backup. B .  It will display a list of files that need backup after five days. C .  It will display a list of files that were backed up in the last five days. D .  It will display a list of files that have not been backed up in the last five days. E .  It will apply the current retention policy to determine the files that need to be backed up.

A.It deletes all binary log files, except ‘mysql-in.010‘ B.It deletes all binary log files up to and including ‘mysql-bin.010‘ C.It deletes all binary log files before ‘mysql-bin.010‘ D.It deletes all binary log files after ‘mysql-bin.010‘

A．ResultSet B．Int C．Boolean D．String

A．1 B．2 C．3 D．4