Question 1

Which of the following is an account name for which you are asked to enter a password for the Oracle Database XE 11.2 utility?

Accepted Answer

A)  SYSTEM 
B)  EXTERNAL 
C)  INTERNAL 
D)  A and B 
E)  A, B and C 
A)  SYSTEM 
B)  EXTERNAL 
C)  INTERNAL 
D)  A and B 
E)  A, B and C

Question 2

Oracle Database XE 11.2 uses Application Express to create new workspaces.

Accepted Answer

A) True 
 B)False

Question 3

What is the Oracle Database XE 11.2?

Accepted Answer

The Oracle Database XE 11.2 utility is a

Question 4

With Oracle Database,data must be entered using SQL INSERT statements.

Accepted Answer

A) True 
 B)False

Question 5

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Accepted Answer

A) True 
 B)False

Question 6

To log into Oracle Database XE 11.2,use your personal account information.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following tasks can be done using the Oracle SQL Developer?

Accepted Answer

A)  See the structure of a table 
B)  Add and remove columns from a table 
C)  Insert and delete data from a table 
D)  A and B 
E)  A, B and C 
A)  See the structure of a table 
B)  Add and remove columns from a table 
C)  Insert and delete data from a table 
D)  A and B 
E)  A, B and C

Question 8

The Oracle Database ODBC Client is automatically installed when Oracle Database 11g Release 2 is installed.

Accepted Answer

A) True 
 B)False

Question 9

Which method returns the next value in a sequence?

Accepted Answer

A)  CountVal 
B)  Next 
C)  UpVal 
D)  NextVal 
E)  Append 
A)  CountVal 
B)  Next 
C)  UpVal 
D)  NextVal 
E)  Append

Question 10

The NextVal method provides the next value in a sequence.

Accepted Answer

A) True 
 B)False

Question 11

To run an SQL script in Oracle Database 11g Release 2:

Accepted Answer

A)  click the Execute button. 
B)  click the Execute Script button. 
C)  click the Run Script button. 
D)  click the Ready button. 
E)  click the Results button. 
A)  click the Execute button. 
B)  click the Execute Script button. 
C)  click the Run Script button. 
D)  click the Ready button. 
E)  click the Results button.

Question 12

When Oracle Database 11g Release 2 is installed,the Oracle Database ODBC client is:

Accepted Answer

A)  installed automatically as part of the installation. 
B)  installed manually as a separate part of the installation process. 
C)  not installed and must be downloaded and installed manually. 
D)  not installed because there is no ODBC client for Oracle Database 11g Release 2 Express Edition. 
E)  Either A or B 
A)  installed automatically as part of the installation. 
B)  installed manually as a separate part of the installation process. 
C)  not installed and must be downloaded and installed manually. 
D)  not installed because there is no ODBC client for Oracle Database 11g Release 2 Express Edition. 
E)  Either A or B

Question 13

Which of the following is the easiest tool for creating a database with Oracle Database?

Accepted Answer

A)  The Oracle Database XE 11.2 utility 
B)  The Oracle SQL*Plus command utility program 
C)  The Oracle SQL Developer 
D)  A and C 
E)  A, B and C 
A)  The Oracle Database XE 11.2 utility 
B)  The Oracle SQL*Plus command utility program 
C)  The Oracle SQL Developer 
D)  A and C 
E)  A, B and C

Question 14

Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.

Accepted Answer

A) True 
 B)False

Question 15

To run an SQL script,click the ________ button.

Accepted Answer

The answer of To run an SQL script,click the ________...

Question 16

The default file extension for text files created for or within SQL Developer is .sql.

Accepted Answer

A) True 
 B)False

Question 17

Users in SQL Developer log into a workspace using the ________ account.

Accepted Answer

associated

Question 18

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Accepted Answer

A) True 
 B)False

Question 19

An important reason for using Oracle Database 11g Release 2 is that it has ________.

Accepted Answer

full SQL c

Question 20

To create a new SQL query,click the ________ button.

Accepted Answer

The answer of To create a new SQL query,click the...

Which of the following is an account name for which you are asked to enter a password for the Oracle Database XE 11.2 utility?

Oracle Database XE 11.2 uses Application Express to create new workspaces.

What is the Oracle Database XE 11.2?

With Oracle Database,data must be entered using SQL INSERT statements.

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

To log into Oracle Database XE 11.2,use your personal account information.

Which of the following tasks can be done using the Oracle SQL Developer?

The Oracle Database ODBC Client is automatically installed when Oracle Database 11g Release 2 is installed.

Which method returns the next value in a sequence?

The NextVal method provides the next value in a sequence.

To run an SQL script in Oracle Database 11g Release 2:

When Oracle Database 11g Release 2 is installed,the Oracle Database ODBC client is:

Which of the following is the easiest tool for creating a database with Oracle Database?

Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.

To run an SQL script,click the ________ button.

The default file extension for text files created for or within SQL Developer is .sql.

Users in SQL Developer log into a workspace using the ________ account.

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

An important reason for using Oracle Database 11g Release 2 is that it has ________.

To create a new SQL query,click the ________ button.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters

Exam 10: Getting Started With Oracle Database 11g Release 2

Which of the following is an account name for which you are asked to enter a password for the Oracle Database XE 11.2 utility?

Oracle Database XE 11.2 uses Application Express to create new workspaces.

What is the Oracle Database XE 11.2?

With Oracle Database,data must be entered using SQL INSERT statements.

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

To log into Oracle Database XE 11.2,use your personal account information.

Which of the following tasks can be done using the Oracle SQL Developer?

The Oracle Database ODBC Client is automatically installed when Oracle Database 11g Release 2 is installed.

Which method returns the next value in a sequence?

The NextVal method provides the next value in a sequence.

To run an SQL script in Oracle Database 11g Release 2:

When Oracle Database 11g Release 2 is installed,the Oracle Database ODBC client is:

Which of the following is the easiest tool for creating a database with Oracle Database?

Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.

To run an SQL script,click the ________ button.

The default file extension for text files created for or within SQL Developer is .sql.

Users in SQL Developer log into a workspace using the ________ account.

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

An important reason for using Oracle Database 11g Release 2 is that it has ________.

To create a new SQL query,click the ________ button.

Getting Started

The Relational Model

Structured Query Language

Data Modeling and the Entity-Relationship Model

Database Design

Database Administration

Database Processing Applications

Big Data, data Warehouses, and Business Intelligence Systems

Getting Started With Microsoft Sql Server 2012

Getting Started With Mysql 56 Community Server

James River Jewelry Project Questions

Sql Views

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2010

The Access Workbench-section Microsoft Access

Getting Started With Web Servers, php, and the Netbeans IDE

Business Intelligence Systems

Filters