1Z0-909 Exam Questions
56 real 1Z0-909 exam questions with expert-verified answers and explanations. Page 1 of 2.
- Question #1JSON
You must enforce data integrity for data Inserted in a JSON column. Which statement successfully creates a constraint in a 3SON column?
JSON constraintsCHECK constraintsdata integrityconstraint syntax - Question #2Performance
Examine these my.cnf settings: Examine this entry from /data/slow.log Which option is also set in my.cnf?
MySQL slow query logmy.cnf configurationPerformance monitoringLog analysis - Question #3Security
Your program which uses a MySQL connector receives this error: Client does not support authentication protocol request by server The account running the program uses caching_sha2_p...
MySQL authentication protocolscaching_sha2_passwordConnector compatibilityClient-server authentication - Question #4Performance
Examine the output: Which explain command will obtain the output?
EXPLAIN commandsExecution plansOutput formatsPerformance analysis - Question #5Application Development
Examine the Test.php script which is numbered for clarity, and its output: PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action...
PHP extensionsmysqli extensiondatabase connectivityPHP configuration - Question #6Performance
How does InnoDB choose deadlock victims in MySQL?
InnoDBDeadlock ResolutionTransaction ManagementConcurrency - Question #7SQL Fundamentals
Examine these statements which execute successfully: The statements executed without exception. Which two are true?
Transaction ControlCOMMIT/ROLLBACKSavepointsINSERT DML - Question #8JSON
The collection col contains all episodes for all seasons for a TV show. Examine this document which has an example of the details for each episode: Which query returns all expisode...
JSON path notationJSON queriesOracle SQLWHERE clause filtering - Question #10Triggers and Events
Examine this event's metadata: Now examine this command: DROP USER 'userl'e'localhost'; Which effect will the command have on the event?
EventsUser ManagementStored ProgramsObject Dependencies - Question #11Application Development
You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?
mysqlibuffered queriesresult set handlingperformance - Question #12Advanced SQL
Examine these statements issued from Session 1 which execute successfully: Now, examine this statement issued from Session 2: What is the outcome of the update statement in Session...
transactionslockingdeadlockconcurrency control - Question #13Performance
Examine these statements which execute successfully: Which two changes will improve this query performance?
index creationquery optimizationindex typessyntax validation - Question #14Performance
Which two are true about indexes?
indexesperformancequery optimizationstorage - Question #16GIS
Examine this statement and output: CREATE TABLE geom (g GEOMETRY NOT NOLL, SPATIAL INDEX(g) ); Query OK, 0 rows affected, 1 warning (0.01 sec) An attempt is made to add an SRID att...
SPATIAL INDEX constraintsALTER TABLE GEOMETRYSRID modificationSchema change restrictions - Question #17JSON
Examine this statement and output: You execute this statement: SELECT JSON_SEARCH(product,'one','IT') FROM fshop ; What is the output?
JSON_SEARCHJSON pathsJSONPath notationJSON return types - Question #18JSON
Examine this statement which executes successfully: The table is populated with a range of values including jobs for Robert, John, and Katie. Now, examine this statement and output...
virtual columnsJSON datatypedata type constraintsquery execution - Question #19Advanced SQL
Examine this statement which executes successfully: SET @ir := 2; Which query updates the value of @r to 0?
string matching operatorsregular expressionsLIKE vs RLIKEpattern matching - Question #20SQL Fundamentals
Your session has sqi_mode set to default. Examine this statement which executes successfully: Now examine this statement: Which two changes are required to the insert statement so...
INSERT statementsNULL handlingDate functionsString literals - Question #21Stored Programs
Examine this statement: DECLARE not_found CONDITION FOR SQLSTATE '02000'; In which two statements can not found be used?
DECLARE CONDITIONStored ProceduresException HandlingSQLSTATE - Question #22SQL Fundamentals
Examine the statement which executes successfully: SET sql_mode=' NO_ENGINE_SUBSTITTJTION' ; You try to create a table with a storage engine that is not available. What will happen...
SQL modesstorage enginesCREATE TABLEerror handling - Question #24Triggers and Events
Examine these commands which execute successfully: mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2)); mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income FOR EACH...
trigger activationBEFORE INSERTevent timingDML events - Question #25SQL Fundamentals
Examine these commands and output: Which is true about the execution of the insert statement?
viewsINSERT statementsDML operationsbase tables - Question #26Performance
Examine the appointments table definition which contains one million rows: Now, examine this statement which executes successfully: Which statement will improve query performance?
Composite Index DesignQuery OptimizationIndex SelectivityPerformance Tuning - Question #27
Examine these statements which execute successfully: Now, examine this query: What is the result?
- Question #28Application Development
What is an advantage of using mysqli in PHP programs rather than using PHP Data Objects (PDO)?
mysqliPDODatabase APIsPHP database access - Question #29Application Development
Examine these statements issued from Session 1 which execute successfully: Now, examine these statements issued from Session 2 which execute successfully: Session 2> BEGIN; UPDATE...
Transaction controlSession lockingBlocking behaviorMulti-session coordination - Question #30Application Development
Which two are true about MySQL connectors?
MySQL ConnectorsConnector ArchitectureClient-Server InstallationConnector Types - Question #31SQL Fundamentals
Which change will prevent negative ages to be inserted into the people table?
CHECK constraintsData validationALTER TABLEConstraints - Question #32Advanced SQL
Examine these statements: SET collation_connection=utf8mb4_0900_as_cs; SELECT STRCMPCAlice', UCASE ('Alice* )) ; What is displayed?
String comparisonCollation settingsCase sensitivityString functions - Question #33SQL Fundamentals
Examine these commands and output: Which is true?
VIEW dependenciesDROP TABLEObject relationshipsDDL constraints - Question #34SQL Fundamentals
Which select statement returns true?
NULL handlingcomparison operatorsNULL-safe equalNULL semantics - Question #35SQL Fundamentals
Examine the structure of the emp table: Examine the structure of the emp_vu1 view based on the emp table: Now, examine this statement: mysq1> INSERT INTO emp_vul VALUES ('Alice',20...
ViewsUpdatable ViewsINSERT operationsDML on Views - Question #36Performance
Examine this statement which has executed successfully:
LIKE/RLIKE operatorsPattern matchingQuery optimizationIndex strategy - Question #37SQL Fundamentals
Which two differences exist between the timestamp and date time data types?
data typestimestampstoragetime zone - Question #38JSON
Which two are true about MySQL Document Store?
MySQL Document StoreSchema-less storageJSON documentsNoSQL - Question #39SQL Fundamentals
Examine this statement and output: Now, examine these desired output values: Which statement updates the table data as require
UPDATE statementsROUND functionnumeric functionsdata modification - Question #40Stored Programs
Examine this statement:
DEFINER clauseStored proceduresPrivilege contextSecurity - Question #42JSON
Examine this statement which executes successfully: CREATE TABLE 'fshop' ('product' JSON DEFAULT NULL ) ENGINE=InnoDB; Now, examine a json value contained in the table: {"name" : "...
JSON path expressionsGenerated columnsJSON indexingMySQL JSON functions - Question #43Performance
Examine this statement and output: Which is true?
ViewsTEMPTABLE algorithmIndexingQuery optimization - Question #44Stored Programs
Which statement is true about the show errors command?
SHOW ERRORS commandPL/SQL diagnosticsSession scopeError messages - Question #45Application Development
Examine these lines of Python code: You must add a line of code to complete the code to return data to the variable d. Which line will do this?
Python DB-APIparameterized queriescursor fetchSQL injection prevention - Question #46Application Development
Examine the content of the employee table: Now examine this PHP script: Finally examine this desired output:
PDO configurationFetch modesResult handlingDatabase options - Question #47SQL Fundamentals
Examine this bar graph based on columns from the players table: Which two statements would generate this bar graph?
String functionsREPEAT/RPADSELECT queriesData formatting - Question #48Advanced SQL
Examine these commands which execute successfully in the sequence shown in Sessions S1 and S2: Now, examine this statement that execute successfully in s1: S1> SELECT * FROM emp; W...
Transaction IsolationUncommitted ChangesSession VisibilityACID Properties - Question #49SQL Fundamentals
Which two statements are true about AUTO_INCREMENT?
AUTO_INCREMENTTransaction RollbackColumn ConstraintsIndexing - Question #52SQL Fundamentals
You must write a statement that combines the first_name and last_name columns from the employees table as "last_name, first_name." Which two statements will do this?
string concatenationCONCAT functionCONCAT_WS functionSQL functions - Question #53Performance
Examine this statement that execute successfully in an interactive session: The user running this session now goes to lunch for an hour. Now, examine these statements executed inde...
Session locksTransaction blockingLock typesExecution behavior - Question #54JSON
Examine these MySQL Shell statements: What is the true about the attempts to add document to the collection?
MySQL ShellDocument CollectionsSchema FlexibilityJSON Documents - Question #55JSON
Examine this table definition: The table must always remain a valid document store collection. What restriction does this impose on any added column?
JSON document storagegenerated columnscollection constraintsdocument validation - Question #56Security
Examine this statement and output: What causes the error?
LOCAL_INFILEfile permissionsserver process privilegesprivilege hierarchy