최신Oracle MySQL 8.0 Database Developer - 1z1-909무료샘플문제
문제1
You must enforce data integrity for data Inserted in a JSON column.
Which statement successfully creates a constraint in a 3SON column?
You must enforce data integrity for data Inserted in a JSON column.
Which statement successfully creates a constraint in a 3SON column?
정답: B
문제2
Your session has sqi_mode set to default.
Examine this statement which executes successfully:
Now examine this statement:
Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date
Your session has sqi_mode set to default.
Examine this statement which executes successfully:
Now examine this statement:
Which two changes are required to the insert statement so that it inserts the correct data?
* std_id = 10301
* firstname = Mary
* lastname = O'Hagen
* birthdate = November 26, 1997
* reg_date = the current date
정답: C,E
문제3
Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?
Examine these commands which execute successfully:
mYsql> CREATE TABLE income (acct_num INT, amount DECIMAL(10,2));
mysql> CREATE TRIGGER subtotal BEFORE INSERT ON income
FOR EACH ROW SET @subtotal = subtotal + NEW.amount;
Which is true for the income table?
정답: C
문제4
Examine these statements issued from Session 1 which execute successfully:
Now, examine this statement issued from Session 2:
What is the outcome of the update statement in Session 2?
Examine these statements issued from Session 1 which execute successfully:
Now, examine this statement issued from Session 2:
What is the outcome of the update statement in Session 2?
정답: B
문제5
Examine these lines of Python code:
You must add a line of code to complete the code to return data to the variable d. Which line will do this?
Examine these lines of Python code:
You must add a line of code to complete the code to return data to the variable d. Which line will do this?
정답: E
문제6
Which two are true about indexes?
Which two are true about indexes?
정답: B,D
문제7
The variables c and d are declared as integer types.
Examine these initialization statements with placeholder value <p1>, which execute successfully:
Now, examine this loop which executes successfully:
Which loop results in the same value of d for all valid values of <p1>?
A)
B)
C)
The variables c and d are declared as integer types.
Examine these initialization statements with placeholder value <p1>, which execute successfully:
Now, examine this loop which executes successfully:
Which loop results in the same value of d for all valid values of <p1>?
A)
B)
C)
정답: C