9/15/2019 Entrance Test - SQL

DashboardMy coursesFELLOWSHIP IITechnical TestEntrance Test - SQL

Question 1
Not yet answered
Marked out of 1.00

In an assignment, you need to compare two values. If both are equal, the result would be null, and if the
values are not equal then the first value should be returned. Which function should you use?

Select one:
a. NVL
b. NULLIF
c. NVL2
d. COALESCE

Question 2
Not yet answered
Marked out of 1.00

What is the most common date format in SQL?

Select one:
a. YYYY-MM-DD
b. DD-MM-YYYY
c. MM-DD-YYYY
d. YYYY-DD-MM

https://www.iykra.com/mod/quiz/attempt.php?attempt=4282 1/5
9/15/2019 Entrance Test - SQL

Question 3
Not yet answered
Marked out of 1.00

If we want to get 2 columns (Name and NIK) from data of "Kecamatan" citizens, what will be the correct
SQL code?

Select one:
a. Salah Semua
b. Select
c. Select From
d. Select From Where

Question 4
Not yet answered
Marked out of 1.00

To combine two or more tables when there is match in both tables, use….

Select one:
a. Inner Join
b. Left Join
c. Join
d. Right Join

Question 5
Not yet answered
Marked out of 1.00

What is the difference between TEXT and VARCHAR?

Select one:
a. None of above are correct
b. The output
c. The length
d. The display

https://www.iykra.com/mod/quiz/attempt.php?attempt=4282 2/5
9/15/2019 Entrance Test - SQL

Question 6
Not yet answered
Marked out of 1.00

The operator that used to select multiple values in a WHERE clause, used:

Select one:
a. AND
b. Between
c. Like
d. IN

Question 7
Not yet answered
Marked out of 1.00

What is the difference of SQL Delete and SQL Truncate?

Select one:
a. SQL DELETE is a DML Command, while SQL TRUNCATE is a DDL Command.
b. WHERE condition can be used IN SQL DELETE command, while in SQL TRUNCATE
command, condition doesn’t work.
c. SQL DELETE is used to delete all the records row by row, while SQL TRUNCATE is used to
delete all the records at a time.
d.
All answers are correct.

https://www.iykra.com/mod/quiz/attempt.php?attempt=4282 3/5
9/15/2019 Entrance Test - SQL

Question 8
Not yet answered
Marked out of 1.00

The CLIENTS table has these columns:

CLIENT_ID NUMBER(4) NOT NULL
CLIENT_NAME VARCHAR2(100) NOT NULL
STREET_ADDRESS VARCHAR2(150)
DISTRICT_ADDRESS VARCHAR2(50)
CITY_ADDRESS VARCHAR2(50)
PROVINCE_ADDRESS VARCHAR2(50)
COUNTRY_ADDRESS VARCHAR2(50)
POSTAL_CODE VARCHAR2(12)
CLIENT_PHONE VARCHAR2(20)
A promotional kit is being advertised to the clients in Singapore. Which WHERE clause identifies
customers that are located in Singapore?

Select one:
a. WHERE lower(country_address) IS 'singapore'
b. WHERE lower(country_address) = '%singapore%'
c. WHERE lower(country_address) = 'singapore'
d. WHERE lower(country_address) = "singapore"

Question 9
Not yet answered
Marked out of 1.00

Consider the following statement:

CITIES(subject_code, department_name, location_id, district);
Which code snippet will alter the table CITIES and change the datatype of the column DISTRICT to
varchar2(30)?

Select one:
a. ALTER TABLE cities MODIFY (district varchar2(30));
b. None of the above.
c. ALTER TABLE cities MODIFY COLUMN (district varchar2(30));
d. MODIFY TABLE cities ADD (district varchar2(30));

https://www.iykra.com/mod/quiz/attempt.php?attempt=4282 4/5
9/15/2019 Entrance Test - SQL

Question 10
Not yet answered
Marked out of 1.00

Given the snippet table below

Please fill in the blanks!

SELECT title, release year FROM films ….. release_year BETWEEN 2002 …… 2007 LIMIT 5;

Select one:
a. WHEN, IF
b. WHERE, AND
c. WHERE, OR
d. CASE, HAVING

◄ Entrance Test - Python Jump to...

Entrance Test - Linux ►

Copyright © 2019 IYKRA

https://www.iykra.com/mod/quiz/attempt.php?attempt=4282 5/5