CMS专题
多选题User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1： ORA-01
题目
Grant the RESOURCE role to SCOTT.
Add data files to the USERS tablespace.
Grant the CREATE ANY TABLE privilege to SCOTT.
Increase the space for SCOTT on the USERS tablespace.
Increase the size of the data file associated with the USERS tablespace
相似问题和答案
第1题：
A. ALTER DATABASE FLASHBACK ON;
B. GRANT SELECT any transaction TO scott;
C. GRANT EXECUTE ON dbms_flashback TO scott;
D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;
F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
第2题：
在Oracle中，用ALTER将scott的口令改为hello，下列哪个是正确的？（ ）
A.ALTER USER scott IDENTIFIED BY hello
B.ALTER scott USER IDENTIFIED BY hello
C.ALTER USER scott IDENTIFIED AS hello
D.ALTER USER hello IDENTIFIED BY scott
第3题：
在Oracle中，将scott的资源文件改为otherprofile，下列哪个是正确的？（ ）
A.ALTER PROFILE USER scott otherprofile
B.ALTER otherprofile USER scottPROFILE
C.ALTER USER scott PROFILE otherprofile
D.ALTER scott USER PROFILE otherprofile
第4题：
The HR user creates a view with this command： SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp； Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario？（）
- A、HR can grant the privilege to JIM but without GRANT OPTION.
- B、HR can grant the privilege to JIM because HR is the owner of the view.
- C、SCOTT has to grant the SELECT privilege on the EMP table to JIM before this operation.
- D、HR needs the SELECT privilege on the EMP table with GRANT OPTION from SCOTT for this operation.
正确答案:D
第5题：
在Oracle中，将scott的缺省表空间改为data2_ts，下列哪个是正确的？（）
- A、ALTER USER scott DEFAULT TABLESPACE data2_ts
- B、ALTER DEFAULT TABLESPACE data2_ts USER scott
- C、ALTER USER scott TABLESPACE DEFAULT data2_ts
- D、ALTER scott USER DEFAULT TABLESPACE data2_ts
正确答案:A
第6题：
A. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
C. The C # # A_ADMIN user can perform wallet operations.
D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
第7题：
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?（）
- A、ALTER DATABASE FLASHBACK ON;
- B、GRANT SELECT any transaction TO scott;
- C、GRANT EXECUTE ON dbms_flashback TO scott;
- D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
- E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
- F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
正确答案:B,C,D,F
第8题：
Exhibit:
BULK INSERT Ezonexam.dbo.employees
FROM ‘tk\africe\fubar512.txt’
WITH DATAFILETYPE = ‘char’,
FIELD/TERMINATOR = ‘\t’,
ROWTERMINATOR = ‘\n,’
TABLOCK
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.
How should you improve the performance of the query in the exhibit above?
A. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 5 percent of the number of rows to be loaded.
B. Extend the BULK INSERT statement with the BATCHSIZE option set it to equal to 10 percent of the number of rows to be loaded.
C. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 5 percent of the number of rows to be loaded.
D. Extend the BULK INSERT statement with the ROWS_PER_BATCH option set it to equal to 10 percent of the number of rows to be loaded.
E. Insert a line before the BULK INSERT statement that drops the indexes for the customers table. Insert a line after the BULK INSERT statement that recreates the indexes for the customers table.
F. The TABLOCK option should be removed.
G. The ROWTERMINATOR line should be removed.
F 解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.
Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior. that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.
Incorrect Answers:
A, B, C, D: Effect would not be large
E: Some improvement, but not the best answer.
G: Would make the batch to stop working.
第9题：
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）
- A、The session is terminated after receiving the error and JIM can continue with his transaction.
- B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
- C、The session is rolled back after receiving the error and JIM can continue with his transaction.
- D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.
正确答案:B,D
第10题：
A developer calls and reports that he accidentally dropped an important lookup table from a production database. He needs the table to be recovered. What action would you take？（）
- A、 Initiate an incomplete recovery operation using RMAN.
- B、 Copy the table from a development database.
- C、 Advise the user to rekey the data.
- D、 Perform a Flashback Drop operation.
- E、 Perform a Flashback Recovery operation.
正确答案:D