A. It Is held Inside an Oracle database schema.
B. The ADR base is specified In the diagnostic_dest database parameter.
C. It can be used for problem diagnosis of a database when that database's instance is down.
D. It is only used for Oracle Database diagnostic information.
E. It is a file-based repository held outside any database.
A. Display the total number of products supplied by supplier 102 which have a product status of obsolete
B. Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE
C. Display suppliers whose PROD_LIST_PRICE is less than 1000
D. Display the minimum PROD_LIST_PRICE for each product status
E. Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
A. The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
B. The listener is not listening on the default port 1521
C. The service DB01.abc.com is statically registered
D. The service DB01.abc.com is dynamically registered
E. The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
A. Duplicates are eliminated automatically by the UNION ALL operator
B. The number of columns selected in each SELECT statement must be identical
C. The output is sorted by the UNION ALL operator
D. NULLS are not ignored during duplicate checking
E. The names of columns selected in each SELECT statement must be identical
A. Active UNDO is always retained.
B. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unexpired UNDO.
C. Unexpired UNDO is always retained.
D. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.
E. UNDO_RETENTION specifies how long all types of UNDO are retained.
A. Create an additional listener.
B. Create a template that can be used to clone the database.
C. Change the character set.
D. Change the server mode from dedicated to shared, and vice versa.
E. Create nonstandard block size tablespaces.
A. The shrink operation causes rows to be moved to empty space starting toward the end of the orders segment.
B. The shrink operation causes rows to be moved to empty space starting from the beginning of the orders segment.
C. Dependent indexes become UNUSABLE.
D. Queries and DML statements are allowed on ORDERS while the shrink is executing.
E. The high-water mark (HWM) of orders is adjusted.
F. Only queries are allowed on ORDERS while the shrink is executing.
A. V$TABLESPACE displays information about tablespaces contained in the data dictionary
B. Tablespace free space can be viewed in DBA_TABLESPACES
C. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
D. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
E. Tablespace free space can be viewed in V$TABLESPACE
A. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.
C. The file is renamed and stored in the same location
D. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
E. DML may be performed on tables with one or more extents in this data file during the execution of this command.
A. Execute DML statements in the HR schema
B. Execute DDL statements in the HR schema
C. Revoke the CREATE SESSION privilege from user HR
D. Revoke the CREATE SESSION privilege from other users
E. Grant the CREATE SESSION privilege with ADMIN OPTION to other users
F. Log in to the database instance
