Free Oracle Database Administration I 1Z0-082 Exam Practice Test

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• External table files can be used for other external tables in a different database
• The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• They cannot be partitioned
• The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• They support UPDATEs but not INSERTs and DELETEs

The customers table has a cust_last_name column of data type varchar2. The table has two rows whose "jst_last_name values are Andersen and Ausson. Which query produces output for cust_last_xame containing Oder for the first row and Aus for the second?

• SELECT REPLACE<TRIM<TRAILING 'son* FROM cust_last_name), 'An', *O'> FROM customers;
• SELECT REPLACE(SUBSTR(cust_last_name, -3), 'An', 'O') FROM customers;
• SELECT REPLACE(REPLACE(cust_last_name, 'son', ''), 'An', 'O'> FROM customers;
• SELECT INITCAP (REPLACE(TRIM('son' FROM cust_last_name), 'An', 'O*)) FROM customers;

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

• The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneither DIAGNOSTIC_DEST nor ORACLE_BASE is set
• The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set
• It supports diagnostics for Automatic Storage Management (ASM)
• It supports diagnostics for Oracle Clusterware
• It is held inside an Oracle database schema

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

• two or more instances on separate servers all associated with one database
• one instance on one server associated with one database
• one instance on one server associated with two or more databases on the same server
• one instance on one server not associated with any database
• one instance on one server associated with two or more databases on separate servers

Which three statements are true concerning logical and physical database structures? (Choose three.)

• All tablespaces may have one or more data files
• The extents of a segment must always reside in the same datafile
• A smallfile tablespace might be bigger than a bigfile tablespace
• A segment can span multiple data files in some tablespaces
• A segment’s blocks can be of different sizes
• A segment might have only one extent
• Segments can span multiple tablespaces

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.)

• A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• An UNUSED column’s space is reclaimed automatically when the block containing that column is next queried.
• An UNUSED column’s space is reclaimed automatically when the row containing that column is next queried.
• Partition key columns cannot be dropped.
• A DROP COLUMN command can be rolled back
• A column that is set to UNUSED still counts towards the limit of 1000 columns per table

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

• Connect Time Failover requires the use of Transparent Application Failover (TAF)
• Source Routing requires the use of a name server
• Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be Practice Test routed through a firewall
• Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• Load Balancing requires the use of a name server
• Connect Time Failover requires the connect string to have two or more listener addresses configured

Which three statements are true about inner and outer joins? (Choose three.)

• A full outer join returns matched and unmatched rows
• An inner join returns matched rows
• Outer joins can only be used between two tables per query
• A full outer join must use Oracle syntax
• Outer joins can be used when there are multiple join conditions on two tables
• A left or right outer join returns only unmatched rows

Which statement is true about database links?

• Private database link creation requires the same user to exist in both the local and the remote databases.
• A public database link can be created only by sys.
• A database link can be created only between two Oracle databases.
• A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
• A database link created in a database allows a connection from that database's instance to the target database's Instance, but not vice versa.

Which statement is true about aggregate functions?

• Aggregate functions can be nested to any number of levels
• The AVG function implicitly converts NULLS to zero
• Aggregate functions can be used in any clause of a SELECT statement
• The MAX and MIN functions can be used on columns with character data types