Oracle 1Z0-909 Actual Free Exam Questions & Community Discussion
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 ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?
Correct Answer: B
Vote an answer
Examine these statements which execute successfully:
The statements executed without exception. Which two are true?
The statements executed without exception. Which two are true?
Correct Answer: B,C
Vote an answer
A server hosts MySQL Server and Apache Webserver supporting a PHP/PDO based application.
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?
The application must be migrated from PHP to their Java application server on another host. The MySQL instance remains on the original host.
Examine the PDO connection string used in the existing application:
Mysql:host-localhost;dbname=sales;unix_socket=/var/run/mysql.sock
Which two prevent Java from using the Unix socket?
Correct Answer: C,E
Vote an answer
Examine this statement which has executed successfully:
Correct Answer: C
Vote an answer
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?
PHP Fatal error: Uncaught Error: call to underined function mysqli_connect () in Test.php:2 Which action will fix this error?
Correct Answer: D
Vote an answer
Examine the contents of these tables:
Now examine the expected results for a user with privileges to access the table:
Which query returns the expected results?
A)
B)
C)
D)
Now examine the expected results for a user with privileges to access the table:
Which query returns the expected results?
A)
B)
C)
D)
Correct Answer: A
Vote an answer
0
0
0
10