【2019】OCP考試062題庫近期考試原題解析-第56題
最新學訊:近期OCP認證正在報名中,因考試人員較多請盡快報名獲取最近考試時間,報名費用請聯系在線老師,甲骨文官方認證,報名從速!
我要咨詢2018年的時候,OCP 11g考試題庫大更新,052 053出現了很多新題,
2019年,11g即將停考的前期,Oracle又出現了一次大變動,12c出現了很多新題,比如062 063題庫大更新
OCP解析公開課時間:【每周五晚8點】
OCP解析公開課地址:http://ke.qq.com/course/326223
OCP解析群資料分享:1015267481 驗證:ocp
-------------------------------------------------------
56題、choose two
In your database, USERS is the default permanent tablespace.
Examine the commands and their outcome:
SQL> CREATE USER user02 identified by us123 QUOTA 10M ON users;
User created.
SQL> GRANT create session, sysdba TO user02;
Grant succeeded.
You plan to execute the commands:
SQL> CONN user02/us123 AS SYSDBA
SQL> CREATE TABLE mytab (id number, lname varchar2(20));
Which two statements are true?
A) The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
B) The MYTAB table is owned by the SYS user.
C) The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
D) The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
E) The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
Answer:BE
(解析:當以sysdba權限登錄時,用戶名就是sys,跟user02沒有關系了,所有創建的表都是屬于sys,存放在system表空間。)