The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results? ()
时间:2022-09-26
For which two constraints does the Oracle Server implicitly create a unique index? ()
Which two statements about sequences are true? ()
Which three statements about subqueries are true?()
时间:2022-09-25
Which two statements about subqueries are true? ()
Which three are DATETIME data types that can be used when specifying column definitions? ()
The DBA issues this SQL command: CREATE USER scott IDENTIFIES by tiger; What privileges does the user Scott have at this point? ()
时间:2022-09-24
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2 (25) LAST_NAME VARCHAR2 (25) HIRE_DATE DATE Which UPDATE statement is valid? ()
Examine the data in the EMPLOYEES table: https://assets.asklib.com/images/image2/2018080114531692453.jpg Which three subqueries work?()
时间:2022-09-23
Which four are correct guidelines for naming database tables? ()
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?()
You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU?()
时间:2022-09-22
Which three SELECT statements displays 2000 in the format "$2,000.00"? ()
Which two statements are true about constraints? ()
Which statement creates a new user?()
时间:2022-09-21