[2026] Oracle Database: SQL Fundamentals I - 1Z1-051 무료 시험 문제

문제1

Which four are types of functions available in SQL? (Choose 4)

A. numeric

B. integer

C. conversion

D. character

E. date

F. translation

G. calendar

H. string

정답: A,C,D,E

설명: (Fast2test 회원만 볼 수 있음)

문제2

The CUSTOMERS table has these columns: A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

A. WHERE lower(country_address) = 'france'

B. WHERE lower(country_address) IS 'france'

C. WHERE lower(country_address) = "france"

D. WHERE lower(country_address) LIKE %france%

E. WHERE lower(country_address) = '%france%'

정답: A

설명: (Fast2test 회원만 볼 수 있음)

문제3

Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)

A. A maximum of one pair of columns can be joined between two tables using the ON clause

B. The ON clause can be used to join tables on columns that have different names but compatible data types

C. Both USING and ON clause can be used for equijoins and nonequijoins

D. The WHERE clause can be used to apply additional conditions in SELECT statementcontaining the ON or the USING clause

정답: B,D

설명: (Fast2test 회원만 볼 수 있음)

문제4

View the Exhibit and examine the data in the PROMO_NAME and PROMO_END_DATE columns of the PROMOTIONS table, and the required output format.

Which two queries give the correct result? (Choose two.)

A. SELECT promo_name, TO_CHAR(promo_end_date,'Day') ', '
TO_CHAR(promo_end_date,'Month') ' '
TO_CHAR(promo_end_date,'DD, YYYY') AS last_day
FROM promotions;

B. SELECTpromo_name,TO_CHAR(promo_end_date,'fmDay')','
TO_CHAR(promo_end_date,'fmMonth') ' '
TO_CHAR(promo_end_date,'fmDD, YYYY') AS last_day
FROM promotions;

C. SELECT promo_name,TO_CHAR (promo_end_date,'fxDay') ', '
TO_CHAR(promo_end_date,'fxMonth') ' '
TO_CHAR(promo_end_date,'fxDD, YYYY') AS last_day
FROM promotions;

D. SELECT promo_name, TRIM(TO_CHAR(promo_end_date,'Day')) ', ' TRIM(TO_CHAR
(promo_end_date,'Month')) ' '
TRIM(TO_CHAR(promo_end_date,'DD, YYYY')) AS last_day
FROM promotions;

정답: B,D

문제5

Which two statements are true regarding constraints? (Choose two.)

A. Both primary key and foreign key constraints can be defined at both column and table levels.

B. A table can have only one primary key and one foreign key.

C. The foreign key and parent table primary key must have the same name.

D. Only the primary key can be defined at the column and table levels.

E. A table can have only one primary key but multiple foreign keys.

정답: A,E

문제6

The following data exists in the PRODUCTS table:
PROD_ID PROD_LIST_PRICE
123456 152525.99
You issue the following query:
SQL> SELECT RPAD(( ROUND(prod_list_price)), 10,'*')
FROM products
WHERE prod_id = 123456; What would be the outcome?

A. an error message

B. 152526****

C. **152525.99

D. 152525**

정답: B

설명: (Fast2test 회원만 볼 수 있음)

문제7

Which tasks can be performed using SQL functions that are built into Oracle database? (Choose three.)

A. checking whether a specified character exists in a given string

B. finding the remainder of a division

C. comparing two expressions to check whether they are equal

D. removing trailing, leading, and embedded characters from a character string

E. adding a number to a date for a resultant date value

정답: A,B,C

문제8

You want to display the date for the first Monday of the next month and issue the following command:
SQL>SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'), 'dd "is the first Monday for"fmmonth rrrr') FROM DUAL;
What is the outcome?

A. It generates an error because TO_CHAR should be replaced with TO_DATE.

B. It executes successfully but does not return the correct result.

C. It executes successfully and returns the correct result.

D. It generates an error because fm and double quotation marks should not be used in the format string.

E. It generates an error because rrrr should be replaced by rr in the format string.

정답: C

설명: (Fast2test 회원만 볼 수 있음)

문제9

You created an ORDERS table with the following description:
Exhibit:

You inserted some rows in the table. After some time, you want to alter the table by creating the PRIMARY KEY constraint on the ORD_ID column.
Which statement is true in this scenario?

A. You cannot have two constraints on one column

B. The primary key constraint can be created only a the time of table creation

C. You can add the primary key constraint even if data exists, provided that there are no duplicate values

D. You cannot add a primary key constraint if data exists in the column

정답: C

Oracle Database: SQL Fundamentals I - 1Z1-051무료 덤프문제 풀어보기

우리와 연락하기

유용한 링크

최신 업데이트