Question 1

Which of the following keywords will return the value of the date according to the computer?

Accepted Answer

A)  SYSTEMDATE 
B)  SYSDATE 
C)  DATE 
D)  DATESYS 
A)  SYSTEMDATE 
B)  SYSDATE 
C)  DATE 
D)  DATESYS B

Question 2

Which of the following format model elements can be used to spell out a number?

Accepted Answer

A)  TH 
B)  STRING 
C)  SP 
D)  SP# 
A)  TH 
B)  STRING 
C)  SP 
D)  SP# C

Question 3

The $\underline {\text { NEXT DATE } }$ function is used to determine the next occurrence of a specific day of the week after a given date. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

Which of the following represents the number of days that have passed since January 1, 4712 B.C.?

Accepted Answer

A)  Cartesian date 
B)  Julian date 
C)  Extended date 
D)  none of the above 
A)  Cartesian date 
B)  Julian date 
C)  Extended date 
D)  none of the above

Question 5

Which of the following functions will truncate a numeric value to a specific position?

Accepted Answer

A)  TRUNCATE 
B)  TRUNC 
C)  TRUND 
D)  none of the above 
A)  TRUNCATE 
B)  TRUNC 
C)  TRUND 
D)  none of the above

Question 6

Contents of the CUSTOMERS table
   
Note: The ST column name is truncated, this represents the STATE column.
-Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip

Accepted Answer

A)  SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state,
CONCAT(' ', zip)))))
FROM customers; 
B)  SELECT CONCAT(city, CONCAT(', ', CONCAT(state,
CONCAT(' ', CONCAT(zip)))))
FROM customers; 
C)  SELECT INITCAP(CONCAT(city, ', ', state, ' ', zip))
FROM customers; 
D)  none of the above 
A)  SELECT INITCAP(CONCAT(city, CONCAT(', ', CONCAT(state,
CONCAT(' ', zip)))))
FROM customers; 
B)  SELECT CONCAT(city, CONCAT(', ', CONCAT(state,
CONCAT(' ', CONCAT(zip)))))
FROM customers; 
C)  SELECT INITCAP(CONCAT(city, ', ', state, ' ', zip))
FROM customers; 
D)  none of the above

Question 7

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

Accepted Answer

A)  DDD 
B)  DD 
C)  DAY 
D)  DY 
A)  DDD 
B)  DD 
C)  DAY 
D)  DY

Question 8

LOWER, UPPER, and INITCAP functions are all character manipulation functions.

Accepted Answer

A) True 
 B)False

Question 9

The ____________________ function allows a user to enter a date in a variety of formats, and then changes the value to the default Oracle11g internal storage format.

Accepted Answer

The answer of The ____________________ function allows a user to...

Question 10

Include $\underline {\text { DAY } }$ in a format argument of the TO_CHAR function to spell out the day of the week in the specified date. _________________________

Accepted Answer

A) True 
 B)False

Question 11

The ____________________ function is used to round numeric fields to a stated position.

Accepted Answer

The answer of The ____________________ function is used to round...

Question 12

The LENGTH function is used to determine the number of rows in a table.

Accepted Answer

A) True 
 B)False

Question 13

The phonetic representation of a character string can be determined using the ____ function.

Accepted Answer

A)  SOUND 
B)  PHONETIC 
C)  SOUNDEX 
D)  SOUNDINDEX 
A)  SOUND 
B)  PHONETIC 
C)  SOUNDEX 
D)  SOUNDINDEX

Question 14

The INSTR function is used to return a portion of a character string.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

Accepted Answer

The answer of A(n) ____________________ is a predefined block of...

Question 16

The $\underline { \text { SUBSTR } }$ function is used to substitute one character string for another in a set of data. _________________________

Accepted Answer

A) True 
 B)False

Question 17

The ____________________ function fills the area to the right of a character string with a specific character.

Accepted Answer

The answer of The ____________________ function fills the area to...

Question 18

The ____________________ keyword is used to return the value of the date according to the computer.

Accepted Answer

