SQL Basics Test

How to change SQL prompt in Oracle?


From an Employee table, How will you display the record which has a Maximum salary?


In Oracle IN operator is also called as?


Select Ename, Job from Employee

ORDER BY Ename;


_______an instance of dana with in a relational database.


NULL is a keyword in oracle which never compare ASCII value.


What’s the maximum size of a row in SQL table?


What is the maximum number of triggers, can apply to a single table?


Switch to DOS Prompt?


To see current user name?


Oracle store the data in the form of?


Zero is equal to NULL value.


Which function is used to convert a NULL value to an actual value?


SQL * Plus ignores Blank Spaces before and after the Arithmetic Operations.


Which function is used to Filtering of Records?


















Description:

This is a multiple choice test.
Click the Start Test button below to start.
A question and the possible answer choices appear. Select the choice you find to be the correct answer of the question. Clicking ....................................................................................................................................

Comments
Siva Ramudu
By: Siva Ramudu
443 days 12 hours 43 minutes ago

1.How to Change SQL prompt in oracle is
set sqlprompt 'changed Name>';
so Ans is (a). Please Current this one

NEER
By: NEER
395 days 20 hours ago

what is 4rth question..? Its incomplete...

Want to learn?

Sign up and browse through relevant courses.

Name:
Your Email:
Password:
Country:
Contact no:


Area code Number
Subjects you are interested in:
Word verification: (Enter the text as in image)


Sign Up Already a member? Sign In
I agree to WizIQ's User Agreement & Privacy Policy
Siva Ramudu
Learning SQL, INFORMATICA
User
11 Followers

Your Facebook Friends on WizIQ

More Tests By Author

SQL TEST 2 (FUNCTIONS ONLY)
25 Questions | 108 Attempts

SQL TEST (FUNCTIONS ONLY)
25 Questions | 247 Attempts

Give live classes, create & sell online courses

Try it free Plans & Pricing

Connect