Relational Database Management System (GATE) Online Test

Back

0

Relational Database Management System (GATE)

Description: GATE
Number of Questions: 15
Created by:
Tags: GATE RDMS Relational Database Management System Database Oracle Relational Functions of DBMS

Start the Quiz

How many database write processes are acceptable in Oracle?

20
10
5
1
2

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

PMON
SMON
Database writer
Log writer
Checkpoint

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

V$CONTROLFILE_RECORD_SECTION
V$CONTROLFILE
V$CONTROLFILE_SECTION
DBA_CONTROLFILE_SECTION
DBA_CONRTOLFILE_RECORD_SECTION

ORA-1578 stands for

internal errors
block corruption errors
deadlock errors
errors occurred during dispached processes
external errors

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

Non-secure remote connections
Local connections
Secure remote connections

Only 1
Only 2
Only 3
Both 1 and 2
Both 1 and 3

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

Performing start up and shut down operations
Creating database
Altering database
Archiving log and recovery
Including the restricted session privilege

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

The Oracle login process
The Oracle server process
The system monitor process
Both 1 and 3
PMON

System datafiles contain

undo data
temporary data
business data
meta data
meso data

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

Network administrator
Security officer
Database administrator
Application administrator
Database user

Who can modify the data in the database?

Database administrators
Network administrators
Application developers
Application administrators
Database users

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

Examine data files
Examine log files
Recreate the control file
Transport table spaces between databases
Make a logical backup of the rollback segment tablespace

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

Database buffer cache
Log buffer
Large pool
Java pool
Shared pool

Sets of dictionary tables are generated

every time a tablespace is created
once for the entire database
every time a user is created

Only 1
Only 2
Only 3
1, 2 and 3
Only 1 and 2

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

All indexes are enabled.
All indexes are disabled.
The tables containing nested tables are contained in the same tablespace.
The source and target system must use the same operating system.
The target system has the tablespace which is created already.

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

To recover it later, when database is in NOARCHIVELOG mode
To minimise downtime
To prevent further corruption of a damaged datafile
To allow for automatic datafile recovery
To reject the datafile automatically

- Hide questions