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.()
A.Grant the RESOURCE role to SCOTT.
B.Add data files to the USERS tablespace.
C.Grant the CREATE ANY TABLE privilege to SCOTT.
D.Increase the space for SCOTT on the USERS tablespace.
E.Increase the size of the data file associated with the USERS tablespace
您可能感兴趣的试卷
你可能感兴趣的试题
The TRANS_SUMMARY table contains product-wise transaction details that get updated with everytransaction in the system. Each row has cumulative transaction details of a single product and everyproduct is identified by a product code, which is the primary key.
As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY tableto the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products,the company deals with many new products during every quarter.
Which method is best suited for this quarterly data transfer()
A.using the MERGE command
B.using the SQL*Loader utility
C.using the correlated UPDATE command
D.using the INSERT command to perform bulk operation
All the database users are presently connected to the database instance and working. The HR userhas opened three database sessions and executed the following command in one of his sessions: SQL> UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’; 123 rows updated.
SQL> DELETE FROM persons WHERE exp=’Y’; 3 rows deleted.
The SYS user opens a new session after HR executed the above commands.
Which sessions can seethe effect of the UPDATE and DELETE commands ()
A.all sessions of the HR user only
B.all sessions of the HR user and the SYS user
C.the session of the HR user that executed the commands
D.all the sessions for which the database users have access privilege to the PERSONS table
You executed this command to create a temporary table:
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS;
Which statement is true about the rows inserted into the REPORT_WORK_AREA table during atransaction ()
A.The rows stay in the table only until session termination.
B.The rows stay in the table only until the next transaction starts on the table.
C.The rows are visible to all current sessions after the transaction is committed.
D.The rows stay available for subsequent sessions after the transaction is committed
A.The leaf blocks in the index are doubly linked.
B.The leaf node stores a bitmap for each key value.
C.The rows with NULL value in key columns also have entries in the index.
D.The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
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.
The table contains a million rows for zonewise analysis in the DSS system. DML operations areperformed very rarely on the table. You decide to prepare an index on the ZONE column to enhance theperformance of the queries on the ZONE column.
Which type of index would you select in this scenario()
A.Bitmap index
B.Reverse key index
C.Normal B-Tree index
D.Function-based index
You have two tables with referential integrity enforced between them. You need to insert data to
thechild table first because it is going to be a long transaction and data for the parent table will be available ina later stage, which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables.
Which action would you take to delay the referential integrity checking until the end of the transaction()
A.Set the constraint to deferred before starting the transaction.
B.Alter the constraint to NOVALIDATE state before starting the transaction.
C.Enable the resumable mode for the session before starting the transaction.
D.Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction.
You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable:
SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;
Which two statements are true about the effect of the command()
A.No flashback is possible to bring back the ITEM table.
B.The ORDER table is dropped along with the ITEM table.
C.The dependent referential integrity constraints in the ORDER table are disabled.
D.The dependent referential integrity constraints in the ORDER table are removed.
E.The table definition of the ITEM table and associated indexes are placed in the recycle bin.
A.The corresponding indexes for the table are also truncated.
B.Delete triggers on the table are fired during the execution of the TRUNCATE command.
C.The child table is truncated when the TRUNCATE command is applied on the parent table.
D.The high-water mark (HWM) is set to point to the first usable data block in the table segment.
E.No undo or very little undo data is generated during the execution of the TRUNCATE command
最新试题
Which statements are correct about temporary tables()
The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()
Which statements are true regarding the Oracle Data Pump export and import operations()
Which statements are true regarding a tablespace()
You configured the Flash Recovery Area (FRA) for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy()
You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()
User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()
Which statements are true about checkpointing()
You have set Tablespace Full Metrics Threshold values for the USERS tablespace as follows:Warning (%): 90Critical (%): 95Which background process is responsible for issuing alerts when the threshold is crossed()
In a new installation of Oracle Database 11g, you perform these activities:1. Organize software and data on different subdirectories to avoid poor performance.2. Use consistent naming conventions for database files.3. Separate administrative information pertaining to the database in different directories. Which optioncorresponds to the type of activities you performed()