问题:The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4)...
查看答案
问题:单选题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 ...
问题:Which statement accomplish this? ()...
问题:Which four are correct guidelines for naming database tables...
问题:Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX...
问题:多选题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 F...
问题:多选题The ORDERS table has these columns: ORDER_ID NUMBER(4) NOT NULL CUSTOMER_ID NUMBER(12) NOT NULL ORDER_TOTAL NUMBER(10,2) The ORDERS table tracks the Order number, the order total, and the customer to whom the Order belongs. Which two statements retriev...
问题:单选题Which describes the default behavior when you create a table? ()A The table is accessible to all users.B Tables are created in the public schema.C Tables are created in your schema.D Tables are created in the DBA schema.E You must specify the schema wh...
问题:单选题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...
问题:In a SELECT statement that includes a WHERE clause, where is...
问题:In which scenario would an index be most useful?()...
问题:单选题Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign ...
问题:单选题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...
问题:Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题:单选题Which are iSQL*Plus commands? ()A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
问题:多选题Which four are types of functions available in SQL? ()AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题:多选题Which two statements are true about constraints? ()AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a...
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题:单选题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...
问题:单选题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...