Oracle-MySQL 5 Developer Certified Professional Exam, Part II

Question - 27 Maximum mark : - 50

Home
All Exams
Oracle-MySQL 5 Developer Certified Professional Exam, Part II Online Mock Tests
Oracle-MySQL 5 Developer Certified Professional Exam, Part II

Given one inner join query and one outer join query that both produce the same results, which of the following statements is true?

Inner joins are usually faster, use less memory and should be used instead of outer joins. ✘ Outer joins are usually faster, use less memory and should be used instead of inner joins. ✘ Inner and outer joins are running at the same speed and take the same amount of memory. ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

All but one of the following queries produces the same results. Which one produces a different result or produces an error?

SELECT * FROM class JOIN student ON class.class_id=student.class_id ✘ SELECT * FROM class INNER JOIN student ON class.class_id=student.class_id ✘ SELECT * FROM class LEFT JOIN student ON class.class_id=student.class_id D SELECT * FROM classJOIN student ON class.class id=student.class id 387: C ✘ SELECT * FROM class INNER JOIN student ON class.class_id=student.class_id WHE RE NOT ISNULL(student.class_idJ ✔ SELECT * FROM class LEFT JOIN student ON class.class_id=student.class_id WHERE NOT ISNULL(student.class id) ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Note: The countrycode field in the city table references the Code field in the country table. Which of the following delete statements all of the cities in the country "Spain" from the city table?

DELETE City FROM Country JOIN City ON Country.Code=City.CountryCode WHERE Country.Name = 'Spain' DELETE FROM CityUSING Country, City WHERE Countrv.Code=Citv.CountrvCode tun i> <~ DELETE FROM City USING Country JOIN CityON Country.Code=City.CountryCode WHERE Country.Name='Spain' DELETE FROM City USING CountryWHERE Country.Code=City.CountryCode AND Country.Name='Spain'

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Consider the following query: SELECT Code FROM Country WHERE Name = 'United States' Which of the following is the correct way to create a prepared statement using this statement in the mysql client?

mysql> PREPARE CountryCode AS 'SELECT Code FROM Country WHERE Name = ? '; ✘ mysql> PREPARE CountryCode FROM 'SELECT Code FROM Country WHERE Name = ? '; ✘ mysql> PREPARE STATEMENT CountryCode AS 'SELECT Code FROM Country WHERE Name = ? '; ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following are true with regards to prepared statements? Select all that apply. When executing a prepared statement

exactly one value must be given for each parameter. ✘ any number of parameters may be assigned a value; undefined parameters are assigned a default value. ✘ undefined parameters are assigned a value of NULL. ✘ undefined parameters are assigned an empty string. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Which of the following statements best describe why prepared statements are useful:

They often reduce the amount of code you have to write. ✘ They often improve transaction support. ✘ They often improve performance when using with stored procedures. ✘ They often reduce parsing time when performing several similar queries ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

You have an external application that requires an input file with comma-separated values. How can you produce such a file containing the contents of the countryLanguage table using MySQL's select

SELECT * FROM CountryLanguage INTO OUTFILE '/tmp/CountryLanguage.csv' WITH SEPARATOR ',' ✘ SELECT * FROM CountryLanguageINTO OUTFILE '/tmp/CountryLanguage.csv' FIELDS TERMINATED BY ',' ✘ SELECT * FROM CountryLanguageINTO OUTFILE '/tmp/CountryLanguage.csv' AS CSV ✘ There is no support for exporting comma-separated data. ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Suppose you have a comma-delimited file named city.csvthat you need to load into a table called city. The file delimiter is a comma, text is enclosed with double-quotes, and each line is ends with a newline character. Given this situation, what would the correct load data infile statement look like?

LOAD DATA INFILE 'city.csv' INTO TABLE City FIELDS TERMINATED BY ', ' OPTIONALLY ENCLOSED BY "" LINES TERMINATED BY '\n' ✘ LOAD DATA INFILE 'city.csv' INTO TABLE CityCOLUMNS TERMINATED BY ', ' OPTIONALLY ENCLOSED BY "" LINES TERMINATED BY '\n' ✘ LOAD DATA INFILE 'city.csv' INTO TABLE CityFIELDS TERMINATED BY ',' TEXT ENCLOSED BY "" LINES TERMINATED BY '\n' D LOAD DATA INFILE 'city.csv' INTO TABLE City COLUMNS TERMINATED BY ',' TEXT ENCLOSED BY '"' LINES TERMINATED BY '\n' ✘

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

The table Country contains the fields Code, defined as the PRIMARY KEY, and Name, which is covered by a UNIQUE index. Which of the following queries demonstrates the correct way to compare a tuple to a row subquery:

SELECT Name FROM City c WHERE (c.id, c.CountryCode) = (SELECT CONCAT(Capital, Code) FROM Country WHERE Name = 'United States'} ✘ SELECT NameFROM City c WHERE (c.id, c.CountryCode) = (SELECT Capital FROM Country, SELECT Code FROM Country) ✘ SELECT NameFROM City c WHERE (c.id, c.CountryCode) = (SELECT Capital, Code FROM Country) ✘ SELECT NameFROM City cWHERE (c.id, c.CountryCode) = (SELECT Capital, Code FROM CountryWHERE Name = 'United States') ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

10.

Which of the following statements is true?

"IN cannot be used with the <, > or = operators for correlated subqueries." ✘ "IN cannot be used with correlated subqueries." ✘ "IN can only be used with the = operator for correlated subqueries." ✘ "IN can only be used with the < and > operators for scalar subqueries." ✔

Answer & Solution Discuss in Board Save for Later

Answer & Solution

Answer: Option B

Solution:

It provides fallback for IE8.

Prev Next

Congratulations

you have successfully completed the test

Back to Question View Result

Detail Form

We will send your result on your email id and phone no. please fill detail

Name

Email ID Note: Report will be send to the above Email ID

Phone No

Oracle-MySQL 5 Developer Certified Professional Exam, Part II

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner