EMP_IDX is an index on the EMP.ENO column. EMP and EMP_IDX reside in the TBS1 tablespace. During an INSERT into EMP, you get this error: Which two actions would you take to correct the space problem in TBS1 without affecting…

You execute this command: Which two statements are true about the SALES tablespace? (Choose two.) A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation. B. It is read-only by default. C. DML operations performed on objects…

Which is true about revoking roles? A. Only users who are granted the DBA role can revoke a role. B. Only users who are granted SYSDBA can revoke a role. C. Users who have the GRANT ANY ROLE privilege can…

Which two operations can be performed on external tables? (Choose two.) A. creating invisible indexes B. creating views C. creating partitions D. creating public synonyms E. executing UPDATE statements

Which two are true about the AL32UTF8 character set? (Choose two.) A. It is used to encode data for columns of any data type. B. It supports multilingual databases. C. It uses less space than other character sets, for all…

For which three purposes is UNDO used? (Choose three.) A. flashback queries B. FLASHBACK TABLE <tablename> TO BEFORE DROP operations C. the roll forward phase of instance recovery D. RESTORE DATABASE operations E. ROLLBACK operations F. read consistency

In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE. UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on. Which statement is true about a…

As the DBA, you execute this command: BROWN then executes this command: GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION; Which is true? A. You can revoke only WITH GRANT OPTION from BROWN. B. BROWN can revoke only WITH…

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: How do you execute the command so that only SCOTT in…

Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.) A. control files B. bad files C. input files D. password files E. server parameter files (SPFILE) F. dump files