Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

What is the Oracle Database 11g XE utility?

Accepted Answer

The Oracle Database 11g XE utility is a

Question 3

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)  INSERT INTO T3 VALUES ('Smith', TO_DATE ('02/10/14', 'DD/MM/YY'), 101); 
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)  INSERT INTO T3 VALUES ('Smith', TO_DATE ('02/10/14', 'DD/MM/YY'), 101);

Question 4

In SQL Developer,DBMS objects are displayed ________.

Accepted Answer

A)  in the Navigation Pane 
B)  in the Object Browser 
C)  in the Connections area 
D)  in the tabbed document window 
E)  in the command tab 
A)  in the Navigation Pane 
B)  in the Object Browser 
C)  in the Connections area 
D)  in the tabbed document window 
E)  in the command tab

Question 5

What is imported from Excel in order to populate an Oracle Database XE Table?

Accepted Answer

A)  Key 
B)  Workbook 
C)  Macro 
D)  Worksheet 
E)  All of the above 
A)  Key 
B)  Workbook 
C)  Macro 
D)  Worksheet 
E)  All of the above

Question 6

What is an SQL script,and why are SQL scripts useful?

Accepted Answer

An SQL Script is a group of SQL statemen

Question 7

The Oracle Database ODBC Client is automatically installed when Oracle Database XE is installed.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Describe how to create and run an SQL query in Oracle Database XE 11g Release 2.

Accepted Answer

In Oracle Database XE 11g Release 2,SQL

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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)  Both A and B 
E)  A, B and C 
A)  SYSTEM 
B)  EXTERNAL 
C)  INTERNAL 
D)  Both A and B 
E)  A, B and C

Question 13

The CurrVal method provides the current value in a sequence.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

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

Question 16

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)  Both 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)  Both A and B 
E)  A, B and C

Question 17

Oracle 12c is a/an ________ class DBMS.

Accepted Answer

The answer of Oracle 12c is a/an ________ class DBMS....

Question 18

When Oracle Database XE 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 19

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

Accepted Answer

A) True 
 B)False

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

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

What is the Oracle Database 11g XE utility?

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?

In SQL Developer,DBMS objects are displayed ________.

What is imported from Excel in order to populate an Oracle Database XE Table?

What is an SQL script,and why are SQL scripts useful?

The Oracle Database ODBC Client is automatically installed when Oracle Database XE is installed.

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

Describe how to create and run an SQL query in Oracle Database XE 11g Release 2.

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

SQL query results are displayed ________.

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?

The CurrVal method provides the current value in a sequence.

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

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

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

Oracle 12c is a/an ________ class DBMS.

When Oracle Database XE is installed,the Oracle Database ODBC client is ________.

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

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

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters

Exam 10: Learn how to create a database in Oracle Database XE 11g Release 2

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

What is the Oracle Database 11g XE utility?

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?

In SQL Developer,DBMS objects are displayed ________.

What is imported from Excel in order to populate an Oracle Database XE Table?

What is an SQL script,and why are SQL scripts useful?

The Oracle Database ODBC Client is automatically installed when Oracle Database XE is installed.

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

Describe how to create and run an SQL query in Oracle Database XE 11g Release 2.

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

SQL query results are displayed ________.

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?

The CurrVal method provides the current value in a sequence.

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

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

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

Oracle 12c is a/an ________ class DBMS.

When Oracle Database XE is installed,the Oracle Database ODBC client is ________.

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

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

Data Warehouses,Business Intelligence Systems,and Big Data

Learn how to create a database in SQL Server 2016

Learn how to create a database in MySQL 5.7 Community Server Edition

Introduce the topic of importing Microsoft Excel 2016 data into a database table

To be able to create a statement of work (SOW)

Learn how to create E-R data models in Microsoft Visio 2016

Learn how to create Microsoft Access 2016 switchboards

Know how to configure and update PHP

Learn the basic concepts of business intelligence (BI)systems

Learn about replicated partitioned data stores for supporting clusters

Filters