QUESTION 1 A ____ file is a text file with a .sql extension that contains SQL co

Question

QUESTION 1

A ____ file is a text file with a .sql extension that contains SQL commands.

sequel

batch

script

command

4 points   

QUESTION 2

Access does not support the ____ data type.

INT

DECIMAL

NUMBER

CURRENCY

4 points   

QUESTION 3

In Oracle, the date, November 12, 2015 would be stored as ‘12-NOV-2015’.

True

False

4 points   

QUESTION 4

In SQL, there are special rules that specify that a particular word must begin in a particular position on the line.

True

False

4 points   

QUESTION 5

To delete an entire table, use the ____ command and then re-create the table.

DROP TABLE

ERASE TABLE

REMOVE TABLE

DELETE TABLE

4 points   

QUESTION 6

In Oracle, the data type STRING(n) stores a character string n characters long.

True

False

4 points   

QUESTION 7

When a script file contains more than one command, each command must end with a(n) ____.

colon

apostrophe

period

semicolon

4 points   

QUESTION 8

Dropping a table also deletes any data that you entered into the table.

True

False

4 points   

QUESTION 9

If your screen displays the SQL Scripts page, the Home>SQL Workshop>SQL Scripts reference near the top of the SQL Scripts page is called a ____.

breadcrumb

page trail

page sequence

command sequence

4 points   

QUESTION 10

To move back one or more pages in Oracle Database 11g Express, click the pages icon in the task bar.

True

False

4 points   

QUESTION 11

To display all the rows and columns in a table, type the word SELECT, followed by a(n) ____, followed by the word FROM and then the name of the table containing the data you want to view.

slash

single quote

asterisk

double quote

4 points   

QUESTION 12

To list all the columns in a table, use the LIST COLUMNS command.

True

False

4 points   

QUESTION 13

Table names cannot contain spaces.

True

False

4 points   

QUESTION 14

The ____ data type stores only the actual character string.

STRING

TEXT

CHAR

VARCHAR

4 points   

QUESTION 15

Oracle stores script files is a special location called Saved Commands.

True

False

4 points   

QUESTION 16

SQL was developed as the data manipulation language for IBM’s prototype relational model DBMS, System R.

True

False

4 points   

QUESTION 17

If you added a row that should not be in a table, use a REMOVE command to remove it.

True

False

4 points   

QUESTION 18

In SQL, you cannot enter an apostrophe into a column whose type is character (CHAR).

True

False

4 points   

QUESTION 19

Microsoft SQL Server is a DBMS designed for use in client-server applications.

True

False

4 points   

QUESTION 20

SQL was developed in the mid-____.

1970s

1980s

1990s

1960s

4 points   

QUESTION 21

To view data in a table, use the VIEW command.

True

False

4 points   

QUESTION 22

In SQL, table names cannot exceed ____ characters.

12

30

14

24

4 points   

QUESTION 23

In Access, use the Documenter tool to describe the tables in a database.

True

False

4 points   

QUESTION 24

In Access, dates are enclosed in number signs and are entered using the format ____.

DD/MM/YY

YYYY/MON/DD

MM/DD/YYYY

DD/MON/YYYY

4 points   

QUESTION 25

Unlike Oracle, Access does not support the DECIMAL data type.

True

False

a.

sequel

b.

batch

c.

script

d.

command

Explanation / Answer

Hi,

These were all straight forward questions targetting on facts. Please find the answers below and let me know in case of doubts:

1. c. script file
2. DECIMAL
3. True
4. False
5. a. DROP table
6. False
7. d. semicolon
8. True
9. Breadcrumb
10. False
11. c. ASTERISK
12. Flase
13. True
14. VARCHAR
15. False
16. True
17. False
18. False
19. True
20. a. 1970s
21. False
22. b. 30
23. True
24. MM/DD/YYYY
25. True

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.