Oracle Database SQL (1Z0-071) [Latest]
Certification Exam Questions. Real Exam Quizs &
Correct Ans 2024-2025. Graded A
01. Which three statements are true regarding the data types?
a) Only one LONG column can be used per table.
b) ATIMESTAMP data type column stores only time values with fractional
seconds.
c) The BLOB data type column is used to store binary data in an
operating system file.
d) The minimum column width that can be specified for a varchar2 data
type column is one.
e) The value for a CHAR data type column is blank-padded to the
maximum defined column width. – ANS
a) Only one LONG column can be used per table.
d) The minimum column width that can be specified for a varchar2 data
type column is one.
e) The value for a CHAR data type column is blank-padded to the
maximum defined column width.
PG 1
, 02. You need to determine the day of the week for a particular date in
the future. Which function will reveal this information?
a) TO_CHAR
b) DAY_OF_WEEK
c) TO_DATE
d) None of the above – ANS a) TO_CHAR
03. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS
tables issues the following GRANT command: GRANT ALL ON orders,
order_items TO PUBLIC; What correction needs to be done to the above
statement?
a) PUBLIC should be replaced with specific usernames.
b) ALL should be replaced with a list of specific privileges.
c) WITH GRANT OPTION should be added to the statement.
d) Separate GRANT statements are required for ORDERS and
ORDER_ITEMS tables. – ANS d) Separate GRANT statements are required
for ORDERS and ORDER_ITEMS tables.
04. Which statement is true regarding external tables?
a) The default REJECT LIMIT for external tables is UNLIMITED.
PG 2
Certification Exam Questions. Real Exam Quizs &
Correct Ans 2024-2025. Graded A
01. Which three statements are true regarding the data types?
a) Only one LONG column can be used per table.
b) ATIMESTAMP data type column stores only time values with fractional
seconds.
c) The BLOB data type column is used to store binary data in an
operating system file.
d) The minimum column width that can be specified for a varchar2 data
type column is one.
e) The value for a CHAR data type column is blank-padded to the
maximum defined column width. – ANS
a) Only one LONG column can be used per table.
d) The minimum column width that can be specified for a varchar2 data
type column is one.
e) The value for a CHAR data type column is blank-padded to the
maximum defined column width.
PG 1
, 02. You need to determine the day of the week for a particular date in
the future. Which function will reveal this information?
a) TO_CHAR
b) DAY_OF_WEEK
c) TO_DATE
d) None of the above – ANS a) TO_CHAR
03. The user SCOTT who is the owner of ORDERS and ORDER_ITEMS
tables issues the following GRANT command: GRANT ALL ON orders,
order_items TO PUBLIC; What correction needs to be done to the above
statement?
a) PUBLIC should be replaced with specific usernames.
b) ALL should be replaced with a list of specific privileges.
c) WITH GRANT OPTION should be added to the statement.
d) Separate GRANT statements are required for ORDERS and
ORDER_ITEMS tables. – ANS d) Separate GRANT statements are required
for ORDERS and ORDER_ITEMS tables.
04. Which statement is true regarding external tables?
a) The default REJECT LIMIT for external tables is UNLIMITED.
PG 2
