Oracle认证考试

Which is a valid CREATE TABLE statement?（）A、CREATE TABLE EMP9$# AS (empid number(2));B、CREATE TABLE EMP*123 AS (empid number(2));C、CREATE TABLE PACKAGE AS (packid number(2));D、CREATE TABLE 1EMP_TEST AS (empid number(2));

题目

Which is a valid CREATE TABLE statement?（）

  • A、CREATE TABLE EMP9$# AS (empid number(2));
  • B、CREATE TABLE EMP*123 AS (empid number(2));
  • C、CREATE TABLE PACKAGE AS (packid number(2));
  • D、CREATE TABLE 1EMP_TEST AS (empid number(2));
参考答案和解析
正确答案:A
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A.REFERENCES

B.SELECT

C.UPDATE

D.ALTER


参考答案：D

第2题：

You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.  Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

  • A、create a hash cluster to store the data
  • B、create an index cluster to store the data
  • C、create a partitioned table to store the data
  • D、create a sorted hash cluster to store the data
  • E、create a heap table with rowid to store the data

正确答案:D

第3题：

Which one is a system privilege? ()

A. SELECT

B. DELETE

C. EXECUTE

D. ALTER TABLE

E. CREATE TABLE


参考答案：E

第4题：

Which two operations can be performed on an external table（）

  • A、Create a view on the table.
  • B、Create an index on the table.
  • C、Create a synonym on the table.
  • D、Add a virtual column to the table.
  • E、Update the table using the UPDATE statement.
  • F、Delete rows in the table using the DELETE command.

正确答案:A,C

第5题：

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

  • A、REFERENCES
  • B、SELECT
  • C、UPDATE
  • D、ALTER

正确答案:D

第6题：

Given the following requirements:Create a table named TESTTAB, which has an identity column named ACTIVITYNO. Define the identity column to generate the values for the column by default. Start the values at 10 and increment by 10. Make the identity column unique. Which of the following CREATE statements will successfully create this table?（）

A.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

B.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTNO))

C.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 1), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))

D.CREATE TABLE TESTTAB (ACTIVITYNO SMALLINT NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 10 INCREMENT BY 10), ACTKWD CHAR(6) NOT NULL, ACTDESC VARCHAR(20) NOT NULL, UNIQUE(ACTIVITYNO))


参考答案：D

第7题：

A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

  • A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
  • B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
  • C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
  • D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

正确答案:C

第8题：

Which is a valid CREATE TABLE statement? ()

A. CREATE TABLE EMP9$# AS (empid number(2));

B. CREATE TABLE EMP*123 AS (empid number(2));

C. CREATE TABLE PACKAGE AS (packid number(2));

D. CREATE TABLE 1EMP_TEST AS (empid number(2));


参考答案：A

第9题：

For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state？（）

  • A、UPDATE TABLE
  • B、CREATE CLUSTER
  • C、TRUNCATE TABLE
  • D、ALTER TABLE MOVE
  • E、INSERT INTO···VALUES
  • F、ALTER TABLE···DROP COLUMN
  • G、ALTER TABLE···DROP PARTITION

正确答案:A,E

第10题：

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

  • A、The table created by SKD is not accessible and SKD cannot create new tables.
  • B、The tables created by SKD and HR remain， but both cannot create new tables.
  • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
  • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

正确答案:C

更多相关问题
相关内容