SELECT*FROMDEPT;
SELECT*FROMSCOTT.DEPT;
SELECT*FROMDBASCOTTDEPT;
SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
第1题:
Scott issues the SQL statements:CREATE TABLE dept(deptno NUMBER(2),dname VARCHAR2(14),loc VARCHAR2(13)};GRANT SELECTON DEPTT0 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‘;;
第2题:
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCHAR2(14), loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT What is true about the set?()
第3题:
Given the following requirements: Create a table to contain employee data, with a unique numeric identifier automatically assigned when a row is added, has an EDLEVEL column that permits only the values 'C', 'H' and 'N', and permits inserts only when a corresponding value for the employee's department exists in the DEPARTMENT table. Which of the following CREATE statements will successfully create this table?()
第4题:
For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()
第5题:
The DBA issues this SQL command:CREATE USER scott IDENTIFIED by tiger;What privileges does the user Scott have at this point?()
第6题:
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?()
第7题:
Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?()
第8题:
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table? ()
第9题:
no privileges
only the SELECT privilege
only the CONNECT privilege
all the privileges of a default user
第10题:
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
CREATE TABLE EMP (empno NUMBER(4), ename VARCHAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
第11题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第12题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupies by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第13题:
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第14题:
下面哪一个SQL语句将删除DEPT表中的所有数据,并永久删除DEPT表的整个结构()
第15题:
The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedureto many database users: CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgrNUMBER, v_loc NUMBER)BEGIN INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END; The users having permission to execute the procedure are able to insert records into the DEPARTMENTS tableeven though they do not have the INSERT privilege on the table. You want only those users who haveprivileges on the DEPARTMENTS table to be able to execute the procedure successfully. What would yousuggest to the PL/SQL developers to achieve this()
第16题:
You created the DEPT table by using the following command: CREATE TABLE scott.dept (deptno NUMBER(3), dname VARCHAR2(15), loc VARCHAR2(15) ) STORAGE (INITIAL 100K NEXT 50K MAXEXTENTS 10 PCTINCREASE 5 FREELIST GROUPS 6 FREELISTS 4);You are required to shrink the DEPT table. While performing the shrink operation, you want to ensure that the recovered space is returned to the tablespace in which the DEPT table is stored. You do not want to shrink the indexes created on the DEPT table. What will you do to shrink the SCOTT.EMP table?()
第17题:
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?()
第18题:
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()
第19题:
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?()
第20题:
SELECT*FROMDEPT;
SELECT*FROMSCOTT.DEPT;
SELECT*FROMDBASCOTTDEPT;
SELECT*FROMALL_USERSWHEREUSER_NAME=';SCOTT';ANDTABLENAME=';DEPT';;
第21题:
The DESCRIBE DEPT statement displays the structure of the DEPT table.
The ROLLBACK statement frees the storage space occupied by the DEPT table.
The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第22题:
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE COMPACT; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE; statement.
Issue the ALTER TABLE SCOTT.DEPT SHRINK SPACE CASCADE; statement.
You cannot shrink the SCOTT.EMP table.
第23题:
You cannot roll back this statement.
All pending transactions are committed.
All views based on the DEPT table are deleted.
All indexes based on the DEPT table are dropped.
All data in the table is deleted, and the table structure is also deleted.
All data in the table is deleted, but the structure of the table is retained.
All synonyms based on the DEPT table are deleted.
第24题:
CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));