itgle.com

You executed the following code：   SQL> CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；  

题目

You executed the following code：   SQL> CERATE TABLE COUNTRY   （COUNTRY_ID CHAR（2） CONSTRAINT COUNTRY_ID_nn NOT NULL，   COUNTRY_NAME VARCHAR2（20），   CURRENCY_NAME VARCHAR2（20），   CONSTRAINT COUNTRY_ID_PK PRIMARY KEY （COUNTRY_ID））   ORGANIZATION INDEX；   Which types of tables will be created automatically？（）

  • A、 journal table
  • B、 clustered table
  • C、 mapping table
  • D、 partitioned table
相似考题

1.Would you please see to it that our Order No.P8800 is executed with () delay?A、no least delayB、least possibleC、least anyD、the least possible

2.You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）A. It must be executed from the Oracle Database 11g environment.B. It must be executed only after the SYSAUX tablespace has been created.C. It must be executed from the environment of the database that is being upgraded.D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

3.Which command displays the results of a loopback test you executed on a CT3 line module in slot 5, port 0, t1 number 4?()A.AB.BC.CD.D

4.Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）A. All three tables in the recycle bin are purgedB. Only the table with the oldest DROPSCN is purgedC. The command returns an error because multiple entries with the same name exist in the recycle binD. Only the table with the latest DROPSCN is purged

