Create Next App

Exam contains 143 questions

Page 9 of 24

Question 49 🔥

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

Which database solution meets these requirements?

A. GRANT ALL PRIVILEGES ON ‘world’.‘city’ TO ‘tom’@’%’;GRANT SELECT (‘code’) ON ‘world’.‘country’ TO ‘tom’@’%’;

Highly voted

B. GRANT UPDATE ON ‘world’.* TO ‘tom’@’%’;GRANT ALL PRIVILEGES ON ‘world’.‘country’ TO ‘tom’@’%’;

Highly voted

C. GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’;GRANT SELECT ON ‘world’.* TO ‘tom’@’%’;

Highly voted

D. GRANT UPDATE ON ‘world’.‘city’ TO ‘tom’@’%’;GRANT SELECT ON ‘world’.‘country’ TO ‘tom’@’%’;

Highly voted

Discussion of the question

Question 50 🔥

Examine these commands and output:Which connection ID is holding the metadata lock?

Which database solution meets these requirements?

Discussion of the question

Question 51 🔥

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

Which database solution meets these requirements?

A. They are pushed from the master to the slave.

Highly voted

B. They contain events that describe database changes on the master.

Highly voted

C. They contain events that describe all queries run on the master.

Highly voted

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

Highly voted

E. They are pulled from the master to the slave.

Highly voted

Discussion of the question

Question 52 🔥

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

Which database solution meets these requirements?

A. SELECT user,passwd FROM members -WHERE user = ‘?’;INSERT INTO members(‘user’,’passwd’) VALUES (‘[email protected]’,‘secret’);--‘;

Highly voted

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

Highly voted

C. SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;

Highly voted

D. SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;

Highly voted

E. SELECT email,passwd FROM membersWHERE email = ‘INSERT INTO members(‘email’,’passwd’) VALUES (‘[email protected]’, ‘secret’);--‘;

Highly voted

F. SELECT user, phone FROM customers WHERE name = ‘\; DROP TABLE users; --‘;

Highly voted

Discussion of the question

Question 53 🔥

You execute this command:shell> mysqlpump --exclude-databases=% --usersWhich statement is true?

Which database solution meets these requirements?

A. It creates a logical backup of all MySQL user accounts.

Highly voted

B. It creates a logical backup of all metadata, but contains no table data.

Highly voted

C. It returns an error because the mysqldump command should have been used.

Highly voted

D. It creates a logical backup of only the users database.

Highly voted

Discussion of the question

Question 54 🔥

Examine this statement, which executes successfully:You want to improve the performance of this query:Which change enables the query to succeed while accessing fewer rows?

Which database solution meets these requirements?

A. ALTER TABLE world.city ADD SPATIAL INDEX (Name);

Highly voted

B. ALTER TABLE world.city ADD SPATIAL INDEX (Population);

Highly voted

C. ALTER TABLE world.city ADD INDEX (Population);

Highly voted

D. ALTER TABLE world.city ADD INDEX (Name);

Highly voted

E. ALTER TABLE world.city ADD FULLTEXT INDEX (Name);

Highly voted

F. ALTER TABLE world.city ADD FULLTEXT INDEX (Population);

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

oracle 1Z0_908

Exam contains 143 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us