Which statement is true regarding undo tablespace?

Which statement is true regarding undo tablespace? Question: Which statement is true regarding undo tablespace? Options: Undo tablespace is a temporary tablespace. Only one undo tablespace can exist in a database. Undo tablespace can consist of only one data file that is reused in a cyclic fashion. Multiple undo tablespace can exist in a database … Read more

Which is true about the Database Configuration Assistant (DBCA)?

Which is true about the Database Configuration Assistant (DBCA)?Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm#insertedID5 Question: Which is true about the Database Configuration Assistant (DBCA)? Options: It can register a database with Cloud Control and configure Database Control for the same database. It can change the server mode from dedicated to shared and vice versa for an existing database. It … Read more

Which memory may be allocated for:

Identify the memory component from which memory may be allocated for:Session memory for the shared serverBuffers for I/O slavesOracle Database Recovery Manager (RMAN) backup and restore operations Question: Which memory may be allocated for: Options: Large Pool Redo Log Buffer Database Buffer Cache Program Global Area (PGA) Correct Answer The Correct Answer for this Question … Read more

Which statement is true regarding the DELETE command?

User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans;While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type=’SL’;Which statement is true regarding the DELETE command? Question: Which statement is true regarding the … Read more

Which method would you use to restrict enabling of such roles?

You want to create a role to meet these requirements:1.The role is to be protected from unauthorized usage.2.The password of the role is not to be embedded in the application source code or stored in a table.Which method would you use to restrict enabling of such roles? Question: Which method would you use to restrict … Read more

Which scenarios require DBA intervention to perform recovery?

Given below is a list of scenarios:1.A user terminates his session abnormally.2.The connection between the server and the client application terminates because of a network failure.3.A schema is accidentally dropped.4.The tablespace is accidentally dropped from the database.5.The hard disk gets corrupted and the data files in the disk are lost.6.The database instance abnormally shuts down … Read more

Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace?

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.) … Read more

Which of these requirements can be met while creating the database?

You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA). Some of the requirements set for your database creation task are:1.Configure the database to operate in shared server mode.2.Disable … Read more

Which two statements are true regarding transactions in an Oracle database?

Which two statements are true regarding transactions in an Oracle database? (Choose two.)SegmentsThe level of logical database storage above an extent is called a segment. A segment is a set of extents that are allocated for a certain logical structure. Different types of segments include:• Data segments: Each nonclustered. non-index-organized table has a data segment, … Read more