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(150)
CUST_PHONE VARCHAR2(20)
Which SELECT statement accomplishes this task?()
A. SELECT* FROM customers;
B. SELECT name, address FROM customers;
C. SELECT id, name, address, phone FROM customers;
D. SELECT cust_name, cust_address FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
您可能感兴趣的试卷
你可能感兴趣的试题
A. DELETE employees;
B. DESCRIBE employees;
C. ROLLBACK TO SAVE POINT C;
D. GRANT SELECT ON employees TO SCOTH
E. ALTER TABLE employees SET UNUSED COLUMN sal;
F. Select MAX(sal) FROM employees WHERE department _ id 20;
The DBA issues this SQL command:
CREATE USER scott
IDENTIFIES by tiger;
What privileges does the user Scott have at this point?()
A. No privileges.
B. Only the SELECT privilege.
C. Only the CONNECT privilege.
D. All the privileges of a default user.
The EMPLOYEES table has these columns:
LAST NAME VARCHAR2(35)
SALARY NUMBER(8,2)
HIRE_DATE DATE
Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:
ALTER TABLE EMPLOYEES
MODIFY ( SALARY DEFAULT 5000);
What is true about your ALTER statement?()
A. Column definitions cannot be altered to add DEFAULT values.
B. A change to the DEFAULT value affects only subsequent insertions to the table.
C. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type.
D. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
Examine the data in the EMPLOYEES table.
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column.
Evaluate this DELETE statement:
Why does the DELETE statement fail when you execute it?()
A. There is no row with dept_id 90 in the EMPLOYEES table.
B. You cannot delete the JOB_ID column because it is a NOT NULL column.
C. You cannot specify column names in the DELETE clause of the DELETE statement.
D. You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
A.&
B.ACCEPT
C.PROMPT
D.&&
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.
E.It allows the grantee to grant object privileges to other users and roles.
The EMP table has these columns:
Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?()
A. SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;
B. SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;
C. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;
D. SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;
A.UNIQUE
B.NOT NULL
C.CHECK
D.PRIMARY KEY
E.FOREIGN KEY
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 highest salary for all employees.
D. You want to rank the top three sales representatives who have sold the maximum number of products.
A. You cannot use IN operator in a condition that involves an outerjoin.
B. You use (+) on both sides of the WHERE condition to perform an outerjoin.
C. You use (*) on both sides of the WHERE condition to perform an outerjoin.
D. You use an outerjoin to see only the rows that do not meet the join condition.
E. In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
F. You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
最新试题
In which two cases would you use an outer join? ()
Which two are true about aggregate functions?()
Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? ()
A SELECT statement can be used to perform these three functions:1. Choose rows from a table.2. Choose columns from a table3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities? ()
Which four are types of functions available in SQL? ()
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database. Which SQL statement can Mary use to accomplish that task?()
Which view should a user query to display the columns associated with the constraints on a table owned by the user? ()
Which is a valid CREATE TABLE statement? ()
Which is an iSQL*Plus command? ()
The PRODUCTS table has these columns:PRODUCT_ID NUMBER(4)PRODUCT_NAME VARCHAR2(45)PRICE NUMBER(8,2)Evaluate this SQL statement:SELECT *FROM PRODUCTSORDER BY price, product _ name;What is true about the SQL statement? ()