Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

CTEC 293 > SQL & XML > Flashcards

SQL & XML Flashcards

1
Q

What does SQL stand for?

A

Structured Query Language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What does “char” represent?

A

Character

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What does “VarChar” represent?

A

Set Length Character

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What does “blob” represent?

A

Sending Pictures

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Who developed SQL?

A

ANSI

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

What does ANSI stand for?

A

American National Standard Institute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What type of databases can use SQL?

A

Oracle, Microsoft and SQL Databases

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What command is used to extract data from a database?

A

SELECT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What command is used to update a database?

A

UPDATE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What command is used to delete from a database

A

DELETE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

INSERT INTO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What command is used to create new databases?

A

CREATE DATABASE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What command is used to modify a table?

A

ALTER DATABASE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What command is used to create a new table?

A

CREATE TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What command is used to delete a table?

A

DROP TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What command is used to create an index?

A

CREATE INDEX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What command is used to delete an index?

A

DELETE INDEX

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

What does the “ * “ symbol signify?

A

ALL

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

TRUE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

True or False? SQL Keywords are case sensitive?

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

DISTINCT

22
Q

What command is used to filter results?

A

WHERE

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

23
Q

What does the operator “ = “ signify?

A

EQUAL

24
Q

What does the operator “ <> “ signify?

A

NOT EQUAL

25
Q

What does the operator “ > “ signify?

A

GREATER THAN

26
Q

What does the operator “ < “ signify?

A

LESS THAN

27
Q

What does the operator “ >= “ signify?

A

GREATER THAN OR EQUAL

28
Q

What does the operator “ <= “ signify?

A

LESS THAN OR EQUAL

29
Q

What does the operator “ BETWEEN “ signify?

A

Between a range

30
Q

What does the operator “ LIKE “ signify?

A

Searching for a pattern

31
Q

What does the operator “ IN “ signify?

A

Return results for a specific column

32
Q

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

A

The “and” operator and “or” operator

33
Q

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

A

ORDER BY

34
Q

A field with no value is also referred to as?

A

NULL VALUE

35
Q

What two wildcards used in conjunction with the LIKE operator?

A

Percent ( % ) and Underscore ( _ )

36
Q

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

A

Percent ( % )

37
Q

The __ wildcard represents a single character.

A

Underscore ( _ )

38
Q

What does XML stand for?

A

eXtensible Markup Language.

39
Q

XML was designed to?

A

Store and Transport Data

40
Q

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

A

False

XML was designed to be human and machine readable

41
Q

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

A

Root,Leaves

42
Q

True or False? XML Tags are case sensitive.

A

TRUE

43
Q

True of False? XML Attributes must be in quotes.

A

TRUE

44
Q

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

A

Less Than “ < “

45
Q

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

A

Greater Than “ > “

46
Q

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

A

Ampersand “ & “

47
Q

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

A

Apostrophe “ ‘ “

48
Q

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

A

Quotation Marks “ “” “

49
Q

True or False? XML preserves white space.

A

False

50
Q

What does DTD stand for?

A

Document Type Definition

51
Q

What does XSL stand for?

A

eXtensible Stylesheet Language

CTEC 293 (1 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions