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

Evaluate the following command and its output：   SQL>SELECT 

题目
多选题
Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）
A

FREE_SPACE indicates only the space that is currently unallocated.

B

ALLOCATED_SPACE indicates only the space currently allocated and in use.

C

FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D

ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.

E

FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

参考答案和解析
正确答案： B,D
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACKUP DATABASE PLUS ARCHIVELOG;Which data files will be backed up?（）

A. Data files that belong to only the root container

B. Data files that belong to the root container and all the pluggable databases (PDBs)

C. Data files that belong to only the root container and PDB$SEED

D. Data files that belong to the root container and all the PDBs excluding PDB$SEED


参考答案：B

第2题：

Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager"FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id)AND e.salary > 4000;What is its output?（）

A.A

B.B

C.C

D.D

E.E


参考答案：A

第3题：

Evaluate the following command and its output:Which two statements correctly interpret the output?()

A. FREE_SPACE indicates only the space that is currently unallocated.

B. ALLOCATED_SPACE indicates only the space currently allocated and in use.

C. FREE_SPACE indicates only the space that is currently allocated and available for reuse.

D. ALLOCATED_SPACE indicates both the space currently allocated and used, and the space that is available for reuse.

E. FREE_SPACE indicates both the space that is currently allocated and available for reuse, and the space that is currently unallocated.


参考答案：D, E

第4题：

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）

  • A、An Automatic Workload Repository snapshot has been taken recently.
  • B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
  • C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
  • D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

正确答案:C

第5题：

Router R1 exists in an Enterprise that uses EIGRP as its routing protocol. The show ip route command output on router R1 lists the following phrase: "Gateway of last resort is 1.1.1.1 to network 2.0.0.0". Whic h of the following is most likely to have caused this output to occur on R1?（）

  • A、R1 has been configured with an ip default- network 2.0.0.0 command.
  • B、R1 has been configured with an ip route 0.0.0.0 0.0.0.0 1.1.1.1 command.
  • C、R1 has been configured with an ip route 2.0.0.0 255.0.0.0 1.1.1.1 command.
  • D、Another router has been configured with an ip default - network 2.0.0.0 command.
  • E、Another router has been configured with an ip route 2.0.0.0 255.0.0.0 1.1.1.1 command.

正确答案:D

第6题：

Given the following router output,which configuration file will the router use at its next reload?()

A.config

B.clientqos.cnf

C.startup-config

D.running-configuration


参考答案：D

第7题：

Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

A.A

B.B

C.C

D.D

E.E


参考答案：A

第8题：

Evaluate this SQL statement:In the statement, which capabilities of a SELECT statement are performed?()

A. Selection, projection, join

B. Difference, projection, join

C. Selection, intersection, join

D. Intersection, projection, join

E. Difference, projection, product


参考答案：A

第9题：

Running the s?command provides the following output. Running the ?s?command provides the following output.PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND 22752 - A 0.08 2611 1960 3980 6276 4652 20 0.0 0.0 /usr/bin/find. 20700- A 0.07 2712 1868 2906 6379 950 28 0.0 0.0 /usr/dt/b. What is the amount of RAM, in kilobytes, used for the text and data segments for the 'find' command?（）

  • A、1960
  • B、3980
  • C、2611
  • D、4652

正确答案:B

第10题：

Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）

  • A、0
  • B、1
  • C、0.00
  • D、An error statement

正确答案:A

更多相关问题
相关内容