SQL* PLUS, SQL and PL/SQL

DOWNLOAD FREE PDF <<CLICK HERE>>

SQL* PLUS, SQL and PL/SQL

Congratulations - you have completed SQL* PLUS, SQL and PL/SQL.

You scored %%SCORE%% out of %%TOTAL%%.

Your performance has been rated as %%RATING%%


Your answers are highlighted below.
Question 1 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy

A
SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
B
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
C
SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
D
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');
Question 2 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
The entity relationship set is represented in E-R diagram as
A
Double diamonds
B
Undivided rectangles
C
Dashed lines
D
Diamond
Question 3 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Reason for Mirroring Databse

A
Back up of the DB
B
Running the Copy of the DB simultaniously
C
To avoid slowness
D
Provide ExraSecurity
Question 4 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
I want to change the address and postcode of customerID 6 in the customer table. Which SQL statement would be correct to use?

A
UPDATE customerSET address1="37 Clarence Avenue" AND postcode = "G12 4FD"WHERE customerID = 6
B
UPDATE customersSET address1="37 Clarence Avenue", postcode = "G12 4FD"WHERE customerID = 6
C
UPDATE customerSET address1="37 Clarence Avenue",SET postcode = "G12 4FD"WHERE customerID = 6
D
UPDATE customerSET address1="37 Clarence Avenue", postcode = "G12 4FD"WHERE customerID = 6
Question 5 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Find the names of those cities with temperature and condition whose condition is neither sunny nor cloudy

A
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN ('sunny', 'cloudy');
B
SELECT city, temperature, condition FROM weather WHERE condition IN ('sunny', 'cloudy');
C
SELECT city, temperature, condition FROM weather WHERE condition NOT IN ('sunny', 'cloudy');
D
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN ('sunny', 'cloudy');
Question 6 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
What is the correct statement for the following add a record for a new employee with the employee number 1122, Bloggs, who was hired on the 1/1/2001, with a salary of RS.18,000 and works in the technical department

A
INSERT INTO Employee ( Name, HireDate, Salary, Department, EMPID ) statement was used and the values were (1122, "Bloggs", #1/1/200#, 18000, "Technical")
B
INSERT INTO Employee ( Name, HireDate, Salary, Department, EMPID ) statement was used and the values were (1122, "Bloggs", #1/1/2001#, 19000, "Technical")
C
INSERT INTO Employee (EMPID, Name, HireDate, Salary, Department) statement was used and the values were (1122, "Bloggs", #1/1/2001#, 18000, "Technical")
D
INSERT INTO Employee (EMPID, Name, HireDate, Salary, Department) statement was used and the values were (1132, "Bloggs", #1/1/2001#, 18000, "Technical")
Question 7 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Display the concatenated value of Salesman Name and his location. Use constant string ' is from ' for concatenation (contains single space at beginning and end).

SQL* PLUS, SQL PL SQL MCQ
A
select concat(sname,' is from '),location) "RESULT" from salesman;
B
select concat(concat(sname,' is from ',location) "RESULT" from salesman;
C
select concat(concat(sname,' is from '),location) from salesman;
D
select concat(concat(sname,' is from '),location) "RESULT" from salesman;
Question 8 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Perintah select yang memiliki ekspresi kondisi

jika nilai...matakuliah=E maka status='mengulang' jika bukan maka status='berhasil' query yang benar ialah

SQL* PLUS, SQL PL SQL MCQ
A
SELECT nama, nama, CASE nilai...matakuliah ='E' THEN 'Mengulang' ELSE 'BERHASIL' END AS Statusbelajar FROM mahasiswa;
B
SELECT nama, nama, CASE nilai...matakuliah LIKE 'E' THEN 'Mengulang' ELSE 'BERHASIL' END AS Statusbelajar FROM mahasiswa;
C
SELECT nama, nama, CASE nilai...matakuliah WHEN 'E' THEN 'Mengulang' ELSE 'BERHASIL' END AS Statusbelajar FROM mahasiswa;
D
SELECT nama, nama, CASE nilai...matakuliah =='E' THEN 'Mengulang' ELSE 'BERHASIL' END AS Statusbelajar FROM mahasiswa;
Question 9 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
What criteria would you use in the field City to find people who lived in Manchester and London

SQL* PLUS, SQL PL SQL MCQ
A
=london OR manchester
B
=London AND Manchester
Question 10 [CLICK ON ANY CHOICE TO KNOW MCQ multiple objective type questions RIGHT ANSWER]
Table Employee has 10 records. It

has a non-NULL SALARY column which is also UNIQUE.

The SQL statement

SELECT COUNT(*) FROM Employee WHERE SALARY > ANY (SELECT SALARY FROM

EMPLOYEE);

prints

A
10
B
9
C
5
D
0
Once you are finished, click the button below. Any items you have not completed will be marked incorrect. Get Results
There are 10 questions to complete.

DOWNLOAD FREE PDF <<CLICK HERE>>