Tag: databases

Questions Related to databases

Which two statements are true about the role in Oracle Database?

technology databases

  1. A role can contain both system and object privileges.

  2. A role cannot be assigned external authentication.

  3. A role can be granted to itself.

  4. Roles are owned by the SYS user.

  5. Roles can be granted to other roles

Show answer
Correct Option: A,E

Which of the following SQL statements results in a disconnection after a session is idle for 30 minutes?

technology databases

  1. alter session set idle_timeout=30;

  2. alter session set idle_timeout=1800;

  3. alter profile limit idle_time 30;

  4. alter profile set idle_timout 30;

Show answer
Correct Option: C

Which three information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control?

technology databases

  1. The database services to be registered with the listener

  2. The log file and trace file destination for the listener.

  3. The protocol used by the listener

  4. The server name where the listener runs.

  5. The port used by the listener.

Show answer
Correct Option: C,D,E

Which of the following prevents a user from reusing a password when they change their password?

technology databases

  1. Setting the initialization parameter NO_PASSWORD_REUSE to TRUE

  2. Altering that user’s profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_REUSE_MAX

  3. Altering that user’s profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_REUSE_MAX

  4. Using a password verify function to record the new password and compare the new passwords to those recorded previously

Show answer
Correct Option: B

How can you prevent someone from using an all-numeric password?

technology databases

  1. Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.

  2. Alter that user’s profile setting PASSWORD_COMPLEXITY to ALPHNANUM.

  3. Alter the user’s profile to use a password verify function that performs REGEX comparisons to validate the password.

  4. There is no mechanism that lets you prevent an all-numeric password

Show answer
Correct Option: C

You specified segment space management as automatic for a tablespace what effect would this have on space management?

technology databases

  1. Extents would be managed by freelists.

  2. Free space would be managed by data dictionary.

  3. The segment would be managed by bitmaps.

  4. The segment would be managed by freelists.

Show answer
Correct Option: C

Which of the following is not an object privilege on a table?

technology databases

  1. SELECT

  2. DEBUG

  3. REFERENCES

  4. READ

Show answer
Correct Option: D

A user wants to connect to the database instance from an application that is running on a remote machine. Which tool should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance? (Choose two).

technology databases

  1. Oracle Net Manager.

  2. Data Pump.

  3. Oracle Universal Installer (OUI).

  4. Oracle Enterprise Manager.

  5. Database Configuration Assistant (DBCA).

Show answer
Correct Option: A,D

Which two are valid locking levels that are used by transactions in oracle database? (Choose two)

technology databases

  1. Object level.

  2. Row level.

  3. Block level.

  4. Schema level.

  5. Database level.

Show answer
Correct Option: A,B

Your database is having two control files; three redo log file groups with two members in each group. Failure of which file would cause a instance to shut down?

technology databases

  1. Loss of the initialization parameter file.

  2. One of the redo log members.

  3. Any data file belonging to the default permanent tablespace

  4. Any archive log file.

  5. Any control file.

Show answer
Correct Option: E