1z0-082 Free Practice Test

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)

1. A. The online redo logs are opened
2. B. The online data files are opened
3. C. The alert log records the execution details
4. D. The Oracle background processes are started
5. E. The initialization parameter file is read
6. F. The control file is read

Correct Answer: DF

Which three statements are true about views in an Oracle database? (Choose three.)

1. A. Views can be updated without the need to re-grant privileges on the view
2. B. Tables in the defining query of a view must always exist in order to create the view
3. C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
4. D. Data Manipulation Language (DML) can always be used on views
5. E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
6. F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
7. G. The WITH CHECK clause prevents certain rows from being updated or inserted

Correct Answer: BDE

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

1. A. A table can have only one primary key but multiple foreign keys
2. B. A table can have only one primary key and foreign key
3. C. The foreign key columns and parent table primary key columns must have the same names
4. D. 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
5. E. 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
6. F. Only the primary key can be defined at the column and table level
7. G. Primary key and foreign key constraints can be defined at both the column and table level

Correct Answer: ACEG

Which three statements are true regarding indexes? (Choose three.)

1. A. A UNIQUE index can be altered to be non-unique
2. B. A SELECT statement can access one or more indices without accessing any tables
3. C. A table belonging to one user can have an index that belongs to a different user
4. D. An update to a table can result in updates to any or all of the table’s indexes
5. E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
6. F. An update to a table can result in no updates to any of the table’s indexes

Correct Answer: ADE

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:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

1. A. as SCOTT in DALLAS_DB
2. B. as SCOTT in BOSTON_DB
3. C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
4. D. as SYS in both the databases
5. E. as SCOTT in both the databases

Correct Answer: D