Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?

Extent
Segement
Oracle block
Operating system block

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are true ?

Check
Unique
Not Null
Primary Key
Foreign Key

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which statement is ture regarding checkpoints and recovery ?

A checkpoint defines the highest system change number (SCN)
All redo entries higher or at the SCN are known to be written to the data files.
Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.
The LOG_CHECKPOINT_INTERVAL initialization paramter specifies the amount of time beteen incremental checkpoints.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

What should you look at to compute the number of undo blocks written per second on disk ?

V$UNDOSTAT
V$TRANSACTION
V$ROLLSTAT
DBA_UNDO_EXTENTS
DBA_ROLLBACK_SEGS

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Which background process reads the redo log buffer and writes it to a file ?

ARCn
DBWn
CKPT
LGWR
PMON
SMON

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

In user-managed backup and recover procedure, how are data files backed up ?

Using SQL commands.
Using SQL*Plus Commands.
Using operating system commands.
Using Recover Manager commands.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Consider this RMAN command: RMAN> CONFIGURE RETENTION POLICY CLEAR; What is the effect of this command?

Backups will never expire.
It removes any retention policy.
The DELETE OBSOLETE command will fail with an error.
It sets the retention policy to the default of REDUNDANCY 1.

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

You have just run this syntax to start the listener from the Listener Control utility: LSNRCTL>START Starting /mstgelai/oracle/bin/tnslsnr: please wait... System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stc-sun01-server)(PORT=1521))) Connecting to... The command completed successfully What is the name of the Listener you started?

TNSLSNR
LISTENER
LOCAL_LISTENER
DEFAULT_LSRN

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?

LIST EXPIRED
DELETE EXPIRED
DELETE OBSOLETE
CHANGE UNCATALOG

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

When performing recovery of a database in NOARCHIVELOG mode with RMAN, the target database must be in the ______ state to restore the control file.

OPEN
IDLE
MOUNT
NOMOUNT

Reveal answer Fill a bubble to check yourself

← Previous
1
2
…
987
988
989
990
991
992
993
994
995
…
3670
3671
Next →