Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Oracle
  5. 1Z0-920

Free Oracle 1Z0-920 Exam Questions (page: 4)

Page 3 of 18
PDF with 70 Questions

Which statement would you use to remove the population column from the city table?

  1. ALTER TABLE city DROP population;
  2. DELETE population FROM city;
  3. ALTER TABLE city DELETE population;
  4. ALTER TABLE city LESS population;
  5. DROP population FROM city;

Answer(s): A



You just installed MySQL by Using a Package Manager on Linux.
Where are the default InnoDB redo log files stored?

  1. /usr/mysql
  2. /var/lib/mysql
  3. /var/lib/mysql/innodb
  4. /usr/bin/logs
  5. /usr/redo
  6. /etc/my.cnf

Answer(s): E

Explanation:

https://dev.mysql.com/doc/refman/8.0/en/innodb-redo-log.html



You want to create an encrypted table. So, you enter this command:
CREATE TABLE 'test_encryption2% (
'id' int(10) unsigned NOT NULL AUTO_INCREMENT,
'server_name' varchar(15) NOT NULL,
PRIMARY KEY ('id') ) ENGINE=MYISAM AUTO_INCREMENT=l DEFAULT CHARSET=latin1 ENCRYPTION = 'Y1;
You receive the following error:
ERROR 1031 (HY000): Table storage engine for `test_encryption2' doesn't have this option Which statement correctly explains the reason for this error?

  1. You cannot use the AUTO_INCREMENT option to create an encrypted table. This is what is causing the error.
  2. The term "server_name" is a reserved MySQL term. You cannot use it for the new table. This is what is causing the error.
  3. The encryption feature only works with InnoDB tables. You are creating a MylSAM table, and it is causing the error.
  4. The test_encryption2 already exist. You are not using the correct option to recreate it and it is causing the error.

Answer(s): C



Which four authentication protocols are allowed when using MySQL Enterprise Authentication?

  1. Native Windows services
  2. authentication via Pluggable Authentication Modules (PAMs)
  3. Simple Authentication and Security Layer
  4. SECURID authentication and authorization identity
  5. authentication using SHA-256 password hashing
  6. connections through the local host via the UNIX socket file

Answer(s): A,B,E,F

Explanation:

https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html



Viewing page 4 of 18



Post your Comments and Discuss Oracle 1Z0-920 exam prep with other Community members:

1Z0-920 Exam Discussions & Posts