Exambible 1Z0-051 exam is among the main requirements connected with Oracle Database: SQL Fundamentals I qualification. Completing Oracle Database: SQL Fundamentals I exam is straightforward. Exambible intended this particular exam research guideline in a way you dont must try to find alternative ebooks as well as aiding materials with regards to 1Z0-051. That evaluation guideline contains all you need to go the Oracle Database: SQL Fundamentals I exam. Exambible provides you with an in depth qualification examination method for make you Oracle qualified specialized. That qualification research guideline contains zero cost research guideline, small sample answers, pdf exam, braindumps as well as replies science lab which give you the expertise in genuine Oracle Database: SQL Fundamentals I qualification exam. That research kit also includes research information, 1Z0-051 pdf, 1Z0-051 acquire, 1Z0-051, 1Z0-051 exercise make sure 1Z0-051 review.

2016 Nov 1z0-051 oracle database 11g sql fundamentals i:

Q21. - (Topic 1) 

Evaluate the following query: 

What would be the outcome of the above query? 

A. It produces an error because flower braces have been used. 

B. It produces an error because the data types are not matching. 

C. It executes successfully and introduces an 's at the end of each promo_name in the output. 

D. It executes successfully and displays the literal" {'s start date was} " for each row in the output. 

Answer:

Explanation: 

So, how are words that contain single quotation marks dealt with? There are essentially 

two mechanisms available. The most popular of these is to add an additional single 

quotation mark next to each naturally occurring single quotation mark in the character 

string 

Oracle offers a neat way to deal with this type of character literal in the form of the 

alternative quote (q) operator. Notice that the problem is that Oracle chose the single quote 

characters as the special pair of symbols that enclose or wrap any other character literal. 

These character-enclosing symbols could have been anything other than single quotation 

marks. 

Bearing this in mind, consider the alternative quote (q) operator. The q operator enables 

you to choose from a set of possible pairs of wrapping symbols for character literals as 

alternatives to the single quote symbols. The options are any single-byte or multibyte 

character or the four brackets: (round brackets), {curly braces}, [squarebrackets], or <angle 

brackets>. Using the q operator, the character delimiter can effectively be changed from a 

single quotation mark to any other character 

The syntax of the alternative quote operator is as follows: 

q'delimiter'character literal which may include the single quotes delimiter' where delimiter 

can be any character or bracket. 

Alternative Quote (q) Operator 

Specify your own quotation mark delimiter. 

Select any delimiter. 

Increase readability and usability. 

SELECT department_name || q'[ Department's Manager Id: ]' 

|| manager_id 

AS "Department and Manager" 

FROM departments; 

Alternative Quote (q) Operator 

Many SQL statements use character literals in expressions or conditions. If the literal itself contains a single quotation mark, you can use the quote (q) operator and select your own quotation mark delimiter. You can choose any convenient delimiter, single-byte or multibyte, or any of the following character pairs: [ ], { }, ( ), or < >. In the example shown, the string contains a single quotation mark, which is normally interpreted as a delimiter of a character string. By using the q operator, however, brackets [] are used as the quotation mark delimiters. The string between the brackets delimiters is interpreted as a literal character string. 


Q22. - (Topic 2) 

Examine the structure of the CUSTOMERS table: 

CUSTNO is the PRIMARY KEY in the table. You want to find out if any customers' details have been entered more than once using different CUSTNO, by listing all the duplicate names. 

Which two methods can you use to get the required result? (Choose two.) 

A. self-join 

B. subquery 

C. full outer-join with self-join 

D. left outer-join with self-join 

E. right outer-join with self-join 

Answer: A,B 


Q23. - (Topic 2) 

In which two cases would you use an outer join? (Choose two.) 

A. The tables being joined have NOT NULL columns. 

B. The tables being joined have only matched data. 

C. The columns being joined have NULL values. 

D. The tables being joined have only unmatched data. 

E. The tables being joined have both matched and unmatched data. 

F. Only when the tables have a primary key/foreign key relationship. 

Answer: C,E 

Explanation: 

You use an outer join to also see rows that do not meet the join condition. 

Incorrect Answer: Ameet a join condition Bmeet a join condition Dmeet non join condition only Fdoes not take into consideration of primary key and foreign key relationship 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 4-17 


Q24. - (Topic 2) 

Which statement adds a constraint that ensures the CUSTOMER_NAME column of the CUSTOMERS table holds a value? 

A. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL; 

B. ALTER TABLE customers MODIFY CONSTRAINT cust_name_nn CHECK customer_name IS NOT NULL; 

C. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn NOT NULL; 

D. ALTER TABLE customers MODIFY customer_name CONSTRAINT cust_name_nn IS NOT NULL; 

E. ALTER TABLE customers MODIFY name CONSTRAINT cust_name_nn NOT NULL; 

F. ALTER TABLE customers ADD CONSTRAINT cust_name_nn CHECK customer_name NOT NULL; 

Answer:


Q25. - (Topic 2) 

The PRODUCTS table has these columns: 

PRODUCT_ID NUMBER(4) 

PRODUCT_NAME VARCHAR2(45) 

PRICE NUMBER(8,2) 

Evaluate this SQL statement: 

SELECT * 

FROM PRODUCTS 

ORDER BY price, product_name; 

What is true about the SQL statement? 

A. The results are not sorted. 

B. The results are sorted numerically. 

C. The results are sorted alphabetically. 

D. The results are sorted numerically and then alphabetically. 

Answer:

Explanation: 

the result is sort by price which is numeric and follow by product_name which is alphabetically. 

Incorrect Answer: Athe results are sorted Bthe results are sorted with alphabetically as well Cthe results are sorted with numerically as well 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-2 


Improve oracle database 11g sql fundamentals 1 1z0-051 videos:

Q26. - (Topic 1) 

View the Exhibit and examine the structure of the PROMOTIONS table. Evaluate the following SQL statement: 

The above query generates an error on execution. 

Which clause in the above SQL statement causes the error? 

A. WHERE 

B. SELECT 

C. GROUP BY 

D. ORDER BY 

Answer:


Q27. - (Topic 1) 

Which four are types of functions available in SQL? (Choose 4) 

A. string 

B. character 

C. integer 

D. calendar 

E. numeric 

F. translation 

G. date 

H. conversion 

Answer: B,E,G,H 

Explanation: Explanation: SQL have character, numeric, date, conversion function. 

Incorrect Answer: 

ASQL have character, numeric, date, conversion function. 

CSQL have character, numeric, date, conversion function. 

DSQL have character, numeric, date, conversion function. 

FSQL have character, numeric, date, conversion function. 

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 3-3 


Q28. - (Topic 1) 

View the Exhibit and examine the structure of the CUSTOMERS table. Exhibit: 

you issue the following SQL statement on the CUSTOMERS table to display the customers who are in the same country as customers with the last name 'king' and whose credit limit is less than the maximum credit limit in countries that have customers with the last name 'king'. 

Which statement is true regarding the outcome of the above query? 

A. It produces an error and the < operator should be replaced by < ANY to get the required output 

B. It produces an error and the IN operator should be replaced by = in the WHERE clause of the main query to get the required output 

C. It executes and shows the required result 

D. It produces an error and the < operator should be replaced by < ALL to get the required output 

Answer:


Q29. - (Topic 1) 

Exhibit contains the structure of PRODUCTS table: 

Evaluate the following query: 

What would be the outcome of executing the above SQL statement? 

A. It produces an error 

B. It shows the names of products whose list price is the second highest in the table. 

C. It shown the names of all products whose list price is less than the maximum list price 

D. It shows the names of all products in the table 

Answer:


Q30. - (Topic 1) 

Which two statements are true regarding the USING clause in table joins?(Choose two.) 

A. It can be used to join a maximum of three tables. 

B. It can be used to restrict the number of columns used in a NATURAL join. 

C. It can be used to access data from tables through equijoins as well as nonequijoins. 

D. It can be used to join tables that have columns with the same name and compatible data types. 

Answer: B,D 

Explanation: 

NATURAL JOIN operation A NATURAL JOIN is a JOIN operation that creates an implicit join clause for you based on the common columns in the two tables being joined. Common columns are columns that have the same name in both tables. If the SELECT statement in which the NATURAL JOIN operation appears has an asterisk (*) in the select list, the asterisk will be expanded to the following list of columns (in this order): 

All the common columns 

Every column in the first (left) table that is not a common column 

Every column in the second (right) table that is not a common column 

An asterisk qualified by a table name (for example, COUNTRIES.*) will be expanded to 

every column of that table that is not a common column. 

If a common column is referenced without being qualified by a table name, the column 

reference points to the column in the first (left) table if the join is an INNER JOIN or a LEFT 

OUTER JOIN. If it is a RIGHT OUTER JOIN, unqualified references to a common column 

point to the column in the second (right) table. 

Syntax 

TableExpression NATURAL [ { LEFT | RIGHT } [ OUTER ] | INNER ] JOIN { 

TableViewOrFunctionExpression | 

( TableExpression ) } 

Examples 

If the tables COUNTRIES and CITIES have two common columns named COUNTRY and 

COUNTRY_ISO_CODE, the following two SELECT statements are equivalent: 

SELECT * FROM COUNTRIES NATURAL JOIN CITIES 

SELECT * FROM COUNTRIES JOIN CITIES 

USING (COUNTRY, COUNTRY_ISO_CODE)