违法和不良信息举报 联系客服
免费注册 登录

Evaluate the following command：   SQL> CREATE TABLE design_d

题目
单选题
Evaluate the following command：   SQL> CREATE TABLE design_data （id NUMBER， doc CLOB）  LOB（doc） STORE AS SECUREFILE（DEDUPLICATE）；   Which statement is true regarding the above command？（）
A

 The LOB values are automatically compressed.

B

 The LOB values are cached by default in the buffer cache.

C

 The LOB values are automatically stored in encrypted mode.

D

 All LOB data that is identical in two or more rows in a LOB column share the same data blocks.

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()

A. Create new indexes.

B. Modify existing indexes.

C. Implement partitioning on a nonpartitioned table.

D. Create materialized views.

E. All of the above


参考答案：E

第2题：

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:$> sqlldr hr/hr@pdb table=employeesWhich two statements are true regarding the command?（）

A. It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

B. It fails because no SQL *Loader data file location is specified.

C. It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

D. It fails because no SQL *Loader control file location is specified.


参考答案：A, C

第3题：

Evaluate the following SQL statement used to create the PRODUCTS table:Which statement is true regarding this command?()

A. It executes successfully but partition pruning cannot happen for this partition key.

B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key.

C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key.

D. It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.


参考答案：D

第4题：

Examine the commands executed in the following sequence：  1：SQL> CREATE ROLE mgrrole；  2：SQL> GRANT create user，select any table，connect，resource TO mgrrole；  3：SQL> GRANT select，update ON sh.sales TO mgrrole；  4：SQL> CREATE ROLE ceo IDENTIFIED BY boss；  5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo；  6：SQL> GRANT ceo TO mgrrole；  Which statement is true about the above commands（）

  • A、The commands execute successfully.
  • B、Command 6 produces an error because of circular role grant.
  • C、Command 5 produces an error because a role cannot be granted to another role.
  • D、Command 3 produces an error because the MGRROLE role already contains system privileges.
  • E、The table created by HR remains and HR still has the CREATE TABLE system privilege.
  • F、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

正确答案:B

第5题：

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

第6题：

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.


参考答案：C

第7题：

Examine the command that is used to create a table： SQL> CREATE TABLE orders（oid NUMBER（6） PRIMARY KEY， odate DATE， ccode NUMBER （6）， oamtNUMBER（10，2）） TABLESPACE users； Which two statements are true about the effect of the above command（）

  • A、A CHECK constraint is created on the OID column.
  • B、A NOT NULL constraint is created on the OID column.
  • C、The ORDERS table is the only object created in the USERS tablespace.
  • D、The ORDERS table and a unique index are created in the USERS tablespace.
  • E、The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

正确答案:B,D

第8题：

You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）

A. It creates the table and encrypts the data in it.

B. It generates an error because the wallet is closed.

C. It creates the table but does not encrypt the data in it.

D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.


参考答案：B

第9题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

  • A、All data along with the table structure is deleted 
  • B、The pending transaction in the session is committed 
  • C、All indexes on the table will remain but they are invalidated 
  • D、All views and synonyms will remain but they are invalidated 
  • E、All data in the table are deleted but the table structure will remain

正确答案:A,B,D

第10题：

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

更多相关问题
相关内容