Home › Quizzes › Oracle Database Administration (GATE)

Oracle Database Administration (GATE)

Oracle DBA concepts including background processes, privileges, datafiles, tablespaces, recovery, and memory management for GATE exam preparation.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

How many database write processes are acceptable in Oracle?

  1. 20
  2. 10
  3. 5
  4. 1
  5. 2
Question 2 Multiple Choice (Single Answer)

Which of the following will perform process recovery when user process fails?

  1. PMON
  2. SMON
  3. Database writer
  4. Log writer
  5. Checkpoint
Question 3 Multiple Choice (Single Answer)

Which dynamic view should a DBA query use to obtain information about the different sections of the control file?

  1. V$CONTROLFILE_RECORD_SECTION
  2. V$CONTROLFILE
  3. V$CONTROLFILE_SECTION
  4. DBA_CONTROLFILE_SECTION
  5. DBA_CONRTOLFILE_RECORD_SECTION
Question 4 Multiple Choice (Single Answer)

ORA-1578 stands for

  1. internal errors
  2. block corruption errors
  3. deadlock errors
  4. errors occurred during dispached processes
  5. external errors
Question 5 Multiple Choice (Single Answer)

Which connections use only password files to authenticate DBA to connect with Oracle as a privileged user?

  1. Non-secure remote connections
  2. Local connections
  3. Secure remote connections
  1. Only 1
  2. Only 2
  3. Only 3
  4. Both 1 and 2
  5. Both 1 and 3
Question 6 Multiple Choice (Single Answer)

Which of the following operations is not authorised by the SYSOPER system privilege?

  1. Performing start up and shut down operations
  2. Creating database
  3. Altering database
  4. Archiving log and recovery
  5. Including the restricted session privilege
Question 7 Multiple Choice (Single Answer)

When a user starts a new session in a database server, which process(es) is/are involved first?

  1. The Oracle login process
  2. The Oracle server process
  3. The system monitor process
  4. Both 1 and 3
  5. PMON
Question 8 Multiple Choice (Single Answer)

System datafiles contain

  1. undo data
  2. temporary data
  3. business data
  4. meta data
  5. meso data
Question 9 Multiple Choice (Single Answer)

Who is responsible for planning for backup and recovery of database information?

  1. Network administrator
  2. Security officer
  3. Database administrator
  4. Application administrator
  5. Database user
Question 10 Multiple Choice (Single Answer)

Who can modify the data in the database?

  1. Database administrators
  2. Network administrators
  3. Application developers
  4. Application administrators
  5. Database users
Question 11 Multiple Choice (Single Answer)

Which task can a DBA perform using the export/import facility?

  1. Examine data files
  2. Examine log files
  3. Recreate the control file
  4. Transport table spaces between databases
  5. Make a logical backup of the rollback segment tablespace
Question 12 Multiple Choice (Single Answer)

Which SGA memory structure cannot be resized dynamically after instance startup?

  1. Database buffer cache
  2. Log buffer
  3. Large pool
  4. Java pool
  5. Shared pool
Question 13 Multiple Choice (Single Answer)

Sets of dictionary tables are generated

  1. every time a tablespace is created
  2. once for the entire database
  3. every time a user is created
  1. Only 1
  2. Only 2
  3. Only 3
  4. 1, 2 and 3
  5. Only 1 and 2
Question 14 Multiple Choice (Single Answer)

Before creating a transportable table space, which condition should be satisfied?

  1. All indexes are enabled.
  2. All indexes are disabled.
  3. The tables containing nested tables are contained in the same tablespace.
  4. The source and target system must use the same operating system.
  5. The target system has the tablespace which is created already.
Question 15 Multiple Choice (Single Answer)

Why should a datafile be set to offline when the database is in MOUNT state?

  1. To recover it later, when database is in NOARCHIVELOG mode
  2. To minimise downtime
  3. To prevent further corruption of a damaged datafile
  4. To allow for automatic datafile recovery
  5. To reject the datafile automatically
← Back to Quizzes