Online Access Free 1Z0-909 Practice Test

Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?

• A.SELECT 'Car' LIKE 'Ca?' INTO @r;
• B.SELECT 'Car' RLIKE 'Ca?' INTO @r;
• C.SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;
• D.SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;

Which two are true about MySQL connectors?

• A.Connector/NET runs on the Windows platform only.
• B.Connector/Python is released in precompiled binary and source code.
• C.Connectors must be installed on both the client and server hosts.
• D.Connector/J is based on Connector/C.
• E.Connector/ODBC is available on Unix, Windows, and MacOS X.

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 will fix this error?

• A.Enable the mysqli extension in the php.ini file.
• B.Replace line 2 with Slink = mysql.connect {"localhost: 3306n, "username", "pas "schema") ;
• C.Install the PHP executable in the path used by the MySQL installation.
• D.Replace line 2 With: Slink = mysql_xdevapi\getSession
  ("mysqlx://username:password@localhost:3306","schema");

Which two differences exist between the timestamp and date time data types?

• A.timestamp stores the interval between two dates.
• B.timestamp has larger range of values.
• C.timestamp uses less storage space.
• D.timestamp stores more decimal points in seconds
• E.timestamp converts the value based on the session time zone.

You are using buffered queries with PHP mysqli in a browser-based web application. Which three are true?

• A.Buffered queries must be explicitly enabled using mysqliuseresult.
• B.Results are sent from the server to the browser for buffering.
• C.Additional queries on the same session are blocked until the result set is released.
• D.Buffered queries are enabled by default.
• E.Buffered queries should be used on large tables when the result size is unknown.
• F.Results are sent to the calling PHP process for buffering.
• G.Large results can have a negative impact on performance.