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题:
要在users表中插入一条新记录,下面语句正确的是()。
第2题:
Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement? ()
第3题:
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()
第4题:
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQ EMP_NAME and JOB_ID: As specified by the user during run time, throughsubstitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?()
第5题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command: SQL> SELECT ename FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database instance. Which three operations wouldwait when issued in SCOTT’s second session()
第6题:
The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command: SQL> GRANT SELECT,INSERT,UPDATE ON emp TO scott WITH GRANT OPTION; The user SCOTT executes this command to grant privileges to the user JIM: SQL> GRANT SELECT,INSERT,UPDATE ON hr.emp TO jim; Now, the user HR decides to revoke privileges from JIM using this command: SQL> REVOKE SELECT,INSERT,UPDATE ON emp FROM jim; Which statement is true after HR issues the REVOKE command()
第7题:
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-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. ()
第8题:
The session is terminated after receiving the error and JIM can continue with his transaction.
SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
The session is rolled back after receiving the error and JIM can continue with his transaction.
SCOTT has to reexecute the last command in the transaction after he commits the transaction.
第9题:
The session is terminated after receiving the error and JIM can continue with his transaction.
SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
The session is rolled back after receiving the error and JIM can continue with his transaction.
SCOTT has to reexecute the last command in the transaction after he commits the transaction.
第10题:
An update in a leaf row takes place.
The index becomes invalid after the update.
The leaf block containing the row to be updated is marked as invalid.
A row in the leaf block of the index for the key value is deleted and inserted.
第11题:
You must enable the row movement on the SCOTT.EMP table.
You must define the tablespace of the SCOTT.EMP table for automatic segment space management.
You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement.
You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.
第12题:
The batch operation started by the user, SCOTT, terminates with an error.
The batch operation started by the user, SCOTT, hangs and you are required to increase the undo pool resource plan directive.
The batch operation started by the user, SCOTT, runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
The user, BLAKE, cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user, SCOTT, terminates with an error.
第13题:
You are working as a DBA at NetFx Corporation. A user, Scott, is maintaining the records of all the employees in the EMPLOYEEtable. Initially, the salary of the employee, ’E0025’, was $1800. On 1 May 2004, the salary of the employee, ’E0025’, was increased by $200. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQL>UPDATE EMPLOYEE SET SALARY = 2000 WHERE EMPNO = ’E0025’; SQL>COMMIT; On December 1, 2004, the salary of the employee, ’E0025’, was increased by $400. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’: SQL>UPDATE EMPLOYEE SET SALARY = 2400 WHERE EMPNO = ’E0025’; SQL>COMMIT; On July 1, 2005, the salary of the employee, ’E0025’, was increased by $500. The user, Scott, issued the following statement to modify the record of the employee, ’E0025’ SQL>UPDATE EMPLOYEE SET SALARY = 2900 WHERE EMPNO = ’E0025’; SQL>COMMIT; On July 5, 2005, the HR manager asked you to generate the increment report of the employee, ’E0025’, for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report?()
第14题:
Which three are true?()
第15题:
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? ()
第16题:
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives thefollowing error 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-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem.()
第17题:
You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users, SCOTT and BLAKE, belong to the DSS_USERS resource group. The user, SCOTT, initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive?()
第18题:
The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this change to the table affect the index?()
第19题:
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK,or any data definition language (DDL) command: SQL> SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session?()
第20题:
Add a data file to the SMD tablespace.
Add a data file to the temporary tablespace associated with the user HR.
Resize the data file associated with the SMD tablespace to make it larger.
Alter the data file associated with the SMD tablespace to grow automatically.
Change the segment space management for the SMD tablespace to automatic
第21题:
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
第22题:
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
第23题:
A MERGE statement is used to merge the data of one table with data from another.
A MERGE statement replaces the data of one table with that of another.
A MERGE statement can be used to insert new rows into a table.
A MERGE statement can be used to update existing rows in a table.
第24题:
They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
They are evaluated by the first WHEN clause. If the condition is true, then the row would be evaluated by the subsequent WHEN clauses.
They are evaluated by the first WHEN clause. If the condition is false, then the row would be evaluated by the subsequent WHEN clauses.
The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.