Which statement adds a column with the largest integer data type?
A. ALTER TABLE SCIENTIFIC ADD scientific_value BIGINT;
B. ALTER TABLE SCIENTIFIC ADD scientific_value INTEGER;
C. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(15,10);
D. ALTER TABLE SCIENTIFIC ADD scientific_value DECIMAL(10,10);
You have been using mysqldump for logical backups of your MySQL databases. Your MySQL database size has been growing. Which two options can reduce the backup size and speed up the backup time?
A. Use mysqldump with - -incremental together with the - -compress option to back up incrementally based on previous full backup and compress the incremental backup files.
B. Use mysqldump with the - -changesonly option.
C. Use MySQL Enterprise Backup with the - -size=compress to compress the backup file.
D. Use MySQL Enterprise Backup with the - - incremental policy to back up incrementally based on previous full backup.
E. Use MySQL Enterprise Backup with the - -compress option to compress the backup files and use - compress-level to select the level of compression.
Which statement would you use to remove the population column from the city table?
A. ALTER TABLE city DROP population;
B. DELETE population FROM city;
C. ALTER TABLE city DELETE population;
D. ALTER TABLE city LESS population;
E. DROP population FROM city;
Your newly-created Oracle Cloud Infrastructure instance is not available for login in. Which is a valid reason for this issue?
A. You forgot to enable port 3306.
B. The opc user can be used to access MySQL only with the created SSH-Key.
C. Only root is allowed to access from non-localhost.
D. You forgot to create the correct SSL/TLC certificate during the setup process.
E. The OCI instance is still in the "creation" process.
Which statement will display the status of the partitioning plug-in?
A. SHOW STATUS PLUGINS WHERE Name= `PARTITIONING';
B. SHOW PLUGINS WHERE Name= `partition';
C. SELECT PLUGIN_NAME, PLUGIN_VERSION, PLUGIN_STATUS FROM INFOMRATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME= `partition';
D. USE SYS SCHEMA; SHOW PLUGINS STATUS;
What are Security Lists in Oracle Cloud Infrastructure?
A. They allow administrators access to applications in the cloud and external servers.
B. They are user-role designations that assign rights to certain internal users and external users.
C. They are essentially firewall rules that help control traffic between OCI instances.
D. Security lists are data encryption levels that control who can see the data.
E. They contain rules established by HIPAA for securing end-user data.
Which is true about inserting an additional line in a single document stored in MySQL document store?
A. You specify the new element's position in the JSON_ARRAY_INSERT statement.
B. Any new lines can only be inserted at the end of the document.
C. You cannot insert a single line, you have to replace the entire document with a new document.
D. The path specified must be an array position past the end of an array using the JSON_POSITION statement.
You want to change the default behavior of MySQL Enterprise Monitor (MEM). New instances detected by
a MEM agent should automatically monitor discovered instances.
How can you change the Advisor Setting?
A. Go to the configuration section (Users) and create a new user according to the existing users of your new MySQL instances.
B. Go to the configuration section (Advisors) and edit the default settings of the MySQL Process Discovery according to the existing users of your new MySQL instances.
C. Go to the configuration section (Advisors) and create a new advisor rule for new MySQL instances based on the MySQL Advisor Wizard.
D. Go to the configuration section (MEM) and configure the default login credentials.
What are two ways in which customers can receive notifications such as outages, configuration changes, database emergencies, and other information on their Database as a Service instances?
A. Email
B. Browser pop-ups
C. Direct support call from an Oracle representative
D. SMS-notification tab on the dashboard
E. Application-to-application messaging
What SQL keyword must be specified when creating a foreign key constraint?
A. a TRIGGER on the child table for cascading delete statements
B. a REFERENCES in the child table to the parent table
C. unique PRIMARY key values for both child and parent tables
D. the SET_FOREGIN variable in the my .cnf file
E. an index on the foreign key
