Oracle 1Z0-920 問題集

質問 1：
Which activity will take place if a table is created with both the compression and encryption options?
A. The compression is performed before tablespace data is encrypted.
B. The compression is performed, the ''data_at_rest_flag" is turned on and the tablespace data is encrypted.
C. The system generates an error because the COMPRESSION and ENCRYPTION options cannot be used together.
D. The tablespace data is encrypted first and then compression is performed.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which statement adds a column with the largest integer data type?
A. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;
B. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);
C. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);
正解：C

質問 3：
Consider this SQL statement which is using the innoDB storage engine and with global AUTOCOMMIT = 1:

What is the result after issuing the rollback command?
A. Only the t2 table is created.
B. Only the t1 table is created.
C. Both the tables, t1 and t2, are not created because there is an explicit ROLLBACK.
D. Both the tables, t1 and t2, are created.
正解：D

質問 4：
Which three statements describe MySQL Enterprise Backup?
A. MySQL Enterprise Backup provides the point-in-time recovery functionality.
B. MySQL Enterprise Backup can be used to send backups to Oracle Cloud Infrastructure Storage Service.
C. MySQL Enterprise Backup offers backup based on Oracle RMAN with optimized row locking.
D. MySQL Enterprise Backup can be used to import/export data from on-premises MySQL installations.
E. MySQL Enterprise Backup is an optimized backup based on mysqldump with optimized row locking.
正解：A,C,E

質問 5：
Which three prerequisites are needed for creating an Oracle Linux VM instance in the Oracle Cloud Infrastructure?
A. Object Storage
B. ssh key pair
C. subnet configured on a Virtual Cloud Network (VCN)
D. Custom Image
E. existing VCN
F. bare metal Oracle Linux shape
正解：A,D,F

質問 6：
When using an Oracle Cloud Infrastructure Compute Instance with MySQL Enterprise Edition installed, you have two choices for backup destinations. What are these two choices?
A. Cloud storage only
B. Flash-archive recovery area
C. Cloud tape library
D. Both Cloud storage and local storage
正解：A,D
解説: (Topexam メンバーにのみ表示されます)