-
web.groovymark@gmail.com
- December 5, 2024
Question 41
Which of the following SQL statements disconnects a session after it has been idle for 30 minutes?
A) alter session set idle_timeout=30;
B) alter session set idle_timeout=1800;
C) alter profile default limit idle_time 30;
D) alter profile default set idle_timeout 30;
Correct Answer: C) alter profile default limit idle_time 30.
Explanation: Profiles manage idle time, among other resources, and limit idle session time using the idle_time parameter.
Question 42
Which of the following options prevents a user from reusing a password when they change their password?
A) Setting the initialization parameter NO_PASSWORD_REUSE to TRUE
B) Altering that user’s profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_REUSE_MAX
C) Altering that user’s profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX
D) Using a password verify function to record the new password and comparing the new passwords to those recorded previously.
Correct Answer: B) Altering that user's profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_REUSE_MAX.
Explanation: The combination of setting PASSWORD_REUSE_TIME to UNLIMITED and PASSWORD_REUSE_MAX to 1 ensures that passwords cannot be reused.
Question 43
Which of the following components of a ROWID uniquely identifies the location of a row in a database?
A) Data block address
B) Segment number
C) Relative file number
D) Table segment ID
Correct Answer: C) Relative file number.
Explanation: The ROWID includes the relative file number, block number, and row number within the block to uniquely identify a row's physical location.
Question 44
Which data dictionary view is used to view the current values of initialization parameters?
A) V$SPPARAMETER
B) V$DATABASE
C) V$PARAMETER
D) V$INSTANCE
Correct Answer: C) V$PARAMETER
Explanation: V$PARAMETER displays the current values of initialization parameters for the instance.
Question 45
Which SQL statement will prevent any new rows from being added to the JOBS table in the USERS tablespace, assuming the table currently exists?
A) DROP TABLE JOBS;
B) ALTER USER JAMES QUOTA 0 ON USERS;
C) ALTER TABLE JOBS NOLOGGING;
D) ALTER TABLE JOBS READ ONLY;
Correct Answer: B) ALTER USER JAMES QUOTA 0 ON USERS.
Explanation: Setting the user's quota on a tablespace to 0 prevents the allocation of additional space for the table, which will prevent new rows from being added.
Question 46
Which SQL statement creates a private database link?
A) CREATE DATABASE LINK linkname;
B) CREATE PRIVATE DATABASE LINK linkname;
C) CREATE PUBLIC DATABASE LINK linkname;
D) CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password;
Correct Answer: D) CREATE DATABASE LINK linkname CONNECT TO username IDENTIFIED BY password.
Explanation: Private database links are created without the PUBLIC keyword and require credentials to establish the connection.
Question 47
Which of the following initialization parameters is required to use Automatic Storage Management (ASM)?
A) ASM_DISKGROUPS
B) ASM_DISKSTRING
C) ASM_POWER_LIMIT
D) ASM_INSTANCE
Correct Answer: A) ASM_DISKGROUPS
Explanation: ASM_DISKGROUPS specifies the list of disk groups that will be mounted at instance startup.
Question 48
Which of the following SQL statements disables a role in the current session?
A) alter session disable role;
B) set role none;
C) alter session set role disabled;
D) alter session disable all roles;
Correct Answer: B) set role none.
Explanation: The set role none statement disables all roles for the current session.
Question 49
What happens when an ALTER SYSTEM statement is issued to change the value of the UNDO_RETENTION parameter?
A) The database must be restarted to apply the change.
B) The value is changed in memory, and the change is permanent if the database is using an spfile.
C) The change only affects new transactions.
D) The change only takes effect during the next maintenance window.
Correct Answer: B) The value is changed in memory, and the change is permanent if the database is using an spfile.
Explanation: ALTER SYSTEM changes take effect immediately in memory and are permanent if an spfile is in use.
Question 50
Which of the following privileges is required to create a public synonym in an Oracle database?
A) CREATE SYNONYM
B) CREATE PUBLIC SYNONYM
C) DBA
D) RESOURCE
Correct Answer: B) CREATE PUBLIC SYNONYM.
Explanation: The CREATE PUBLIC SYNONYM privilege allows a user to create a synonym that is accessible by all users in the database.
