问题：The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...

Thursday, September 22, 2022

问题：Which two statements about subqueries are true? （）...

Thursday, September 15, 2022

问题：多选题Which four are attributes of single row functions? （）Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression...

Saturday, April 27, 2024

问题：Examine the data from the ORDERS and CUSTOMERS tables. ORDER...

Wednesday, September 14, 2022

问题：单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?（）A The two statements produce identical results.B ...

Sunday, August 13, 2023

问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...

Wednesday, December 7, 2022

问题：单选题In which scenario would TOP N analysis be the best solution?（）A You want to identify the most senior employee in the company.B You want to find the manager supervising the largest number of employees.C You want to identify the person who makes the high...

Wednesday, March 8, 2023

问题：单选题Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEESORDER BY 2 DESC; What is true about them?（）A The two statements produce identical results.B ...

Thursday, March 23, 2023

问题：多选题Which two are true about aggregate functions?（）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.CYou can mix...

Saturday, October 7, 2023

问题：单选题What does the TRUNCATE statement do?（）A Removes the tableB Removes all rows from a tableC Shortens the table to 10 rowsD Removes all columns from a tableE Removes foreign keys from a table...

Friday, August 11, 2023

问题：单选题You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMEN...

Tuesday, April 23, 2024

问题：Which are DML statements? （）...

Thursday, September 22, 2022

问题：Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...

Thursday, September 22, 2022

问题：Which four are correct guidelines for naming database tables...

Thursday, September 22, 2022

问题：单选题Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）A 0B 1C 0.00D An error statement...

Wednesday, October 18, 2023

问题：多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements insert a row into the table? （）AINSERT INTO employees VALUES ( NULL, 'John', 'Smith');BINSERT INTO employ...

Tuesday, June 6, 2023

问题：单选题The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL CUSTOMER_NAME VARCHAR2(100) NOT NULL STREET_ADDRESS VARCHAR2(150) CITY_ADDRESS VARCHAR2(50) STATE_ADDRESS VARCHAR2(50) PROVINCE_ADDRESS VARCHAR2(50) COUNTRY_ADDRESS VARCHAR2(50) POST...

Sunday, December 31, 2023

问题：What does the FORCE option for creating a view do?（）...

Saturday, September 17, 2022

问题：单选题Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?（）A 46 and 45B 46 and 45.93C 50 and 45.93D 50 and 45.9E 45 and 45.93F 45.95 and 45.93...

Wednesday, February 8, 2023

问题：Evaluate the SQL statement DROP TABLE DEPT: Which four state...

Thursday, September 22, 2022