Question 1

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 2

Oracle Database 11g Release 2 uses ________ to generate surrogate keys.

Accepted Answer

The answer of Oracle Database 11g Release 2 uses ________...

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)  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.

In SQL Developer,DBMS objects are displayed:

Oracle Database 11g Release 2 uses ________ to generate surrogate keys.

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?

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

In SQL Developer,DBMS objects are displayed:

Oracle Database 11g Release 2 uses ________ to generate surrogate keys.

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?

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