
Oracle_SQL_Lesson-3
Quiz
•
Science
•
Professional Development
•
Easy
DataCubeAz DataCubeAz
Used 1+ times
FREE Resource
Enhance your content in a minute
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Hansı əməliyyat “1234.56” mətnini ədədə çevirir?
TO_NUMBER('1234.56')
TO_CHAR(1234.56)
TO_DATE('1234.56', '9999.99')
TO_NUMBER(1234,56)
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Hansı sorğu 2024-03-01 tarixindən sonra olan əməliyyatları seçir?
WHERE transaction_date > TO_CHAR('2024-03-01','YYYY-MM-DD')
WHERE transaction_date > TO_DATE('2024-03-01','YYYY-MM-DD')
WHERE TO_DATE(transaction_date) > '2024-03-01'
WHERE transaction_date BETWEEN '2024-03-01' AND SYSDATE
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Aşağıdakı funksiyanın nəticəsi necə olacaq?
TO_CHAR(12345.67, '999,999.00')
12.345,67
12345.67
12,345.67
12 345.67
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Hansı variant NULL dəyərləri 0 ilə əvəz edir?
NVL(balance, 0)
NVL2(balance, 0, NULL)
COALESCE(0, balance)
NULLIF(balance, 0)
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
NVL2(a,b,c) funksiyası nə edir?
NULL dəyərləri b ilə əvəz edir
a ilə b-ni toplayır
Əgər a NULL deyilsə b qaytarır, əks halda c qaytarır
NULL dəyərləri silir
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
COALESCE(income, balance, 0) ifadəsi nə edir?
Ən böyük ədədi tapır
İlk NULL olmayan dəyəri qaytarır
NULL olanları sayır
NULL-ları 0 edir
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
NULLIF(a,b) nə vaxt NULL qaytarır?
a və b fərqli olduqda
a NULL olduqda
b NULL olduqda
a və b bərabər olduqda
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
MINERS Core Values Quiz
Quiz
•
8th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
Discover more resources for Science
10 questions
How to Email your Teacher
Quiz
•
Professional Development
21 questions
October 25
Quiz
•
Professional Development
10 questions
October Monthly Quiz
Quiz
•
Professional Development
20 questions
There is There are
Quiz
•
Professional Development
5 questions
SSUSH13
Interactive video
•
Professional Development
10 questions
Halloween Trivia
Quiz
•
Professional Development
