问题:单选题Scott issues the SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)}; GRANT SELECT ON DEPT T0 SUE; If Sue needs to select from Scott's DEPT table, which command should she use?()A SELECT*FROMDEPT;B SELECT*FROMSCOTT.DEPT;C SELECT*FROMDBASCOTTDEPT;D SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
查看答案
问题:单选题What is necessary for your query on an existing view to execute successfully?()A The underlying tables must have data.B You need SELECT privileges on the view.C The underlying tables must be in the same schema.D You need SELECT privileges only on the underlying tables.
问题:多选题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 two statements about creating constraints are true? ()AConstraint names must start with SYS_CBAll constraints must be defines at the column levelCConstraints can be created after the table is createdDConstraints can be created at the same time the table is createdEInformation about constraints is found in the VIEW_CONSTRAINTS dictionary view
问题:单选题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
问题:单选题Which statement creates a new user? ()A CREATIVE USER susan;B CREATIVE OR REPLACE USER susan;C CREATE NEW USER susan DEFAULTD CREATE USER susan IDENTIFIED BY blue;E CREATE NEW USER susan IDENTIFIED BY blue;F CREATE OR REPLACE USER susan IDENTIFIED BY blue;
问题:单选题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_id FROM employees WHERE job_id LIKE '%SA/_%'ESCAPE'/';B SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';C SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'/';D SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';
问题:多选题Which two are attributes of /SQL*Plus? ()A/SQL*Plus commands cannot be abbreviated.B/SQL*Plus commands are accesses from a browser.C/SQL*Plus commands are used to manipulate data in tables.D/SQL*Plus commands manipulate table definitions in the database.E/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
问题:单选题In which case would you use a FULL OUTER JOIN?()A Both tables have NULL values.B You want all unmatched data from one table.C You want all matched data from both tables.D You want all unmatched data from both tables.E One of the tables has more data than the other.F You want all matched and unmatched data from only one table.
问题:单选题In which scenario would an index be most useful?()A The indexed column is declared as NOT NULL.B The indexed columns are used in the FROM clause.C The indexed columns are part of an expression.D The indexed column contains a wide range of values.
问题:单选题Which SELECT statement should you use to extract the year from the system date and display it in the format "1998"? ()A SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;B SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;C SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;D SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;E SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
问题:单选题Which SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? ()A SELECT &1, &2 FROM &3 WHERE last_name = '&8';B SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';C SELECT &1, &2 FROM &3 WHERE last_name = '&8';D SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
问题:多选题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.EConstraints prevent the deletion of a table if there are dependencies.FConstraints prevent the deletion of an index if there are dependencies.
问题:单选题The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?()A SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL;B SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;C SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end;D SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades;E SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
问题:单选题What is true about sequences?()A Once created, a sequence belongs to a specific schema.B Once created, a sequence is linked to a specific table.C Once created, a sequence is automatically available to all users.D Only the DBA can control which sequence is used by a certain table.E Once created, a sequence is automatically used in all INSERT and UPDATE statements.
问题:单选题You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP_VU? ()A CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department _ id IN (10,20);B CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH READ ONLY;C CREATE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) WITH CHECK OPTION;D CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WITH department_id IN (10,20);E CREATE FORCE VIEW emp_vu AS SELECT * FROM employees WHERE department_id IN (10,20) NO UPDATE;
问题:单选题Examine the statement:Create synonym emp for hr. employees;What happens when you issue the statement?()A An error is generated.B You will have two identical tables in the HR schema with different names.C You create a table called employees in the HR schema based on you EMP table.D You create an alternative name for the employees table in the HR schema in your own schema.
问题:多选题Examine the data in the EMPLOYEES table: LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 ... Which three subqueries work? ()ASELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department _ id);BSELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department _ id);CSELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department _ id);DSELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department _ id);ESELECT last_name FROM employees Where salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department _ id);FSELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY ANG (SALARY));
问题:单选题Which best describes an inline view?()A a schema objectB a subquery that can contain an ORDER BY clauseC another name for a view that contains group functionsD a subquery that is part of the FROM clause of another query