Question 1

SQL query results are displayed:

Accepted Answer

A) in a tabbed Resultset window. 
B) in a tabbed Query Result window. 
C) in a tabbed Document window. 
D) in a tabbed Messages window. 
E) in a tabbed Finished window. 
A) in a tabbed Resultset window. 
B) in a tabbed Query Result window. 
C) in a tabbed Document window. 
D) in a tabbed Messages window. 
E) in a tabbed Finished window.

Question 2

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 3

Explain sequences and their relationship to surrogate keys.

Accepted Answer

A sequence is an Oracle Database object

Question 4

Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.

Accepted Answer

SQL scripts are created in a text editor

Question 5

The CurrVal method provides the current value in a sequence.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

When Oracle Database Express Edition 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 8

Users log into the Oracle Database XE 11.2 utility using the ________ account.

Accepted Answer

The answer of Users log into the Oracle Database XE...

Question 9

What is SQL Developer?

Accepted Answer

SQL Developer is the GUI tool that is in

Question 10

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 11

To run an SQL script in Oracle Database Express Edition 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 using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Accepted Answer

A) True 
 B)False

Question 13

The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.

Accepted Answer

The answer of The Oracle Database ODBC Client is installed...

Question 14

SQL query results are displayed in a tabbed ________ window.

Accepted Answer

The answer of SQL query results are displayed in a...

Question 15

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 16

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

Accepted Answer

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

Question 17

Sequences are most often used to provide values for surrogate keys.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

full SQL c

Question 19

If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?

Accepted Answer

A) SET INTO T3 VALUES (101,'Smith','02/10/14'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/14','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2014'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/14','DD/MM/YY')); 
E) Any of the above will work correctly. 
A) SET INTO T3 VALUES (101,'Smith','02/10/14'); 
B) SET INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/14','DD/MM/YY')); 
C) INSERT INTO T3 VALUES (101,'Smith','02/10/2014'); 
D) INSERT INTO T3 VALUES (101,'Smith',TO_DATE ('02/10/14','DD/MM/YY')); 
E) Any of the above will work correctly.

Question 20

SQL statements can be run individually or as part of a related group of SQL statements known as a:

Accepted Answer

A) Result. 
B) Resultset. 
C) Script. 
D) Scriptset. 
E) Commandset. 
A) Result. 
B) Resultset. 
C) Script. 
D) Scriptset. 
E) Commandset.

SQL query results are displayed:

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

Explain sequences and their relationship to surrogate keys.

Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.

The CurrVal method provides the current value in a sequence.

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

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

Users log into the Oracle Database XE 11.2 utility using the ________ account.

What is SQL Developer?

Which method returns the next value in a sequence?

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

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.

SQL query results are displayed in a tabbed ________ window.

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

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

Sequences are most often used to provide values for surrogate keys.

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

If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?

SQL statements can be run individually or as part of a related group of SQL statements known as a:

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 2014 Express Edition

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters

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

SQL query results are displayed:

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

Explain sequences and their relationship to surrogate keys.

Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.

The CurrVal method provides the current value in a sequence.

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

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

Users log into the Oracle Database XE 11.2 utility using the ________ account.

What is SQL Developer?

Which method returns the next value in a sequence?

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

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.

SQL query results are displayed in a tabbed ________ window.

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

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

Sequences are most often used to provide values for surrogate keys.

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

If T3 is a table with three columns C1,C2 and C3,where C1 is integer data,C2 is character data,and C3 is date data,which of the following would be the proper statement to have Oracle Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted correctly as shown?

SQL statements can be run individually or as part of a related group of SQL statements known as a:

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 2014 Express Edition

Getting Started With Mysql 5.6 Community Server

Sql Views SQL/PSM and Importing Data

Getting Started in Systems Analysis and Design

Getting Started With Microsoft Visio 2013

the Access Workbench section H Microsoft Access 2013 Switchboards

Getting Started With Web Servers, Php, and the Net beans IDE

Business Intelligence Systems

Big Data

Filters