A temporary condition of danger will not make the port（）,provided that such condition will not last an unreasonable time...

第1题

[多选题] You issued the following command: An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? （）

A、It stores only the temporary table but not its indexes. B、It stores both the temporary table as well as its indexes. C、It must be a nondefault temporary tablespace for the database. D、It can be a default or nondefault temporary tablespace for the database. E、It must be the default temporary tablespace of the user who issues the command.

点击查看答案

第2题

[多选题] Which statements are correct about temporary tables（）

A、Indexes and views can be created on temporary tables. B、Both the data and the structure of temporary tables can be exported. C、Temporary tables are always created in a user’s temporary tablespace. D、The data inserted into a temporary table in a session is available to other sessions. E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

点击查看答案

第3题

[多选题] Which three statements are correct about temporary tables？（）

A、Indexes and views can be created on temporary tables. B、Both the data and the structure of temporary tables can be exported. C、Temporary tables are always created in a user’s temporary tablespace. D、The data inserted into a temporary table in a session is available to other sessions. E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

点击查看答案

第4题

[单选题] 以下哪类表空间中不能建立数据对象（表，索引）（）

A、SYSTEM表空间和非SYSTEM表空间 B、UNDO表空间和Temporary表空间 C、SYSTEM表空间和Temporary表空间 D、SYSTEM表空间和UNDO表空间 E、SYSTEM表空间，UNDO表空间和Temporary表空间

点击查看答案

第5题

[单选题] You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

A、flash back the database B、import the temporary tablespace from the last export C、restore all the data files and temporary files from the last full database backup and perform a recovery D、not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

点击查看答案

第6题

[] You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（） You have three temporary tablespace groups named G1, G2, and G3 in your database. You are creating a new temporary tablespace as follows: CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE '/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP ''; Which statement regarding the above command is correct?（）

A、A. It will create the tablespace TEMP1 in group G1. B、B. It will create the tablespace TEMP1 in group G3. C、C. It will not add the tablespace TEMP1 to any group. D、D. It will create the tablespace TEMP1 in the default group.

点击查看答案

第7题

[单选题] 以下哪个标识不是出现在GPRS无线部分的信令流程内（）

A、Temporary Flow Identity (TFI) B、Uplink State Flag (USF) C、Temporary Logical Link Identity (TLLI) D、Tunnel Identifier (TID)

点击查看答案

第8题

[单选题] You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

A、 flash back the database B、 import the temporary tablespace from the last export C、 restore all the data files and temporary files from the last full database backup and perform a recovery D、 not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

点击查看答案

第9题

[单选题] A Windows file server has run out of space. In the interim the administrator is moving several archived confidential folders that have been encrypted off the file server and onto an older server file shares. After the move, a manager reports that they are able to access and modify some of the items that have been moved. Which of the following is the MOST likely issue?（）

A、The temporary server was formatted as NTFS. B、The manager is a power user on the temporary server. C、The temporary server was formatted as FAT32. D、The manager is an administrator on the temporary server

点击查看答案

第10题

[多选题] You issued the following command： CREATE GLOBAL TEMPORARY TABLE admin_work_area （startdate DATE， enddate DATE， class CHAR（20）） ON COMMIT DELETE ROWS TABLESPACE tbs_t1； An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command？（）

A、 It stores only the temporary table but not its indexes. B、 It stores both the temporary table as well as its indexes. C、 It must be a nondefault temporary tablespace for the database. D、 It can be a default or nondefault temporary tablespace for the database. E、 It must be the default temporary tablespace of the user who issues the command.

点击查看答案

A temporary condition of danger will not make the port（）,provided that such condition will not last an unreasonable time.

请使用微信扫码支付