网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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 recreate the readonly tablespaces
- B、rename the readonly data files to their correct file names
- C、change the tablespace status from read/write to readonly
- D、recreate the readonly tablespace because it is automatically removed
参考答案
更多 “ 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 recreate the readonly tablespacesB、rename the readonly data files to their correct file namesC、change the tablespace status from read/write to readonlyD、recreate the readonly tablespace because it is automatically removed” 相关考题
考题
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 statementB.All data in p1 and p3 partitions are removed and the table definition is changedC.All data in p1 and p3 partitions are removed, but the table definition remains unchangedD.Only the first partition (p1) will be dropped as only one can be dropped at any time
考题
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.
考题
Is there a table for , please? （） please. Is the one near the backdoor OK?ATake your timeBThis wayCYou are welcomeDAfter you
考题
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.
考题
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.
考题
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.
考题
Which of the following routing protocols uses AS-Path as one of the methods to build the routing table?（）A、OSPFB、IS-ISC、EIGRPD、BGP
考题
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.
考题
In which scenario will you create a sorted hash cluster？ （）A、 if the application uses queries joining tables only occasionallyB、 if the full table scan is executed often on only one table of the clustered tablesC、 if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD、 when you want the data to be returned automatically in the chronological order
考题
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A、 REBUILDB、 CASCADEC、 TRUNCATED、 ROW MOVEMENTE、 SHRINK SPACE COMPACTF、 SHRINK SPACE CASCADE
考题
Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）; A、to undo the changes made to the EMP table since the specified timeB、to restore the EMP table that was wrongly dropped from the databaseC、to view the transactions that have modified the EMP table since the specified timeD、to view the changes made to the EMP table for one or more rows since the specified timeE、to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
You execute the following command toauditdatabase activities： SQLAUDITDROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）A、Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.B、Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.C、One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.E、One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
考题
You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A、 Use a separate table for each date. Delete eachtable when it is one week old.B、 Use a separate table for each week. Delete each table when it is one week old.C、 Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D、 Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
考题
多选题User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）Anull lock on the row being updatedBnull lock on the table containing the rowCROW SHARE lock for the row being updatedDROW EXCLUSIVE lock for the row being updatedEshared row-exclusive lock for the row being updatedFa shareable table lock for the table containing the rowGexclusive table-level lock for the table containing the row
考题
单选题You are responsible for a data warehouse application that uses records from an external table to update one of the dimension tables periodically. The records in the external table may contain data for new rows in the dimension table， or for updates to its existing rows. Which type of SQL command would you use to transfer the data from the external table to the dimension table as efficiently as possible？（）A
MERGEB
SELECT …CROSS JOINC
INSERT ALL …SELECTD
CREATE VIEW …CONSTRAINT
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’，’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified timeE
to recover the EMP table to a point in time in the past by restoring the most recent backup
考题
单选题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.
考题
单选题Why would you use the following FLASHBACK TABLE command？（） FLASHBACK TABLE emp TO TIMESTAMP （’11：45’.’hh12：mi’）；A
to undo the changes made to the EMP table since the specified timeB
to restore the EMP table that was wrongly dropped from the databaseC
to view the transactions that have modified the EMP table since the specified timeD
to view the changes made to the EMP table for one or more rows since the specified time
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
单选题He has ______ arms now and is able to pick the table up with one hand.A
weakestB
weakerC
strongestD
stronger
考题
单选题You are designing an application that will use Windows Azure Table storage to store millions of data points each day. The application must retain each day’s data for only one week. You need to recommend an approach for minimizing storage transactions. What should you recommend？（）A
Use a separate table for each date. Delete eachtable when it is one week old.B
Use a separate table for each week. Delete each table when it is one week old.C
Use a single table， partitioned by date. Use Entity Group Transactions to delete data when it is one week old.D
Use a single table， partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
考题
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）A
REBUILDB
CASCADEC
TRUNCATED
ROW MOVEMENTE
SHRINK SPACE COMPACTF
SHRINK SPACE CASCADE
考题
多选题Which three are true?（）AA MERGE statement is used to merge the data of one table with data from another.BA MERGE statement replaces the data of one table with that of another.CA MERGE statement can be used to insert new rows into a table.DA MERGE statement can be used to update existing rows in a table.
考题
单选题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 statementB
All data in p1 and p3 partitions are removed and the table definition is changedC
All data in p1 and p3 partitions are removed, but the table definition remains unchangedD
Only the first partition (p1) will be dropped as only one can be dropped at any time
考题
单选题Please join us. We can easily make ______ for one more at this table.A
seatB
placeC
roomD
space
考题
单选题In which scenario will you create a sorted hash cluster？ （）A
if the application uses queries joining tables only occasionallyB
if the full table scan is executed often on only one table of the clustered tablesC
if the data for all the rows of a cluster key value exceeds one or two Oracle blocksD
when you want the data to be returned automatically in the chronological order
热门标签
最新试卷
