当前分类： 1Z0-007
问题：单选题Which is an iSQL*Plus command? （）A INSERTB UPDATEC SELECTD DESCRIBEE DELETEF RENAME...
查看答案
问题：多选题Which two statements accurately describe a role? （）AA role can be given to a maximum of 1000 users.BA user can have access to a maximum of 10 roles.CA role can have a maximum of 100 privileges contained in it.DPrivileges are given to a role by using th...
问题：单选题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 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...
问题：单选题The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTM...
问题：单选题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 is true about the WITH GRANT OPTION clause?（）A It allows a grantee DBA privileges.B It is required syntax for object privileges.C It allows privileges on specified columns of tables.D It is used to grant an object privilege on a foreign key column...
问题：Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题：Examine the description of the MARKS table: STD_ID NUMBER(4)...
问题：单选题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...
问题：单选题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?（）A SELECT employee_id, last_name, job_...
问题：Evaluate this SQL statement: SELECT e.employee_id, (.15* e.s...
问题：单选题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...
问题：多选题Which three statements inserts a row into the table?（）AINSERT INTO employees VALUES ( NULL, ‘John’,‘Smith’);BINSERT INTO employees( first_name, last_name) VALUES(‘John’,‘Smith’);CINSERT INTO employees VALUES (‘1000’,‘John’,NULL);DINSERT INTO employees(...
问题：单选题Which clause should you use to exclude group results?（）A WHEREB HAVINGC RESTRICTD GROUP BYE ORDER BY...
问题：多选题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-...
问题：多选题Which four are types of functions available in SQL? （）AstringBcharacterCintegerDcalendarEnumericFtranslationGdateHconversion...
问题：Evaluate the SQL statement DROP TABLE DEPT: Which four state...
问题：多选题Examine the statement: GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION; Which two are true?（）AMANAGER must be a role.BIt allows the MANAGER to pass the specified privileges on to other users.CIt allows the MANAGER to create ...
