1z0-082 Practice Exam Questions with Answers Oracle Database Administration I Certification

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

Add the AUTOEXTEND ON clause with NEXT set to 100M.

Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

Display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE

Display suppliers whose PROD_LIST_PRICE is less than 1000

Display products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable

Display the total number of products supplied by supplier 102 which have a product status of obsolete

Display the minimum PROD_LIST_PRICE for each product status

All roles granted to a user are set on by default when the user logs in,

Object privileges may not be granted to roles.

The SET ROLE statement can disable one or more roles for a session.

Roles must be password protected.

Roles may be granted to roles.

The SET ROLE statement can enable one or more roles for a session.

PCTFREE defaults to 10% for all blocks in all segments for all compression methods

ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows

Update operations always attempt to find blocks with free space appropriate to the length of the row being updated

Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted

A block will always be eligible for inserts if the row is short enough to fit into the block

SALES1 has not NULL constraints on any selected columns which had those constraints in the sales table.

SALES1 has primary key and unique constraints on any selected columns which had those constraints in the sales table.

SALES1 is created with 55,000 rows.

SALES1 is created with no rows.

SALES1 is created with 1 row.

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 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

SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';

SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';

SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id I I q' ('s not available) • 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK

SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;

d3_32k_cache_size should be set to a value greater than db_cache_size.

db_32k_cache_size must be set to a value that can be accommodated in the SGA.

db_32r_cache_si2e must be less than db_ca=he_size.

db_cache_s:ze must be set to a size that is smaller than db_32k_cache_size.

The /u02 file system must have at least lOOg space for the datafile.

The operating system must use a 32k block size.

It succeeds and the generated undo is stored in SYSTEM.

It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'”.

It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.

It succeeds and the generated undo is stored in SYSAUX.

It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

SELECT * FROM customers WHERE city LIKE ‘D_%’;

SELECT * FROM customers WHERE city = ‘%D_’;

SELECT * FROM customers WHERE city LIKE ‘D_’;

SELECT * FROM customers WHERE city = ‘D_%’;

Data dictionary views are created by joins of dictionary base tables and DBA-defined tables

The data dictionary is created and maintained by the database administrator

Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary

Base tables can be queried directly

It is owned by the SYSTEM user

Usernames of all users including database administrators are stored in the data dictionary

Tablespace free space can be viewed in V$TABLESPACE

V$TABLESPACE displays information that is contained in the controlfile about tablespaces

V$TABLESPACE displays information about tablespaces contained in the data dictionary

Tablespace free space can be viewed in DBA_TABLESPACES

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

INTERSECT

UNION ALL

UNION

SUBTRACT

MINUS

Statement 1 returns only one row of output.

Statement 2 returns only one row of output.

Both statements will return NULL if either UNIT_PRICE or QUANTITY contains NULL.

Both the statements give the same output.

Statement 2 may return multiple rows of output.

The CURRENT_TIMESTAMP function returns data without time zone information

A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row

A TIMESTAMP data type column contains information about year, month, and day

The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC)

You can use a single instance of EM Express to manage multiple database running on the same server.

EM Express uses a separate repository database to store target database metadata.

By default, EM express is available for a database after database creation using DBCA.

You can shut down a database instance using EM Express.

You cannot start up a database instance using EM Express.