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 ....................................................................................................................................

Discussion

Békési Dávid

It's full of bad questions! You don't specify the SQL types and so on....

1361 days 12 hours 40 minutes ago

NEER

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

3095 days 7 hours 24 minutes ago

Siva Ramudu

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

3143 days 6 minutes ago

Siva Ramudu
Learning SQL, INFORMATICA
User
12 Followers

Your Facebook Friends on WizIQ

More Tests By Author

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

SQL TEST (FUNCTIONS ONLY)
25 Questions | 1079 Attempts

Explore Similar Courses