Oracle 1Z0-052 Actual Free Exam Questions & Community Discussion
The tnsnames.ora file has an entry for the service alias ORCL as follows:
ORCL
( DESCRIPTION
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?
ORCL
( DESCRIPTION
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))
(CONNECT_DATA
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.oracle.com)
)
)
The TNSPING command executes successfully when tested with ORCL, but you are not able to connect to the database instance with the following command:
SQL> CONNECT scott/tiger@orcl
What could be the reason for this?
Correct Answer: A
Vote an answer
Which tablespaces are mandatory in an Oracle database for it to be operational? (Choose all that apply.)
Correct Answer: B,E
Vote an answer
Given below is a list of scenarios:
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3 . A schema is accidentally dropped.
4 . The tablespace is accidentally dropped from the database.
5 . The hard disk gets corrupted and the data files in the disk are lost.
6 . The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
1. A user terminates his session abnormally.
2. The connection between the server and the client application terminates because of a network failure.
3 . A schema is accidentally dropped.
4 . The tablespace is accidentally dropped from the database.
5 . The hard disk gets corrupted and the data files in the disk are lost.
6 . The database instance abnormally shuts down because of power failure.
Which scenarios require DBA intervention to perform recovery?
Correct Answer: D
Vote an answer
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
Correct Answer: B,E,F
Vote an answer
Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)
Correct Answer: B,C
Vote an answer
The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
Which statement is true about redo log files during instance recovery?
Correct Answer: C
Vote an answer
Which three are true about UNDO data? (Choose three.)
Correct Answer: B,D,E
Vote an answer
Explanation: Only visible for EduDump members. You can sign-up / login (it's free).
In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
1 . The user account must be locked after four unsuccessful login attempts.
2 . The user must be prompted to change the password at regular intervals.
3 . The user may not have more than three simultaneous sessions.
4 . The user session must automatically be logged off if more than 10 minutes elapsed time used.
How would you accomplish the above?
Correct Answer: B
Vote an answer
Examine this LISTENER.ORA file:
How should you configure and start an additional listener LISTENER2 that listens for the same SID?
How should you configure and start an additional listener LISTENER2 that listens for the same SID?
Correct Answer: C
Vote an answer
Which two are true about data dictionary views? (Choose two.)
Correct Answer: A,D
Vote an answer
Why does performance degrade when many UPDATE, INSERT or DELETE statements are issued on a table that has an associated bitmap index?
Correct Answer: B
Vote an answer
0
0
0
10