Question No. 1

Which two queries are examples of successful SQL injection attacks? (Choose two.)

ASELECT user,passwd FROM members
WHERE user = '?';INSERT INTO members('user','passwd') VALUES
('bob@example.com','secret');--';

BSELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);

CSELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

DSELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

ESELECT email,passwd FROM members
WHERE email = 'INSERT INTO members('email','passwd') VALUES ('bob@example.com',
'secret');--';

FSELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';

Show Answer

Correct Answer: D, E

Question No. 2

Which two are true about binary logs used in asynchronous replication? (Choose two.)

AThey are pushed from the master to the slave.

BThey contain events that describe database changes on the master.

CThey contain events that describe all queries run on the master.

DThey contain events that describe only administrative commands run on the master.

EThey are pulled from the master to the slave.

Show Answer

Correct Answer: A, B

Question No. 3

Which four connection methods can MySQL clients specify with the --protocol option when connecting to a MySQL server? (Choose four.)

ATCP

BSOCKET

CPIPE

DDIRECT

EIPv6

FFILE

GIPv4

HMEMORY

Show Answer

Correct Answer: A, B, C, H

Question No. 4

You wish to protect your MySQL database against SQL injection attacks.

Which method would fail to do this?

Ainstalling and configuring the Connection Control plugin

Bavoiding concatenation of SQL statements and user-supplied values in an application

Cusing stored procedures for any database access

Dusing PREPARED STATEMENTS

Show Answer

Correct Answer: C

Question No. 5

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

AGRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';

BGRANT UPDATE ON 'world'.* TO 'tom'@'%';
GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

CGRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';

DGRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO 'tom'@'%';

Show Answer

Correct Answer: D

Free Oracle 1Z0-908 Exam Actual Questions

The questions for 1Z0-908 were last updated On Dec 17, 2024