问题:单选题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 The second statement returns a syntax error.C There is no need to specify DESC because the results are sorted in descending order by default.D The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
Thursday, March 23, 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) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?()A WHERE lower(country_address) = franceB WHERE lower(country_address) = 'france'C WHERE lower(country_address) IS 'france'D WHERE lower(country_address) = '%france%'E WHERE lower(country_address) LIKE %france%
Thursday, September 22, 2022
问题:单选题Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()A SELECT ename, salary*12 ‘Annual Salary’ FROM employees;B SELECT ename, salary*12 “Annual Salary” FROM employees;C SELECT ename, salary*12 AS Annual Salary FROM employees;D SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees
Friday, September 16, 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
问题:多选题Which two statements about subqueries are true?()AA single row subquery can retrieve data from only one table.BA SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.CA SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.DA single row subquery can retrieve data from more than one table.EA single row subquery cannot be used in a condition where the LIKE operator is used for comparison.FA multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
问题:多选题Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()AYou cannot roll back this statement.BAll pending transactions are committed.CAll views based on the DEPT table are deleted.DAll indexes based on the DEPT table are dropped.EAll data in the table is deleted, and the table structure is also deleted.FAll data in the table is deleted, but the structure of the table is retained.GAll synonyms based on the DEPT table are deleted.
问题:多选题Which three statements about subqueries are true? ()AAsinglerowsubquerycanretrieveonlyonecolumnandonerow.BAsinglerowsubquerycanretrieveonlyonerowbutmanycolumns.CAmultiplerowsubquerycanretrievemultiplerowsandmultiplecolumns.DAmultiplerowsubquerycanbecomparedusingthe;>;;operator.EAsinglerowsubquerycanusetheINoperator.FAmultiplerowsubquerycanusethe;=;operator.
Sunday, December 31, 2023
问题:单选题Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.dept_id, b.maxsal 2 FROM employees a, 3 (SELECT dept_id, MAX(sal) maxsal 4. FROM employees 5 GROUP BY dept_id) b 6 WHERE a.dept_id = b.dept_id 7 AND a. asl < b. maxsal; What is the result of the statement?()A The statement produces an error at line 1.B The statement produces an error at line 3.C The statement produces an error at line 6.D The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.E The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
问题:单选题You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows. Which statement is valid?()A ALTER TABLE commercials MODIFY (description CHAR2(2000));B ALTER TABLE commercials CHANGE (description CHAR2(2000));C ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));D ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));E You cannot increase the size of a column if the table has rows.
问题:单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()A USER_TAB_PRIVS_MADEB USER_TAB_PRIVSC USER_COL_PRIVS_MADED USER_COL_PRIVS
Wednesday, December 7, 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
问题:多选题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 single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.EYou can use aggregate functions on a table, only by grouping the whole table as one single group.FYou cannot group the rows of a table by more than one column while using aggregate functions.
Tuesday, September 20, 2022
问题:多选题Which four are correct guidelines for naming database tables? ()AMust begin with either a number or a letter.BMust be 1-30 characters long.CShould not be an Oracle Server reserved word.DMust contain only A-Z, a-z, 0-+, _, *, and #.EMust contain only A-Z, a-z, 0-9, _, $, and #.FMust begin with a letter.
问题:单选题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) POSTAL_CODE VARCHAR2(12) CUSTOMER_PHONE VARCHAR2(20) Which statement finds the rows in the CUSTOMERS table that do not have a postal code?()A SELECT customer_id, customer_name FROM customers WHERE postal_code CONTAINS NULL;B SELECT customer_id, customer_name FROM customers WHER postal_code = ' ___________';C SELECT customer_id, customer_name FROM customers WHERE postal _ code IS NULL;D SELECT customer_id, customer_name FROM customers WHERE postal code IS NVL;E SELECT customer_id, customer_name FROM customers WHERE postal_code = NULL;
问题:单选题What is true about joining tables through an equijoin? ()A You can join a maximum of two tables through an equijoin.B You can join a maximum of two columns through an equijoin.C You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.D To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.E You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
Sunday, September 18, 2022
问题:多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion
问题:单选题Which iSQL*Plus feature can be used to replace values in the WHERE clause?()A substitution variablesB replacement variablesC prompt variablesD instead-of variablesE This feature cannot be implemented through iSQL*Plus.
问题:单选题The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) ENAME VARCHAR2 (25) JOB_ID VARCHAR2(10) Which SQL statement will return the ENAME, length of the ENAME, and the numeric position of the letter "a" in the ENAME column, for those employees whose ENAME ends with a the letter "n"?()A SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, 'a') FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';B SELECT ENAME, LENGTH(ENAME), INSTR(ENAME, ,-1,1) FROM EMPLOYEES WHERE SUBSTR (ENAME, -1,1) = 'n';C SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, 1,1) = 'n';D SELECT ENAME, LENGTH(ENAME), SUBSTR(ENAME, -1,1) FROM EMPLOYEES WHERE INSTR (ENAME, -1,1) = 'n';
Friday, April 28, 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
问题:多选题What are two reasons to create synonyms? ()AYou have too many tables.BYour tables are too long.CYour tables have difficult names.DYou want to work on your own tables.EYou want to use another schema's tables.FYou have too many columns in your tables.
Saturday, September 17, 2022