• Databases (GATE)
Back
0

Databases (GATE)

Description: GATE
Number of Questions: 15
Created by:
Tags: GATE Relational Functions of DBMS
Start the Quiz
Attempted 0/15 Correct 0 Score 0
‹
›

Which file contains user and system data?

  1. Control file

  2. Data file

  3. Online redo file

  4. Offline redo file

  5. Doc file

Show answer
Correct Option: B
Explanation:

This option is correct because a data file contains use rand system data for backup and recovery process.

Which process is responsible for updating file headers in the database data files?

  1. The Log Writer Process

  2. The Database Writer Process

  3. The Checkpoint Process

  4. The Process Monitor Process

  5. The System Monitor Process

Show answer
Correct Option: C
Explanation:

The Checkpoint Process is responsible for updating file headers in the database data files.

The dynamic performance view V$LOG contains information about

  1. all current redo logs
  2. redo log switches
  3. locations of redo log files

  1. Only 1

  2. Only 2

  3. Only 3

  4. 1 and 2

  5. 2 and 3

Show answer
Correct Option: A
Explanation:

The dynamic performance view V$LOG contains information about all current redo logs.

Which of the following contain(s) the information about all user objects in the database?

  1. Data dictionary

  2. Indexes

  3. Clusters

  4. System Global Area

  5. Library Cache

Show answer
Correct Option: A
Explanation:

Data dictionary consists of a special collection of tables that contains information about all user objects in the database.

Which SGA database buffer is used to store different block sizes?

  1. Database buffer cache

  2. KEEP buffer pool

  3. RECYCLE buffer pool

  4. nK buffer cache

  5. Shared pool

Show answer
Correct Option: D
Explanation:

nK buffer cache, one of the several specialised database buffer caches designed to hold block sizes different from the default database block size.

Find the false statement about Oracle Database Grid Computing.

  1. It has high performance and scalability.

  2. It uses dynamic resources.

  3. It has continuous availability of data and applications.

  4. It has single administrator which cannot manage hundreds of servers.

  5. It has advanced integration features that allow applications and data to run anywhere in the network.

Show answer
Correct Option: D
Explanation:

It is a false statement. Oracle infrastructure automates many functions so that a single administrator can manage hundreds of servers. So, this option is correct.

In order to parse SQL statements, the Oracle instance frequently accesses

  1. SGA

  2. PGA

  3. data dictionary

  4. views

  5. disk files

Show answer
Correct Option: C
Explanation:

In order to parse SQL statements, the Oracle instance frequently accesses data dictionary.

Among the following procedures, which one can be used for a locally managed system tablespace?

  1. TABLESPACE_MIGRATE_FROM_LOCAL

  2. TABLESPACE_MIGRATE_TO_LOCAL

  3. TABLESPACE_RELOCATE_BITMAPS

  4. TABLESPACE_FIX_BITMAPS

  5. TABLESPACE_REBUILD_BITMAPS

Show answer
Correct Option: B
Explanation:

TABLESPACE_MIGRATE_TO_LOCAL can be used for a locally managed system tablespace.

The PGA memory area of Oracle instance which holds the information about runtime-buffers is

  1. stack-space

  2. session-information

  3. private SQL-area

  4. sorting area

  5. strain area

Show answer
Correct Option: C
Explanation:

Private SQL-area holds information such as bind-variables and runtime-buffers.

In process architectures, which process gathers and stores Automatic Workload Repository data?

  1. MMAN

  2. MMON

  3. MMNL

  4. MMON Slaves

  5. PSWN

Show answer
Correct Option: C
Explanation:

MMNL - gathers and stores Automatic Workload Repository (AWR) data

Which of the following files hold the transactional history of the Oracle database?

  1. Data and index files

  2. Online redo log files

  3. Temp files

  4. Archive log files

  5. Offline redo log files

Show answer
Correct Option: B
Explanation:

Online redo log files hold the transactional history of the database.

Which schema(s) has/have the features of a privileged account?

  1. SYS schema

  2. SYSTEM schema

  3. OUTLN schema

  4. HR and OE schemas

  5. SCOTT schema

Show answer
Correct Option: B
Explanation:

SYSTEM schema has additional core database structures and utilities, and privileged account.

The Oracle RDBMS stores data logically in the form of

  1. data files

  2. tablespaces

  3. data segments

  4. extents

  5. data blocks

Show answer
Correct Option: B
Explanation:

The Oracle RDBMS stores data logically in the form of tablespaces.

In version–numbering syntax of the Oracle Database release, what does the third number tell?

  1. Platform Specific Release Number

  2. Component Specific Release Number

  3. Major Database Release Number

  4. Database Maintenance Release Number

  5. Application Server Release Number

Show answer
Correct Option: E
Explanation:

The third number tells about the Application Server Release Number.

___________ is the Oracle edition which is specially designed and priced for small business purposes.

  1. Oracle Enterprise Edition

  2. Oracle Standard Edition

  3. Oracle Standard Edition One

  4. Oracle Express

  5. Java

Show answer
Correct Option: C
Explanation:

Oracle Standard Edition One (SEO) - Oracle SEO is specially priced for single CPU servers used by small businesses.

- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions