1.My database was terminated while in BACKUP MODE, do I need to recover?
If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the database. The DBA is then required to recover the database and apply all archived logs to the database. However, from Oracle 7.2, one can simply take the individual datafiles out of backup mode and restart the database.
ALTER DATABASE DATAFILE '/path/filename' END BACKUP;
One can select from V$BACKUP to see which datafiles are in backup mode. This normally saves a significant amount of database down time. See script end_backup2.sql in the Scripts section of this site.
From Oracle9i onwards, the following command can be used to take all of the datafiles out of hotbackup mode:
ALTER DATABASE END BACKUP;
This command must be issued when the database is mounted, but not yet opened.
2.ORA-00257:
archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.
Action: Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
3.Can we perform DML operation on Materialized view?
A.Yes
B.No
Answer: b
4.What are the dictionary tables used to monitor a database spaces ?
DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.
5.Distributed database
.......................................................................................................................
6.rollback segment
.................................................................................................................................
7.hit ratio.
..................................................................................................
8.deadlocks
..............................................................................................................
9.when system tablespace created
,.................................................................................................................
10.coalesce tablespace space what does?
..............................................................................................................................
11.solve SNAPSHOP TOO OLD ?
.....................................................................................................................
12.Which of the following statements about listeners is correct?
A. A listener can connect you to one instance only.
B. A listener can connect you to one service only.
C. Multiple listeners can share one network interface card.
D. An instance will only accept connections from the listener specified on the local_listener parameter.
Answer: c
................................................................................................................................
13.create backup control file ?
..................................................................................................................
14.How does a DBA specify multiple control files?
A. With the ADD CONTROLFILE command.
B. By using the files in the STARTUP command.
C. With the MULTIPLEX control file command.
D. By listing the files in the CONTROL_FILES parameter.
Answer: d
..............................................................................................................
15.Which task can a DBA perform using the export/import facility?
A.Examine log files.
B.Recreate the control file.
C.Transport tablespaces between databases.
D.Make a logical backup of the rollback segment tablespace.
Answer: c
.....................................................................................................................................
16.You are using hot backup without being in archivelog mode, can you recover in the event of a failure?
A. Yes
B. No
Answer: b and how ?
/............................................................................................................................
17.When performing an open database backup, which statement is NOT true?
A. The database is fully accessible to all users.
B. The database must be operating in ARCHIVELOG mode.
C. The database can be open but only in READ ONLY mode.
D. The database tablespaces should be in BEGIN BACKUP mode.
Answer: c
........................................................................................................................
18.What command would you use to create a backup control file?
Answer: Alter database backup control file to trace.
...........................................................................................................................
19.What are the steps involved in Database Startup?
Answer: Start an instance, Mount the Database and Open the Database.
..............................................................................................................
20.What are the steps involved in Database Shutdown?
Answer: Close the Database, Dismount the Database and Shutdown the Instance.
...........................................................................................................................
21.What is Archived Redo Log?
Answer: Archived Redo Log consists of Redo Log files that have archived before being
reused.
............................................................................................................................
22.Explain the difference between a data block, an extent and a segment.
Answer: A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database
object.
............................................................................................................................
23.Partition-Level Export
Please send Documents to kumarbobby143@gmail.com if you attended any Interview
So,I can upload it in this blog , it will be useful to us and others
Thank Yoy
If a database was terminated while one of its tablespaces was in BACKUP MODE (ALTER TABLESPACE xyz BEGIN BACKUP;), it will tell you that media recovery is required when you try to restart the database. The DBA is then required to recover the database and apply all archived logs to the database. However, from Oracle 7.2, one can simply take the individual datafiles out of backup mode and restart the database.
ALTER DATABASE DATAFILE '/path/filename' END BACKUP;
One can select from V$BACKUP to see which datafiles are in backup mode. This normally saves a significant amount of database down time. See script end_backup2.sql in the Scripts section of this site.
From Oracle9i onwards, the following command can be used to take all of the datafiles out of hotbackup mode:
ALTER DATABASE END BACKUP;
This command must be issued when the database is mounted, but not yet opened.
2.ORA-00257:
archiver error. Connect internal only, until freed.
Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo log file.
Action: Check archiver trace file for a detailed description of the problem. Also verify that the device specified in the initialization parameter ARCHIVE_LOG_DEST is set up properly for archiving.
3.Can we perform DML operation on Materialized view?
A.Yes
B.No
Answer: b
4.What are the dictionary tables used to monitor a database spaces ?
DBA_FREE_SPACE
DBA_SEGMENTS
DBA_DATA_FILES.
5.Distributed database
.......................................................................................................................
6.rollback segment
.................................................................................................................................
7.hit ratio.
..................................................................................................
8.deadlocks
..............................................................................................................
9.when system tablespace created
,.................................................................................................................
10.coalesce tablespace space what does?
..............................................................................................................................
11.solve SNAPSHOP TOO OLD ?
.....................................................................................................................
12.Which of the following statements about listeners is correct?
A. A listener can connect you to one instance only.
B. A listener can connect you to one service only.
C. Multiple listeners can share one network interface card.
D. An instance will only accept connections from the listener specified on the local_listener parameter.
Answer: c
................................................................................................................................
13.create backup control file ?
..................................................................................................................
14.How does a DBA specify multiple control files?
A. With the ADD CONTROLFILE command.
B. By using the files in the STARTUP command.
C. With the MULTIPLEX control file command.
D. By listing the files in the CONTROL_FILES parameter.
Answer: d
..............................................................................................................
15.Which task can a DBA perform using the export/import facility?
A.Examine log files.
B.Recreate the control file.
C.Transport tablespaces between databases.
D.Make a logical backup of the rollback segment tablespace.
Answer: c
.....................................................................................................................................
16.You are using hot backup without being in archivelog mode, can you recover in the event of a failure?
A. Yes
B. No
Answer: b and how ?
/............................................................................................................................
17.When performing an open database backup, which statement is NOT true?
A. The database is fully accessible to all users.
B. The database must be operating in ARCHIVELOG mode.
C. The database can be open but only in READ ONLY mode.
D. The database tablespaces should be in BEGIN BACKUP mode.
Answer: c
........................................................................................................................
18.What command would you use to create a backup control file?
Answer: Alter database backup control file to trace.
...........................................................................................................................
19.What are the steps involved in Database Startup?
Answer: Start an instance, Mount the Database and Open the Database.
..............................................................................................................
20.What are the steps involved in Database Shutdown?
Answer: Close the Database, Dismount the Database and Shutdown the Instance.
...........................................................................................................................
21.What is Archived Redo Log?
Answer: Archived Redo Log consists of Redo Log files that have archived before being
reused.
............................................................................................................................
22.Explain the difference between a data block, an extent and a segment.
Answer: A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents that an object takes when grouped together are considered the segment of the database
object.
............................................................................................................................
23.Partition-Level Export
Please send Documents to kumarbobby143@gmail.com if you attended any Interview
So,I can upload it in this blog , it will be useful to us and others
Thank Yoy
0 comments:
Post a Comment