Subject: Oracle DBA 1. You attempt to run these statements: connect scott/tiger@
ID: 3850227 • Letter: S
Question
Subject: Oracle DBA
1. You attempt to run these statements:
connect scott/tiger@orcl
create database link L1 using ‘prod’;
select * from dual@L1;
2. Which of these outcomes is correct?
A. The database link will not create, because you have not specified any credentials.
B. Because no credentials were specified, the link will create as a public link.
C. The data link will create, with default credentials equivalent to the following: create database link L1 connect to scott identified by tiger using ‘prod’;
D. The SELECT will succeed if there is a user SCOTT identified by tiger in the remote database
3. How would you describe the ORACLE_HOME environment variable?
A. It specifies the root of OFA directory structure.
B. It specifies the default value for the Oracle Managed files parameters DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n.
C. It specifies the location of the Oracle software.
D. It specifies the location of inventory used by the Oracle Universal Installer (OUI)
4. Fine Grained Auditing (FGA) is usually configured to:
A. Report issues of no concern
B. Focus on object level
C. Track access to certain rows and columns
D. Record access through normal means in the working days
5. What view will show you which tablespace is being used for a user’s temporary data?
A. DBA_USERS
B. DBA_TABLESPACES
C. DATABASE_PROPERTIES
D. V$TABLESPACE
Explanation / Answer
2Ans).C.The data link will create,with default credentials equivalent
to to The Following:
create database link L1 connect to scott identified by tiger using 'prod';
3Ans).C It Specifies The Location Of The Oracle Software.
4.Ans)C.Track access to certain rows and Columns.
5Ans)B. DBA_TABLE SPACES