BETWEEN -->>Used for range with in values; LIKE -->>Used for Search a pattern; IN -->>return east one of the columns in given set of values

SQL Database Keys and Operators

Quiz covering SQL database keys (Primary Key, Foreign Key, Unique Key), comparison operators, and basic DML statements including SELECT, INSERT, and ORDER BY clauses

10 Questions Published

Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

What is the statement to specify the varibales in the Freq procdure

VAR
TABLES
BY
COLUMNS

Question 2 Multiple Choice (Multiple Answers)

Choose correct syntax to insert values into r4r_team table

INSERT INTO r4r_team (id, username, exp) VALUES (1, ‘r4r01’, ‘2’);
INSERT INTO r4r_team VALUES (1, ‘r4r01’, ‘2’);
INSERT INTO r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);
INSERT INTO table r4r_team (id, username, exp) VALUE (1, ‘r4r01’, ‘2’);

Question 3 Multiple Choice (Multiple Answers)

What is true for following DML SQL statement SELECT username, exp, salary FROM r4r_team ORDER BY username DESC;

Used to select username,exp, salary from r4r_team which is decreasing order by username.
Used to select username,exp, salary from r4r_team which is increasing order by username.
Used to select username,exp, salary from r4r_team which is decreasing order by exp.
none

Question 4 Multiple Choice (Multiple Answers)

Which is true for AND & OR

These are Operators .Which are used to filter records based on more than one conditions.
These Operators are used to join two tables.
Never used in SQL
None

Question 5 Multiple Choice (Multiple Answers)

Choose true option

BETWEEN -->>Used for range with in values
LIKE -->>Used for Search a pattern
IN -->>return east one of the columns in given set of values
None

Question 6 Multiple Choice (Multiple Answers)

<> and != both are same operator into SQL

true.
false.
both are not used into SQL.
Both are used assembly languages only.

Question 7 Multiple Choice (Multiple Answers)

Which is not used into SQL =,<>,> ,<,>=,<=,>>>

all are used
only >>> not used
only <>
None

Question 8 Multiple Choice (Single Answer)

What is a PK

UK + Not null
UK
UK + null
UKKKK

Question 9 Multiple Choice (Single Answer)

What is a FK

Question 10 Multiple Choice (Single Answer)

What is a UK

← Back to Quizzes