CMS专题
单选题You executed the following code： SQL> CREATE 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；
题目
SYSTEM tablespace
SYSAUX tablespace
Undo tablespace
The tablespace of the Index Organized Table （IOT）
相似问题和答案
第1题：
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）
- A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.
- B、Create a CHECK constraint.
- C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.
- D、Create a DML AFTER trigger that writes the failed records to a file or table.
正确答案:C
第2题：
You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）
- A、Image of the control file
- B、Location of the control file
- C、Contents of the control file in text format
- D、SQL command to re-create the database
- E、SQL command to re-create the control file
- F、Contents of the control file in binary format
正确答案:E
第3题：
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 purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
第4题：
You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
- A、SQL Access Advisor
- B、 Memory Advisor
- C、SQL Tuning Advisor
- D、 Segment Advisor
正确答案:A
第5题：
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
第6题：
How should the following UDF be invoked in order to convert US currency values stored in the EXPENSES table into Canadian currency?CREATE FUNCTION getratews11 ( country1 VARCHAR(100), country2 VARCHAR(100) ) RETURNS DOUBLE LANGUAGE SQL CONTAINS SQL EXTERNAL ACTION NOT DETERMINISTIC BEGIN ... END（）
- A、CALL getratews11('USA','CANADA')
- B、CALL expenses.getratews11('USA','CANADA')
- C、SELECT getratews11('USA','CANADA') FROM expenses
- D、SELECT * FROM TABLE(getratews11('USA','CANADA')) AS convert_currency
正确答案:C
第7题：
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
正确答案:C
第8题：
You executed the following code： SQL> CREATE 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； In which tablespace will the mapping table be created？（）
- A、 SYSTEM tablespace
- B、 SYSAUX tablespace
- C、 Undo tablespace
- D、 The tablespace of the Index Organized Table （IOT）
正确答案:D
第9题：
Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees； Table created. Further， you executed the following command to drop the table： SQL> DROP TABLE emp；Table dropped. What happens in this scenario？（）
- A、The table is moved to the SYSAUX tablespace.
- B、The table is moved to the SYSTEM tablespace.
- C、The table is removed from the database permanently.
- D、The table is renamed and remains in the TBSFD tablespace.
正确答案:D
第10题：
Which built-in would you use to test whether the CREATE TABLE command issued in the SALES form executed successfully?（）
- A、FORMS_DDL
- B、DO_SQL
- C、FORM_SUCCESS
- D、FORM_NOT_SUCCESS
- E、DBMS.ERROR_CODE
正确答案:C