SQL & XML

Question 1

What does SQL stand for?

Answer 1

Structured Query Language

Question 2

What does “char” represent?

Answer 2

Character

Question 3

What does “VarChar” represent?

Answer 3

Set Length Character

Question 4

What does “blob” represent?

Answer 4

Sending Pictures

Question 5

Who developed SQL?

Answer 5

ANSI

Question 6

What does ANSI stand for?

Answer 6

American National Standard Institute

Question 7

What type of databases can use SQL?

Answer 7

Oracle, Microsoft and SQL Databases

Question 8

What command is used to extract data from a database?

Answer 8

SELECT

Question 9

What command is used to update a database?

Answer 9

UPDATE

Question 10

What command is used to delete from a database

Answer 10

DELETE

Question 11

What command is used to insert new data into a database?

Answer 11

INSERT INTO

Question 12

What command is used to create new databases?

Answer 12

CREATE DATABASE

Question 13

What command is used to modify a table?

Answer 13

ALTER DATABASE

Question 14

What command is used to create a new table?

Answer 14

CREATE TABLE

Question 15

What command is used to delete a table?

Answer 15

DROP TABLE

Question 16

What command is used to create an index?

Answer 16

CREATE INDEX

Question 17

What command is used to delete an index?

Answer 17

DELETE INDEX

Question 18

What does the “ * “ symbol signify?

Answer 18

ALL

Question 19

True or False? It is required to put a semicolon after sql statements?

Answer 19

TRUE

Question 20

True or False? SQL Keywords are case sensitive?

Answer 20

False

Question 21

What command is used to only return “different” values? (Non-repeating values)

Answer 21

DISTINCT

Question 22

What command is used to filter results?

Answer 22

WHERE

The WHERE clause is used to extract only those records that fulfill a specified condition.

Question 23

What does the operator “ = “ signify?

Answer 23

EQUAL

Question 24

What does the operator “ <> “ signify?

Answer 24

NOT EQUAL

Question 25

What does the operator " > " signify?

Answer 25

GREATER THAN

Question 26

What does the operator " < " signify?

Answer 26

LESS THAN

Question 27

What does the operator " >= " signify?

Answer 27

GREATER THAN OR EQUAL

Question 28

What does the operator " <= " signify?

Answer 28

LESS THAN OR EQUAL

Question 29

What does the operator " BETWEEN " signify?

Answer 29

Between a range

Question 30

What does the operator " LIKE " signify?

Answer 30

Searching for a pattern

Question 31

What does the operator " IN " signify?

Answer 31

Return results for a specific column

Question 32

What operator is used to return results for 1 or more condition?

Answer 32

The "and" operator and "or" operator

Question 33

What keyword is used to sort the result-set in ascending or descending order?

Answer 33

ORDER BY

Question 34

A field with no value is also referred to as?

Answer 34

NULL VALUE

Question 35

What two wildcards used in conjunction with the LIKE operator?

Answer 35

Percent ( % ) and Underscore ( _ )

Question 36

The __ wildcard represents zero, one, or multiple characters.

Answer 36

Percent ( % )

Question 37

The __ wildcard represents a single character.

Answer 37

Underscore ( _ )

Question 38

What does XML stand for?

Answer 38

eXtensible Markup Language.

Question 39

XML was designed to?

Answer 39

Store and Transport Data

Question 40

True or False? XML was designed to be human readable only?

Answer 40

False | XML was designed to be human and machine readable

Question 41

XML Tree structure starts at the ___ and break's off into __ ?

Answer 41

Root,Leaves

Question 42

True or False? XML Tags are case sensitive.

Answer 42

TRUE

Question 43

True of False? XML Attributes must be in quotes.

Answer 43

TRUE

Question 44

In XML, what does the symbol " &lt " represent?

Answer 44

Less Than " < "

Question 45

In XML, what does the symbol " &gt " represent?

Answer 45

Greater Than " > "

Question 46

In XML, what does the symbol " &amp " represent?

Answer 46

Ampersand " & "

Question 47

In XML, what does the symbol " &apos " represent?

Answer 47

Apostrophe " ' "

Question 48

In XML, what does the symbol " &quot " represent?

Answer 48

Quotation Marks " "" "

Question 49

True or False? XML preserves white space.

Answer 49

False

Question 50

What does DTD stand for?

Answer 50

Document Type Definition

Question 51

What does XSL stand for?

Answer 51

eXtensible Stylesheet Language