Home › Quizzes › Oracle Databases (GATE)

Oracle Databases (GATE)

Oracle Database, GATE Oracle

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Match the following:
Column – I Column – II
A. Database administrator 1. Interact with the database through applications or utilities
B. Security officers 2. Planning for backup and recovery of database information
C. Database users 3. Enroll user controls, monitor user access to the database and maintain system security
  1. A - 1, B - 2, C - 3
  2. A - 1, B - 3, C - 2
  3. A - 2, B - 1, C - 3
  4. A - 2, B - 3, C - 1
  5. A - 3, B - 1, C - 2
Question 2 Multiple Choice (Single Answer)

Which of the following numerals identifies the database maintenance release in Oracle Database release labelled 11.2.0.1.0?

  1. 11
  2. 2
  3. 0
  4. 1
  5. 3
Question 3 Multiple Choice (Single Answer)

Which of the following operations are authorised by the SYSOPER system privilege?

  1. Perform startup and shutdown operations
  2. Create database
  3. Alter database
  4. Archive log and recovery
  5. Restricted session privileges
  1. 1, 2 and 3
  2. 1, 2, 3 and 4
  3. 1, 3, 4 and 5
  4. 2, 3 and 4
  5. 2, 4 and 5
Question 4 Multiple Choice (Single Answer)

Which of the following is NOT true regarding Program Global Area (PGA)?

  1. It is a non-shared memory.
  2. It is created when a server process is started.
  3. Each server process is allocated One PGA.
  4. Total memory used by all individual PGAs is called total instance PGA memory.
  5. Database initialization parameters are used to set the size of individual PGAs.
Question 5 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 6 Multiple Choice (Single Answer)

When a user starts a new session in a database server, which process is involved first?

  1. The Oracle login process
  2. The Oracle server process
  3. SMON
  4. PMON
  5. The recoverer process
Question 7 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 8 Multiple Choice (Single Answer)

How many database writer processes are allowed in Oracle?

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

Which of the following Oracle Dynamic Performance Views gives the names and status of control files for an Oracle instance?

  1. V$CONTROLFILE_RECORD_SECTION
  2. V$CONTROLFILE
  3. V$PARAMETER
  4. V$DATABASE
  5. SHOW PARAMETER CONTROL_FILES
Question 10 Multiple Choice (Single Answer)

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

  1. Examine log files
  2. CREATE CONTROLFILE
  3. Transport tablespaces between databases
  4. Make a logical backup of the rollback segment tablespace
  5. Determine if platforms are supported and determine endianness
Question 11 Multiple Choice (Single Answer)

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

  1. To minimise downtime
  2. To prevent further corruption of a damaged datafile
  3. To allow automatic recovery of the datafile
  4. To recover it later, when database is in NOARCHIVELOG mode
  5. To maximise uptime
Question 12 Multiple Choice (Single Answer)

Match the following

Column I Column II
A. ORA-00060 1. Internal errors
B. ORA-01578 2. Block corruption errors
C. ORA-00600 3. Deadlock errors
  1. A - 1, B - 3, C - 2
  2. A - 2, B - 1, C - 3
  3. A - 3, B - 2, C - 1
  4. A - 1, B - 2, C - 3
  5. A - 2, B - 3, C - 1
Question 13 Multiple Choice (Single Answer)

A set of dictionary tables is created

  1. every time a tablespace is created
  2. once for an entire database
  3. every time a user is created
  4. when time data is created
  5. Both (1) and (2)
Question 14 Multiple Choice (Single Answer)

System datafiles consist of

  1. undo data
  2. temporary data
  3. business data
  4. metadata
  5. permanent data
Question 15 Multiple Choice (Single Answer)

The SQL statement which is used to delete a particular column in an existing table is

  1. SQL Alter
  2. SQL Modify
  3. SQL Drop
  4. SQL Delete
  5. SQL Update
← Back to Quizzes