Oracle 1Z0-909 問題集

質問 1：
You must reclaim memory used by a prepared statement named prep. Which two achieve this?
A. DROP PREPARE prep;
B. DEALLOCATE PREPARE prep?
C. DROP PROCEDURE prep;
D. SET @a = ''; EXECUTE prep USING @a;
E. PREPARE prep FROM '';
F. SET @prep = NULL;
正解：C,F

質問 2：
Examine this statement which executes successfully:
SET @ir := 2;
Which query updates the value of @r to 0?
A. SELECT 'Car' REGEXP('Ca?') >= 0 INTO @r;
B. SELECT 'Car' LIKE 'Ca?' INTO @r;
C. SELECT STRCMP('Car'/Ca?') >= 0 INTO @r;
D. SELECT 'Car' RLIKE 'Ca?' INTO @r;
正解：D

質問 3：
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?
A. The trigger activates after any row in the table has been updated.
B. Execution of an insert statement causes the trigger to activate.
C. The trigger activates after any row has been inserted into the table.
D. The trigger body set causes trigger activation.
正解：B

質問 4：
Examine this table definition:

The table must always remain a valid document store collection. What restriction does this impose on any added column?
A. The column must be a generated column referencing only an existing attribute of doc.
B. The column must have a default value.
C. The column must be a generated column referencing any attribute of doc.
D. The column must be indexed.
E. The column must be used in a unique constraint.
正解：C

質問 5：
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. Replace line 2 With: Slink = mysql_xdevapi\getSession
("mysqlx://username:password@localhost:3306","schema");
D. Install the PHP executable in the path used by the MySQL installation.
正解：A

質問 6：
Examine these statements which execute successfully:

Which two changes will improve this query performance?
A. CREATE INDEX 1X6 ON users (user_name);
B. CREATE INDEX 1X7 ON users (user_name) USING HASH;
C. CREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH
D. CREATE INDEX IX1 ON locations (loc_shareci) ;
E. CREATE INDEX 1X3 ON locations <loc_site_id) ;
F. CREATE INDEX 1X5 ON users (loc_id);
G. CREATE INDEX 1X4 ON Locations (site_id, loc_shared);
正解：A,B