MORE QUERIES

Question 1

ALL QUERIES IN MS ACCESS ARE CONVERTED, IN THE BACKGROUND

Answer 1

STRUCTURE QUERY LANGUAGE

Question 2

MOST DATABASE APPLICATIONS USE

Answer 2

SQL (STRUCTURE QUERY LANGUAGE)

Question 3

IMPLEMENTATIONS OF SQL THAT ARE ROOTED TO THE ORIGINAL ONE AND EACH ONE IS CALLED

Answer 3

DIALECT

Question 4

EACH OF THESE HAS ITS OWN VARIATIONS, SO THERE WILL BE DIFFERENCES IN THE CODE

Answer 4

DIALECT

Question 5

THE ITEMS ENCLOSED ([])

Answer 5

SQUARE BRACKETS

Question 6

OPTIONAL

Answer 6

SQUARE BRACKETS

Question 7

({})

Answer 7

ENCLOSED IN BRACES

Question 8

REQUIRED IN A SELECT QUERY

Answer 8

ENCLOSED IN BRACES

Question 9

SELECT AND FROM CLAUSE ARE REQUIRED

Answer 9

IN SELECT QUERY

Question 10

YOU TO PICK AMONG GIVEN OPTIONS

Answer 10

A VERTICAL BAR ( I )

Question 11

YOU HAVE THE OPTION TO SHOW ALL RECORDS BY PLACING

Answer 11

ASTERISK (*)

Question 12

Indicates repetition of an item that is optional and may be discarded or seen more than once

Answer 12

ELLIPSE

Question 13

IT IS NOT CASE-SENSITIVE

Answer 13

SQL

Question 14

RESERVED WORDS WILL BE IN

Answer 14

UPPERCASE

Question 14

USER-DEFINED NAMES IS IN

Answer 14

LOWERCASE

Question 15

EACH CLAUSE IS PLACED ON A

Answer 15

NEW LINE FOR CLARITY

Question 16

IT FOLLOWS BY

Answer 16

A TABLE OF RESERVED WORDS AND DESCRIPTION

Question 17

USED FOR GIVING ALIASES OR ALTERNATIVE
NAMES TO COLUMN

Answer 17

AS

Question 18

INDICATES THE TABLES THAT WILL BE USED IN THE QUERY

Answer 18

FROM

Question 19

FILTERS THE RECORDS BASED ON THE SPECIFIED QUERY

Answer 19

WHERE

Question 20

GROUPS RECORDS WITH THE SAME FIELD VALUE

Answer 20

GROUP BY

Question 21

WORKS LIKE WHERE BUT APPLIES ONLY TO GROUPS

Answer 21

HAVING

Question 22

INDICATES HOW THE FIELDS WILL BE SORTED

Answer 22

ORDER BY