General

Question 1

How to I get the endian format for a given OS?

Answer 1

select * from v$transportable_platform;

Question 2

How to get the platform information that your database is on?

Answer 2

select 
   name, 
   platform_id,
   platform_name 
from 
   v$database;

Question 3

What is needed to transport a tablespace from one platform to another (to a different OS)?

Answer 3

Datafiles on different platforms must be in the same endian format (byte ordering).
The pattern for byte ordering in native types is called endianness. There are only two main patterns, big endian and little endian. Big endian means the most significant byte comes first, and little endian means the least significant byte comes first.

Question 4

True or False: A schema object name in Oracle must begin with an alphabetical character and can be 1 to 128 characters long.

Answer 4

False. Schema object names cannot be more than 30 characters long.

Question 5

What keyword is used to specify a Cartesian join?

Answer 5

CROSS JOIN

Question 6

When writing queries with OUTER JOIN, in which clause should you specify the plus (+) operator?

Answer 6

The WHERE clause

Question 7

True or False: Both the CREATE TABLE and ALTER TABLE statements can be used to create a primary key for a table.

Answer 7

True

Question 8

In the physical relational model, each entity becomes a and attributes of the entity become . The relationship between the entities in relational design is a constraint.

Answer 8

Table, columns, foreign key

Question 9

What is the name of the architecture that guarantees high availability of Oracle Database 12c by eliminating single-point-of-server failure?

Answer 9

Real Application Clusters (RAC)

Question 10

The dictionary view has information about all constraints owned by a user. To represent foreign key constraints, the view’s CONSTRAINT TYPE column will have a value of .

Answer 10

USER CONSTRAINTS; R

Question 11

True or False: The statement ALTER TABLE EMP MODIFY CONSTRAINT FK EMP ENABLE can be used to enable a foreign key constraint FK EMP on table EMP.

Answer 11

True

Question 12

Is the following statement true regarding foreign key constraints? The column datatypes of dependent and referenced tables must match and they cannot be NULL.

Answer 12

The statement is False. The columns used in the foreign key constraint can be NULL.

Question 13

True or False: When you truncate a table that has enabled foreign key references, the child table is also truncated.

Answer 13

True (constraint must be defined with the ON DELETE CASCADE option)

Question 14

True or False: The NATURAL and CROSS join types cannot be outer joins.

Answer 14

True

Question 15

When you specify the DESC keyword in the ORDER BY clause, how are the NULL values sorted by default?

Answer 15

NULLs appear first. To display NULLs at the end, use NULLS LAST clause.