Q58 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace

Posted on by Tran Anh

Q58 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

Segment creation is not deferred.

You execute this command:

CREATE USER sales
IDENTIFIED BY sales_123
DEFAULT TABLESPACE sales_q1
TEMPORARY TABLESPACE temp
QUOTA 5M ON users;

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

  • (A). The sales user must have a quota on the TEMP tablespace
  • (B). The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
  • (C). The sales user must have been granted the CREATE SESSION privilege
  • (D). The sales user must have their quota on the users tablespace removed
  • (E). The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
  • (F). The sales user must have been granted the CREATE TABLE privilege
Xem thêm:

Bài viết cùng chủ đề:

0 0 đánh giá
Đánh giá bài viết
Theo dõi
Thông báo của
guest
0 Góp ý
Phản hồi nội tuyến
Xem tất cả bình luận