(Choose the best answer.)
A. Oracle databases
B. Oracle application servers
C. Third-party products
D. The server machines
E. All of the above
2. What languages can run within
the database?
(Choose all that apply.)
A. SQL
B. C
C. PL/SQL
D. Java
E. Any other language linked to
the OCI libraries
3. Data that is modeled into
a form suitable for processing in a relational database may be described
as being
(Choose the best answer.)
A. First normal form
B. Third normal form
C. Abnormal form
D. Paranormal form
4. An entity-relationship diagram shows data modeled
into
(Choose the best answer.)
A. Two-dimensional tables
B. Multidimensional tables
C. Hierarchical structures
D. Object-oriented structures
5. SQL is a set-oriented language. Which of these features
is a consequence of this?
(Choose the best answer.)
A. Individual rows must have a unique identifier.
B. Sets of users can be managed in groups.
C. SQL statements can be placed within blocks of code
in other languages, such as Java and PL/SQL.
D. One statement can affect multiple rows.
6. Which of these constructs is not part of the SQL
language?
(Choose all that apply.)
A. Iteration, based on WHILE..
B. Iteration, based on FOR..DO
C. Branching, based on IF..THEN..ELSE
D. Transaction control, based on COMMIT
E. Transaction contro
7. Which of these statements regarding SQL Developer
are correct?
(Choose two answers.)
A. SQL Developer cannot connect to databases earlier than
release 10g.
B. SQL Developer can be installed outside an Oracle Home.
C. SQL Developer can store passwords.
D. SQL Developer relies on an LDAP directory for name
resolution.
8. Which of the following are requirements for using
SQL Developer?
(Choose two correct answers.)
A. A Java Runtime Environment
B. The OCI libraries
C. A name resolution method such as LDAP or a TNSNAMES.ORA
file
D. The SQL*Plus libraries
E. A graphical terminal
9. Where may the demonstration schemas be created?
(Choose the best answer.)
A. The demonstration schemas must be created in a demonstration
database.
B. The demonstration schemas cannot be created in a production
database.
C. The demonstration schemas can be created in any database.
D. The demonstration schemas can be created in any database
if the demonstration user is created first.
10. How can you move a schema from one user to another?
(Choose the best answer.)
A. Use the ALTER SCHEMA MOVE… command.
B. You cannot move a schema from one user to another.
C. A schema can only be moved if it is empty (or if all
objects within it have been dropped).
D. Attach the new user to the schema, then detach the
old user from the schema.
---
Answers:
1. E. Cloud Control can manage the complete environment (according to Oracle Corporation).
A, B, C, and D are incorrect. All of these can be managed
by Cloud Control.
2. A, C, and D. SQL, PL/SQL, and Java can all run in the database.
B and E are incorrect.
C cannot run inside the database, and OCI is used
by external processes to connect to the database; it does not run within
it.
3. B. Third normal form is the usual form aimed for by systems analysts when they normalize data into relational structures.
A, C, and D are incorrect.
A is incorrect because first normal form is only the first stage of data normalization.
C and D would be more suitable to the X-Files than
to a database.
4. A. The relational model uses two-dimensional tables.
B, C, and D are incorrect.
B is incorrect because two dimensions is the limit for
relational structures. C and D are incorrect because they refer to nonrelational
structures (though there are facilities within the Oracle database for
simulating them).
5. D. In a set-oriented language, one command can affect many rows (a set), whereas a procedural language processes rows one by one.
A, B, and C are incorrect.
A is incorrect because while rows should have a unique identifier in a well designed application, this is not actually a requirement. B is incorrect because users cannot be grouped in the Oracle environment.
C is incorrect because (even though the statement is correct)
it is not relevant to the question.
6. A, B, and C. These are all procedural constructions, which are not part of a setoriented language. They are all used in PL/SQL.
D and E are incorrect. These are SQL’s transaction control
statements.
7. B and C. B is correct because SQL Developer can be installed in its own directory.
C is correct because passwords can be saved as part of a connection definition (though this may not be a good idea).
A and D are incorrect.
A is incorrect because the Oracle Net protocol lets SQL Developer connect to a number of versions of the database.
D is incorrect because LDAP is only one of several techniques
for name resolution.
8. A and E. A is correct because SQL Developer is written in Java and therefore requires a Java Runtime Environment.
E is correct because SQL Developer needs a graphics terminal to display windows.
B, C, and D are incorrect.
B is incorrect because SQL Developer uses JDBC to connect to databases, not OCI.
C is incorrect because, while SQL Developer can use LDAP or a TNSNAMES.ORA file, it can also use and store the basic connection details.
D is incorrect because SQL Developer is a completely independent
product.
9. C. The demonstration schemas can be created in any database, either at database creation time or by running scripts later.
A, B, and D are incorrect.
A and B are incorrect because, while they may be good practice, they are not a technical requirement.
D is incorrect because it fails to understand that a schema
can only be (and always is) created with a user.
10. B. A schema and a user are inseparable.
A, C, and D are incorrect.
A is incorrect because there is no such command. C and
D are incorrect because they assume the impossible: that you can separate
a user from his or her
schema.