The answer of The ____________________ keyword is used to return...

Question 19

The $\underline {\text { SOUND } }$ function is used to determine the phonetic representation of a character string. _________________________

Accepted Answer

A) True 
 B)False

Question 20

The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

Accepted Answer

The answer of The ____________________ function is used to replace...

Which of the following keywords will return the value of the date according to the computer?

Which of the following format model elements can be used to spell out a number?

The $\underline {\text { NEXT DATE } }$ function is used to determine the next occurrence of a specific day of the week after a given date. _________________________

Which of the following represents the number of days that have passed since January 1, 4712 B.C.?

Which of the following functions will truncate a numeric value to a specific position?

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

LOWER, UPPER, and INITCAP functions are all character manipulation functions.

The ____________________ function allows a user to enter a date in a variety of formats, and then changes the value to the default Oracle11g internal storage format.

Include $\underline {\text { DAY } }$ in a format argument of the TO_CHAR function to spell out the day of the week in the specified date. _________________________

The ____________________ function is used to round numeric fields to a stated position.

The LENGTH function is used to determine the number of rows in a table.

The phonetic representation of a character string can be determined using the ____ function.

The INSTR function is used to return a portion of a character string.

A(n) ____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

The $\underline { \text { SUBSTR } }$ function is used to substitute one character string for another in a set of data. _________________________

The ____________________ function fills the area to the right of a character string with a specific character.

The ____________________ keyword is used to return the value of the date according to the computer.

The $\underline {\text { SOUND } }$ function is used to determine the phonetic representation of a character string. _________________________

The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

Exam 10: Selected Single Row Functions

Which of the following keywords will return the value of the date according to the computer?

Which of the following format model elements can be used to spell out a number?

The NEXT DATE ‾\underline {\text { NEXT DATE } } NEXT DATE ​ function is used to determine the next occurrence of a specific day of the week after a given date. _________________________

Which of the following represents the number of days that have passed since January 1, 4712 B.C.?

Which of the following functions will truncate a numeric value to a specific position?

Contents of the CUSTOMERS table Note: The ST column name is truncated, this represents the STATE column. -Based upon the contents of the CUSTOMERS table, which of the following will display the shipping location as: City, State Zip

Which of the following format elements can be used to display the three-letter abbreviation for Wednesday?

LOWER, UPPER, and INITCAP functions are all character manipulation functions.

The ____________________ function allows a user to enter a date in a variety of formats, and then changes the value to the default Oracle11g internal storage format.

Include DAY ‾\underline {\text { DAY } } DAY ​ in a format argument of the TO_CHAR function to spell out the day of the week in the specified date. _________________________

The ____________________ function is used to round numeric fields to a stated position.

The LENGTH function is used to determine the number of rows in a table.

The phonetic representation of a character string can be determined using the ____ function.

The INSTR function is used to return a portion of a character string.

A(n) ____________________ is a predefined block of code that accepts one or more arguments and returns a single value as output.

The SUBSTR ‾\underline { \text { SUBSTR } } SUBSTR ​ function is used to substitute one character string for another in a set of data. _________________________

The ____________________ function fills the area to the right of a character string with a specific character.

The ____________________ keyword is used to return the value of the date according to the computer.

The SOUND ‾\underline {\text { SOUND } } SOUND ​ function is used to determine the phonetic representation of a character string. _________________________

The ____________________ function is used to replace a specific set of characters found within a character string with another set of characters.

Overview of Database Concepts

Basic Sql Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Group Functions

Subqueries and Merge Statements

Views

Filters

The $\underline {\text { NEXT DATE } }$ function is used to determine the next occurrence of a specific day of the week after a given date. _________________________

Include $\underline {\text { DAY } }$ in a format argument of the TO_CHAR function to spell out the day of the week in the specified date. _________________________

The $\underline { \text { SUBSTR } }$ function is used to substitute one character string for another in a set of data. _________________________

The $\underline {\text { SOUND } }$ function is used to determine the phonetic representation of a character string. _________________________