1Z0-007單項選擇題每日一練(2020.05.19)

來源：考試資料網(wǎng)

1 The EMPLOYEE tables has these columns:
LAST_NAME VARCHAR2(35)
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(5,2)
You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column.
Which SQL statement displays the desired results?（）

點(diǎn)擊查看答案&解析

2 Which is a valid CREATE TABLE statement?（）

點(diǎn)擊查看答案&解析

3 Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? （）

點(diǎn)擊查看答案&解析

4 Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
DEPARTMENT_ID NUMBER
SALARY NUMBER
What is the correct syntax for an inline view? （）

點(diǎn)擊查看答案&解析

5 User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?（）

點(diǎn)擊查看答案&解析