- 1
- 2
- 3
- …
- 5
- Next Page »
A Learning Portal from Recruitment India
Which of the following is a collection of one or more replicated objects (typically tables) that are administrated together.
Replication group
Replica
Replication
Replica group
Answer with explanation
Answer: Option AExplanation
Workspace
A _____________ is a set of tables physically stored together as one table that shares a common column.
Cluster
Datafiles
Object
Index
Answer with explanation
Answer: Option AExplanation
Workspace
When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?
Undo Data
Undone Data
Redo Data
Archive Data
Answer with explanation
Answer: Option AExplanation
The correct answer is Before the transaction happen the Oracle kept the files in Undo Data to overcome form any failure.
Workspace
Which is the smallest unit of storage in an Oracle database?
Data File
Extent
Data Block
Segment
Answer with explanation
Answer: Option CExplanation
Oracle data blocks are the smallest units of storage that Oracle can use or allocate. See Also: Your Oracle operating system-specific documentation for more information about data block sizes.
Workspace
Which clause is used to remove the duplicate records from the result set?
Distinct
Like
Group by
Where
Answer with explanation
Answer: Option AExplanation
Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with the SELECT statement.
Workspace