Free Oracle 1z0-082 Practice Exam with Questions & Answers | Set: 3

as SCOTT in DALLAS_DB

as SCOTT in BOSTON_DB

as SCOTT in BOSTON_DB and SYS in DALLAS_DB

as SYS in both the databases

as SCOTT in both the databases

WHERE borrowed_date = SYSDATE AND transaction_type = 'RM*) OR member_id IN ('A101', 'A102');

WHERE borrowed_date = SYSDATE AND {transaction_type = 'RM* AND (raeraber_id = 'A101' OR member_id = 'A102));

WHERE borrowed_date = SYSDATE AND (transaction_ype = 'RM' AND .-neraber_id = 'A101' OR member_id = 'A102');

WHERE borrowed_date = SYSDATE AND (transaction_type = 'RM* OR member_id IN ('A101', 'A102'));

E, WHERE borrowed_date = SYSDATE AND transaction_type = 'RM' OR member_id IN ('A101', 'A102');

They can be written by server processes

Trace files are written to the Fast Recovery Area (FRA)

They can be written by background processes

All trace files contain error information that require contacting Oracle Support

Trace file names are based on the database name concatenated with a sequential number

in the undo tablespace

in the SYSAUX tablespace

in the SGA

in the PGA

in the temporary tablespace

A table can have only one primary key but multiple foreign keys

A table can have only one primary key and one foreign key

The foreign key columns and parent table primary key columns must have the same names

It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

Only the primary key can be defined at the column and table level

Primary key and foreign key constraints can be defined at both the column and table level

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.

It generates a sqi script that it uses to load data from EMP.DAT TO EMP.

It overwrites the data for Alan and adds data for Curl and Bob

It appends data from EMP.DAT TO EMP.

It overwrites all data in emp with data from emp.dat.

It generates a log that contains control file entries, which can be used with normal SQL'Loader operations.

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

Operating System authentication may be used for system-privileged administrative users.

REKOTE_LOGIN_PASSMOREFiLE must be set to exclusive to permit password changes for system-privileged administrative users.

Password authentication must be used for system-privileged administrative users.

Password File authentication must be used for system-privileged administrative users.

Password File authentication is supported for any type of database user.

SELECT REPLACE 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;