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

One of the table

题目

One of the tablespaces is read/x7fonly in your database. The loss of all control files forced you to re/x7fcreate the control file.  Which operation do you need to perform after re/x7fcreating the control file and opening the database？（）

  • A、drop and re­create the read­only tablespaces
  • B、rename the read­only data files to their correct file names
  • C、change the tablespace status from read/write to read­only
  • D、re­create the read­only tablespace because it is automatically removed
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Is there a table for , please? （） please. Is the one near the backdoor OK?

ATake your time 

BThis way 

CYou are welcome 

DAfter you


B
略

第2题：

You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL；  What is the effect of this command？（）

  • A、One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
  • B、One audit record is created for every session when any user successfully drops a table owned by SCOTT.
  • C、One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
  • D、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
  • E、One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

正确答案:A

第3题：

Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;What is the outcome of executing the above statement?()

A.A syntax error will result as you cannot specify more than one partition in the same statement

B.All data in p1 and p3 partitions are removed and the table definition is changed

C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged

D.Only the first partition (p1) will be dropped as only one can be dropped at any time


参考答案：B

第4题：

Which one is a system privilege?（）

  • A、SELECT
  • B、DELETE
  • C、EXECUTE
  • D、ALTER TABLE
  • E、CREATE TABLE

正确答案:E

第5题：

Which of the following routing protocols uses AS-Path as one of the methods to build the routing table?（）

  • A、OSPF
  • B、IS-IS
  • C、EIGRP
  • D、BGP

正确答案:D

第6题：

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement: FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?（）

  • A、One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
  • B、One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
  • C、Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
  • D、None of the tables are recovered from the Recycle Bin, and the statement returns an error.

正确答案:B

第7题：

Which two statements about subqueries are true? （）

  • A、A single row subquery can retrieve data from only one table.
  • B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
  • C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
  • D、A single row subquery can retrieve data from more than one table.
  • E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
  • F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

正确答案:B,D

第8题：

You execute the following commands to audit database activities:SQL >ALTER SYSTEM SET AUDIT_TRIAL=DB, EXTENDED SCOPE=SPFILE;SQL >AUDIT SELECT TABLE, INSERT TABLE, DELETE TABLE BY JOHN By SESSION WHENEVER SUCCESSFUL;Which statement is true about the audit record that generated when auditing after instance restarts?（）

A. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command on a table, and contains the SQL text for the SQL Statements.

B. One audit record is created for every successful execution of a SELECT, INSERT OR DELETE command, and contains the execution plan for the SQL statements.

C. One audit record is created for the whole session if john successfully executes a SELECT, INSERT, or DELETE command, and contains the execution plan for the SQL statements.

D. One audit record is created for the whole session if JOHN successfully executes a select command, and contains the SQL text and bind variables used.

E. One audit record is created for the whole session if john successfully executes a SELECT, INSERT,or DELETE command on a table, and contains the execution plan, SQL text, and bind variables used.


参考答案：A

第9题：

Which three are true?（）

  • A、A MERGE statement is used to merge the data of one table with data from another.
  • B、A MERGE statement replaces the data of one table with that of another.
  • C、A MERGE statement can be used to insert new rows into a table.
  • D、A MERGE statement can be used to update existing rows in a table.

正确答案:A,C,D

第10题：

In which scenario will you create a sorted hash cluster？ （）

  • A、 if the application uses queries joining tables only occasionally
  • B、 if the full table scan is executed often on only one table of the clustered tables
  • C、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocks
  • D、 when you want the data to be returned automatically in the chronological order

正确答案:D

更多相关问题
相关内容