INF3707 Exam pack 2025(Database Design and Implementation)

INF3707 EXAM PACK
2025

QUESTIONS AND
ANSWERS
FOR ASSISTANCE CONTACT
EMAIL:

, lOMoARcPSD|50013335




Oracle 12C SQL 3rd Edition Casteel Test Bank
Full Download: http://alibabadownload.com/product/oracle-12c-sql-3rd-edition-casteel-
Chapter 02: Basic SQL SELECT Statements
True / False

1. The majority of operations performed on a typical database table utilize the SELEC
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 30

2. When a user asks the database a question, the user is issuing a query.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 31

3. Each section of a SQL command that begins with a keyword is known as a statement.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 31

4. A clause is a section within a SQL statement that begins with a keyword.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 31

5. SQL*Plus is an Oracle tool used to enter and edit SQL statements.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 27

6. SQL*Plus can only be accessed via an internet interface.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 27

7. A script file containing SQL statements can be executed from SQL*Plus.
a.True
Cengage Learning Testing, Powered by Cognero Page 1



This sample only, Download all chapters at: alibabadownload.com

, lOMoARcPSD|50013335




Chapter 02: Basic SQL SELECT Statements

b.False
ANSWER: True
POINTS: 1
REFERENCES: 27

8. The DESCRIBE command is used to view data in a table.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 29
30

9. A query is accomplished by issuing a SELECT statement.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 31

10. The asterisk symbol (*) can be used in a SELECT statement to indicate that all ro
in the results.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 31
32

11. A user can indicate that all columns of a table should be displayed in the result
an asterisk (*) in the SELECT clause.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 31
32

12. Column headings may be truncated in the results of a SELECT statement.
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 32

13. The SELECT clause of the SELECT statement is used to identify which rows are to b
Cengage Learning Testing, Powered by Cognero Page 2

, lOMoARcPSD|50013335




Chapter 02: Basic SQL SELECT Statements
table.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 31

14. Choosing specific columns to be displayed by a SELECT statement is known as selec
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 33

15. Choosing specific columns to be displayed by a SELECT statement is known as proje
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 33

16. If a column name is entered in lower case in the SELECT statement, the data for t
case in the results.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 34

17. If multiple column names are listed in the SELECT clause of a SELECT statement, t
a comma (,).
a.True
b.False
ANSWER: True
POINTS: 1
REFERENCES: 34
35

18. The columns displayed in the results of a SELECT statement will be in the same or
database table.
a.True
b.False
ANSWER: False
POINTS: 1
REFERENCES: 35

Cengage Learning Testing, Powered by Cognero Page 3