更多“You executed the&ensp”相关问题

  • 第1题：

    You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

    • A、 INDEX_STATS
    • B、 DBA_INDEXES
    • C、 DBA_IND_COLUMNS
    • D、 V$OBJECT_USAGE

    正确答案:A

  • 第2题：

    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  

    • A、 The code will be executed successfully.
    • B、 The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
    • C、 The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
    • D、 The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.

    正确答案:C

  • 第3题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第4题：

    单选题
    Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
    A

     The statement will be executed successfully， and a new time zone will be set for the database.

    B

     The statement will be executed successfully， but a new time zone will not be set for the database.

    C

     The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.

    D

     The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.


    正确答案： A
    解析： 暂无解析

  • 第5题：

    单选题
    You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. You plan to use a PresentationTraceSources object when the application is executed by users. When the application is executed in a test environment, all debug information is successfully captured. You need to be able to capture debug information when the application is deployed. What should you do?（）
    A

     Enable WPF tracing in the registry.Restart the application.

    B

     Enable tracing by modifying local Group Policy.Restart the application.

    C

     Open the XML configuration file for your application on the user's computer.Set tracing to a verbose level.Restart the application.

    D

     Open the XML configuration file for your application on the user's computer.Add a trace listener.Restart the application.


    正确答案： A
    解析： 暂无解析

  • 第6题：

    单选题
    You are creating a Windows application for graphical image processing by using the .NET Framework 3.5. You create an image processing function and a delegate.You plan to invoke the image processing function by using the delegate.You need to ensure that the calling thread meets the following requirements：  （1）It is not blocked when the delegate is running   （2）It is notified when the delegate is complete What should you do？（）
    A

    Call the Invoke method of the delegate.

    B

    Call the BeginInvoke and EndInvoke methods of the delegate in the calling thread.

    C

    Call the BeginInvoke method by specifying a callback method to be executed when the delegate is complete.Call the EndInvoke method in the callback method.

    D

    Call the BeginInvoke method by specifying a callback method to be executed when the delegate is complete.Call the EndInvoke method of the delegate in the calling thread.


    正确答案： B
    解析： 暂无解析

  • 第7题：

    单选题
    You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（）
    A

     INDEX_STATS

    B

     DBA_INDEXES

    C

     DBA_IND_COLUMNS

    D

     V$OBJECT_USAGE


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?（）
    A

    Before parameter form. 

    B

    After parameter form. 

    C

    Before report. 

    D

    After report.


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    You want to perform in incomplete recovery of your database.  You plan to use these commands to recover your database：  SET UNTIL TIME = ’2000-12-09：11：44：00’；  RESTORE DATABASE； RECOVER DATABASE；  How should the commands be executed？ （）
    A

    Only the SET command must be within a RUN block.

    B

    All commands should be executed at the RMAN prompt.

    C

    All three commands must be within a single RUN block.

    D

    Only the RESTORE and RECOVER commands must be within a single RUN block.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）
    A

     The statement will fail.

    B

     The statement will be executed successfully， and the new time zone will be set for the database.

    C

     The statement will be executed successfully， but the new time zone will be set for the current session.

    D

    The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

    back up the control file to trace

    B

    bring database to the MOUNT state

    C

    open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

    set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）
    A

     It must be executed from the Oracle Database 11g environment.

    B

     It must be executed only after the SYSAUX tablespace has been created.

    C

     It must be executed from the environment of the database that is being upgraded.

    D

     It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

    E

     It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）

    • A、renaming the control files
    • B、dropping a user in your database
    • C、enabling or disabling redo log archiving
    • D、dropping a tablespace in your database
    • E、re-creating the control files， after you lost all the control files in your database

    正确答案:C

  • 第14题：

    In which scenario will you create a hash cluster？（）

    • A、 when you want the data to be returned automatically in chronological order
    • B、 if the application uses queries joining tables only occasionally
    • C、 if the queries against the clustered table use the equality operator （=） to retrieve the desired row
    • D、 if the full table scan is executed often on only one of the clustered tables

    正确答案:C

  • 第15题：

    Which statement about using RMAN stored scripts is true?（）

    • A、To create and execute an RMAN stored script, you must use a recovery catalog.
    • B、When executing a stored script and a command fails, the remainder of the script is executed, and a message is written to the alert log file.
    • C、RMAN stored scripts can always be executed against any target database that is registered in the recovery catalog.
    • D、When you execute a stored script, it always executes using the persistent channel settings previously set with the CONFIGURE command.

    正确答案:A

  • 第16题：

    单选题
    You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
    A

    renaming the control files

    B

    dropping a user in your database

    C

    enabling or disabling redo log archiving

    D

    dropping a tablespace in your database

    E

    re-creating the control files， after you lost all the control files in your database


    正确答案： A
    解析： 暂无解析

  • 第17题：

    单选题
    You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（）
    A

     back up the control file to trace

    B

     bring database to the MOUNT state

    C

     open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

    D

     set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog


    正确答案： C
    解析： 暂无解析

  • 第18题：

    单选题
    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_SIZENAME TYPE VALUE ------------------- ----------- ------------------ db_cache_size big integer 4194304 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


    正确答案： A
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    In which scenario will you create a hash cluster？（）
    A

     when you want the data to be returned automatically in chronological order

    B

     if the application uses queries joining tables only occasionally

    C

     if the queries against the clustered table use the equality operator （=） to retrieve the desired row

    D

     if the full table scan is executed often on only one of the clustered tables


    正确答案： A
    解析： 暂无解析

  • 第21题：

    单选题
    You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）
    A

     The code will be executed successfully.

    B

     The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.

    C

     The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.

    D

     The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    In which scenario will you create a sorted hash cluster？ （）
    A

     if the application uses queries joining tables only occasionally

    B

     if the full table scan is executed often on only one table of the clustered tables

    C

     if the data for all the rows of a cluster key value exceeds one or two Oracle blocks

    D

     when you want the data to be returned automatically in the chronological order


    正确答案： C
    解析： 暂无解析

  • 第23题：

    多选题
    You started a long transaction. Before committing， you executed a query on one of the tables currently being modified. You received the following error：  ORA-01555： snapshot too old  How would you prevent such an error in the future？（）
    A

    guarantee undo retention

    B

    add one more redo log group

    C

    size the redo log files appropriately

    D

    size the UNDO tablespace appropriately

    E

    size the SYSTEM tablespace appropriately

    F

    configure an appropriate undo retention interval

    G

    change automatic undo management to manual


    正确答案： D,F
    解析： 暂无解析

相关内容