exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam

Exam 1z0-062 topic 2 question 27 discussion

Actual exam question from Oracle's 1z0-062
Question #: 27
Topic #: 2
[All 1z0-062 Questions]

Which two are true about database table rows? (Choose two.)

  • A. They always have a row header.
  • B. They are always stored in a single database block.
  • C. They are chained across multiple blocks only when the table has more than 255 columns.
  • D. They have a row header only when they are chained across multiple database blocks.
  • E. They can be stored in a single database block.
Show Suggested Answer Hide Answer
Suggested Answer: CE 🗳️
Reference -
https://blogs.sap.com/2013/02/17/oracle-unchain-database-and-sql-performance-by-design-row-chaining/

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Simon22
Highly Voted 4 years, 5 months ago
A E , C is incorrect as long row is also chained
upvoted 9 times
hggz
4 years, 5 months ago
I agree with AE
upvoted 3 times
...
...
mynameisladyviolette
Most Recent 2 years, 4 months ago
AE is correct A row is stored in a database block in the form of a row piece, Each row piece has a row header and column data
upvoted 1 times
...
dfabac
2 years, 8 months ago
Selected Answer: AE
Answer is AE
upvoted 1 times
...
bigswole
3 years, 4 months ago
A= "Oracle Database stores rows as variable-length records. A row is contained in one or more sections. Each section is called a row piece. Each row piece has a row header and column data." C would have been correct, if the key word ONLY was not used, as there are other factors which will cause row chaining. "Row chaining most often occurs with large rows. Examples include rows that contain a column of data type LONG or LONG RAW , or a row with a huge number of columns. Row chaining in these cases is unavoidable." -https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1061
upvoted 2 times
...
eskias
3 years, 4 months ago
C and E correct answers if the number of rows are more than 255 oracle starts to create other row and it chain rows for net time block read. row can be a single block if it has small data
upvoted 1 times
...
badguy001djh
3 years, 10 months ago
AE For A,https://docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT1046 key words: Row Format
upvoted 3 times
...
Modasser
4 years, 1 month ago
C&E is correct ref: https://blogs.sap.com/2013/02/17/oracle-unchain-database-and-sql-performance-by-design-row-chaining/
upvoted 1 times
...
aleks2004
4 years, 7 months ago
A,B is true
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago