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.
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.
PG 1
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.
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.
PG 1
