当前分类: 1Z0-007
问题:单选题Which statement creates a new user?()A CREATE USER susan;B CREATE OR REPLACE USER susan;C CREATE NEW USER susan DEFAULT;D CREATE USER susan IDENTIFIED BY blue;E CREATE NEW USER susanIDENTIFIED by blue;F CREATE OR REPLACE USER susan IDENTIFIED BY blue;...
查看答案
问题:单选题You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(...
问题:多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) Which three statements inserts a row into the table? ()AINSERT INTO employees VALUES (NULL, 'JOHN','Smith');BINSERT INTO employe...
问题:You need to change the definition of an existing table. The...
问题:单选题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 two statements complete a transaction? ()ADELETE employees;BDESCRIBE employees;CROLLBACK TO SAVEPOINT C;DGRANT SELECT ON employees TO SCOTT;EALTER TABLE employees SET UNUSED COLUMN sal;FSELECT MAX(sal) FROM employees WHERE department_id = 20;...
问题:单选题The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, ...
问题:单选题You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definit...
问题:You are granted the CREATE VIEW privilege. What does this al...
问题:多选题Evaluate the SQL statement:TRUNCATE TABLE DEPT;Which three are true about the SQL statement? ()AIt releases the storage space used by the table.BIt does not release the storage space used by the table.CYou can roll back the deletion of rows after the s...
问题:Which operator can be used with a multiple-row subquery? ()...
问题:Evaluate the SQL statement: 1 SELECT a.emp_name, a.sal, a.de...
问题:多选题Which three statements correctly describe the functions and use of constraints? ()AConstraints provide data independence.BConstraints make complex queries easy.CConstraints enforce rules at the view level.DConstraints enforce rules at the table level.E...
问题:Which two statements about creating constraints are true? ()...
问题:单选题Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statemen...
问题:A SELECT statement can be used to perform these three functi...
问题:Which three are DATETIME data types that can be used when sp...
问题:For which two actions can you use the TO_DATE function? ()...
问题:The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) P...
问题:Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NU...