Which three are true regarding the use of outer joins?()
时间:2022-11-10
Which two are attributes of /SQL*Plus? ()
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? ()
Which four statements correctly describe functions that are available in SQL? ()
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?()
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?()
时间:2022-11-09
Which one is a system privilege? ()
The CUSTOMERS table has these columns: https://assets.asklib.com/images/image2/2018080116181325145.jpg Which statement finds the rows in the CUSTOMERS table that do not have a postal code?()
时间:2022-11-07
Which three statements correctly describe the functions and use of constraints? ()
机房内应有合乎规定的灭火器材,包括()等,并应经常检查,保证其可靠。
What is true of using group functions on columns that contain NULL values?()
时间:2022-11-06
Examine the SQL statements that creates ORDERS table: https://assets.asklib.com/images/image2/201808011530357709.jpg For which columns would an index be automatically created when you execute the above SQL statement? ()
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?()
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? ()
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. https://assets.asklib.com/images/image2/2018080116500849327.jpg For which situation would you use a nonequijoin query?()
时间:2022-11-05