Oracle Database SQL (1Z0-071): Online Practice test

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.

a) GRANT EXECUTE ON prod TO PUBLIC;

b) GRANT CREATE VIEW ON tablel TO used;

d) GRANT CREATE SESSION TO ALL;

a) The default REJECT LIMIT for external tables is UNLIMITED.

b) The data and metadata for an external table are stored outside the database.

c) ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external 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.