Home › Quizzes › Oracle Database Administration

Oracle Database Administration

This test consists of questions related to Oracle database Administration, which are useful for CS and gate aspirants.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following is/are the tasks performed in evaluating the database server hardware by the oracle database administrator?

  1. It checks the available memory to the oracle instances.
  2. It defines the logical storage structure of the database.
  3. It also checks, how many disk drives are available to oracle and its databases.
  4. All of the above
  5. Both (1) and (3)
Question 2 Multiple Choice (Single Answer)

Which of the following tasks is/are involved in system monitoring process by the database administrator in oracle database?

  1. Configuration of the data
  2. Performance of the data
  3. Data accessibility
  4. All of the above
  5. Both (2) and (3)
Question 3 Multiple Choice (Single Answer)

Which of the following plannings does a database administrator have during the planning of the database in oracle database?

  1. To develop a back up and security of the database
  2. The performance of the database.
  3. The logical storage structures of the database.
  4. The efficiency of backup and recovery procedures for the database
  5. All of the above
Question 4 Multiple Choice (Single Answer)

What is hybrid mode in the data access step of monitoring process by the database administrator?

  1. It is a mediator mode between 'monitor-poll' and 'agent-push' mode.
  2. In this mode, one or more processes in the monitoring system actually poll the system elements in some thread.
  3. The Hybrid mode is useful when all monitoring mechanisms have not been implemented.
  4. Both (1) and (2)
  5. Both (1) and (3)
Question 5 Multiple Choice (Single Answer)

Which of the following is a false statement about 'Agent push' mode step in system monitoring by the database administrator?

  1. In this mode, the monitored host is simply pushing data from itself to the system monitoring application.
  2. This mode can work asynchronously.
  3. By using this mode, the load of the monitoring system can be reduced.
  4. By using this mode, the system monitor can do all the polling in whatever simple means are available.
  5. Both (1) and (4)
Question 6 Multiple Choice (Single Answer)

Which of the following is/are the disadvantage(s) of 'Agent Push' mode of system monitoring process in database administration?

  1. The data pushed in the to monitoring application asynchronously.
  2. In this mode, the monitoring system's load can be reduced to simply accepting and storing data.
  3. The logic for the polling cycle/options are not centralized at the system monitor.
  4. All of the above
  5. Both (2) and (3)
Question 7 Multiple Choice (Single Answer)

Which of the following is/are true statements about the shutting down with transactional clause in oracle database administration?

  1. When this clause is applied, no new connection can be allowed further.
  2. No client can be accessed after the completion of the transactions in the database.
  3. 'SHUTDOWN TRANSACTIONAL' command use for shutting down with transactional clause.
  4. No new transactions allowed to be started after the statement is issued.
  5. All of the above
Question 8 Multiple Choice (Single Answer)

Which of the following is false in the installation process of the oracle database server by the database administrator?

  1. The database can be controlled by the central computer after installation.
  2. The database tools can be executed on client side.
  3. The database administrator handled the tasks like installation of database application, front end tools with Oracle database server.
  4. The oracle net components are not necessary to install to execute the database.
  5. Both (3) and (4)
Question 9 Multiple Choice (Single Answer)

Which of the following is not a task of a database administrator in oracle database?

  1. Backing up and restoring the database
  2. Planning for backup and recovery of database information
  3. Ensuring compliance with your oracle license agreement
  4. All of the above
  5. Both (1) and (3)
Question 10 Multiple Choice (Single Answer)

Which of the following is/are true about the password file authentication to authenticate an administrative user?

  1. The password file must be created in password file authentication.
  2. REMOTE_LOGIN_PASSWORDFILE can be changed without restarting the database.
  3. In this authentication, the SYSDBA or SYSOPER system privilege grant to the user.
  4. All of the above
  5. Both (1) and (3)
Question 11 Multiple Choice (Single Answer)

Which of the following is/are correct in operating system authentication process in oracle database administration?

  1. The group OSDBA has a specific name 'dba' for Unix user group.
  2. For the member of the OSDBA group with the SYSDBA, the system privilege will be SYSDBA while connecting to the database.
  3. For the member of the SYSOPER group with the SYSDBA, the system privilege will be SYSOPER while connecting to the database.
  4. The CONNECT command fails in case of no member from the groups SYSDBA or SYSOPER found while connecting to the database.
  5. All of the above
Question 12 Multiple Choice (Single Answer)

Which of the following is/are the prerequisites that should meet the criteria while creating a new database by the database administrator?

  1. There must be sufficient memory available to start the oracle database instance.
  2. There must be sufficient disk storage space must be available for the planned database.
  3. The operating system privileges must be associated with a fully operational database administrator.
  4. All of the above
  5. Both (2) and (3)
Question 13 Multiple Choice (Single Answer)

Which of the following is not mandatory while invoking the password file creation command in password file authentication for oracle database administration?

  1. The name of the password file
  2. The password
  3. The maximum number of distinct DBAs and OPERs
  4. To check whether to overwrite existing file
  5. Both (3) and (4)
Question 14 Multiple Choice (Single Answer)

Which of the following is/are true statement(s) about database administrator authentication in oracle database?

  1. SYSDBA authorizes ALTER DATABASE ARCHIVELOG.
  2. SYSDBA authorizes DROP DATABASE.
  3. SYSOPER privilege performs STARTUP and SHUTDOWN operations.
  4. SYSOPER privilege authorizes ALTER DATABASE ARCHIVELOG.
  5. All of the above
Question 15 Multiple Choice (Single Answer)

Which of the following is/are true about the shutting down with the ABORT clause in database administration of oracle database?

  1. The database can be shutdown instantaneously by this clause.
  2. After this clause, uncommitted transactions are not rolled back.
  3. After this clause, the database implicitly disconnects all connected users.
  4. All of the above
  5. Both (1) and (3)
← Back to Quizzes