单选题A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following

题目
单选题
A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）
A

Alias

B

View

C

Schema

D

Trigger

相似考题

1.Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?（）A. User processB. Server processC. System Monitor (SMON)D. Process Monitor (PMON)E. Checkpoint process (CKPT)

2.Given the following table definitions:EMPLOYEEID NAME DEPTID01Smith 1002Bossy 2003 20Peterson04Goss 3005Pape 4006Avery 5007O‘Neal 6008Carter 50DEPARTMENT ID DEPTNAME05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4Which of the following queries will produce the same result set as the query above?（）A.SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4B.SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4C.SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4D.SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4

3.Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）A、Selection, projection, joinB、Difference, projection, joinC、Selection, intersection, joinD、Intersection, projection, joinE、Difference, projection, product

4.Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）A. Selection, projection, joinB. Difference, projection, joinC. Selection, intersection, joinD. Intersection, projection, joinE. Difference, projection, product

更多“单选题A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following ”相关问题

  • 第1题：

    下面的查询中哪一个会产生笛卡尔集（）

    • A、SELECT e.empno，e.ename， e.deptno， d.deptno，d.loc  FROM  emp e，dept  d WHERE e.deptno=d.deptno
    • B、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp  e，dept  d
    • C、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept d WHERE e.empno=101 and e.deptno=d.deptno
    • D、SELECT e.empno， e.ename， e.deptno， d.deptno，d.loc FROM emp e，dept  d WHEREe.deptno=d.deptno and d.deptno=60

    正确答案:B

  • 第2题：

    A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）

    • A、Alias
    • B、View
    • C、Schema
    • D、Trigger

    正确答案:B

  • 第3题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （）

    • A、SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
    • B、SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
    • C、SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
    • D、SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);

    正确答案:C

  • 第4题：

    You executed the following query：  SELECT operation， undo_sql， table_name  FROM flashback_transaction_query;  Which statement is correct regarding the query output？（）

    • A、It would return information regarding only the last committed transaction.
    • B、It would return only the active transactions in all the undo segments in the database.
    • C、It would return only the committed transactions in all the undo segments in the database. 
    • D、It would return both active and committed transactions in all the undo segments in the database.
    • E、It would return information regarding the transactions that began and were committed in the last 30 minutes.

    正确答案:D

  • 第5题：

    Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?（）

    • A、SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
    • B、SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
    • C、SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
    • D、SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);

    正确答案:C

  • 第6题：

    单选题
    You executed the following query：  SELECT operation， undo_sql， table_name  FROM flashback_transaction_query;  Which statement is correct regarding the query output？（）
    A

    It would return information regarding only the last committed transaction.

    B

    It would return only the active transactions in all the undo segments in the database.

    C

    It would return only the committed transactions in all the undo segments in the database. 

    D

    It would return both active and committed transactions in all the undo segments in the database.

    E

    It would return information regarding the transactions that began and were committed in the last 30 minutes.


    正确答案： D
    解析： 暂无解析

  • 第7题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
    A

    Selection, projection, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


    正确答案： E
    解析： 暂无解析

  • 第8题：

    单选题
    Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?（）
    A

    SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4

    B

    SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4

    C

    SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4

    D

    SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4


    正确答案： B
    解析： 暂无解析

  • 第9题：

    单选题
    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）
    A

    Selection, projection, join

    B

    Difference, projection, join

    C

    Selection, intersection, join

    D

    Intersection, projection, join

    E

    Difference, projection, product


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session， and issues the following query：   SQL> SELECT * FROM sales；   Which process would retrieve the result from the database and return it to the client program？（）
    A

     User process

    B

     Server process

    C

     System Monitor （SMON）

    D

     Process Monitor （PMON）

    E

     Checkpoint process （CKPT）


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）
    A

     William used the Flashback Version Query feature.

    B

     William issued the CROSSCHECK command at the RMAN prompt.

    C

     William viewed the alert log file.

    D

     William used the Flashback Table feature.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You work in a Organization which is named Wiikigo Corp. The Organization uses SQL Server 2008. You are the administrator of the Organization database. Now you are in charge of a SQL Server 2008 instance. Look at the following query: SELECT s.*, i.* FROM SensitiveTbl AS s INNER JOIN InsensitiveTbl AS iON i. OrganizationName = s.OrganizationName You use the above query to join two tables on a column named OrganizationName. The following error is returned when you execute the query. "Msg 468, Level 16, State 9, Line 17 Cannot resolve the collation conflict between 'SQL_Latin1_General_CP1_CS_AS' and 'SQL_Latin1_General_CP1_CI_AS' in the equal to operation." The ON clause of the query has to be modified so that it can perform a case-sensitive joinsuccessfully. What should you do? （）
    A

    ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)

    B

    ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName) 

    C

    ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS 

    D

    ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS 


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）

    • A、The database manager will rollback the transaction in both applications.
    • B、The database manager will rollback the transaction in one of the two applications.
    • C、Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.
    • D、Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.

    正确答案:B

  • 第14题：

    At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）

    • A、 William used the Flashback Version Query feature.
    • B、 William issued the CROSSCHECK command at the RMAN prompt.
    • C、 William viewed the alert log file.
    • D、 William used the Flashback Table feature.

    正确答案:A

  • 第15题：

    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）

    • A、User process
    • B、Server process
    • C、System Monitor (SMON)
    • D、Process Monitor (PMON)
    • E、Checkpoint process (CKPT)

    正确答案:B

  • 第16题：

    Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?（）

    • A、Selection, projection, join
    • B、Difference, projection, join
    • C、Selection, intersection, join
    • D、Intersection, projection, join
    • E、Difference, projection, product

    正确答案:A

  • 第17题：

     A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

    • A、Acquire locks on table queried 
    • B、Generate redo for statement 
    • C、Fetch data from disk into memory 
    • D、Write changes to disk

    正确答案:C

  • 第18题：

    单选题
    Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （）
    A

    SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);

    B

    SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;

    C

    SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;

    D

    SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）
    A

    Acquire locks on table queried 

    B

    Generate redo for statement 

    C

    Fetch data from disk into memory 

    D

    Write changes to disk


    正确答案： C
    解析： 暂无解析

  • 第20题：

    单选题
    Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?（）
    A

    User process

    B

    Server process

    C

    System Monitor (SMON)

    D

    Process Monitor (PMON)

    E

    Checkpoint process (CKPT)


    正确答案： E
    解析： 暂无解析

  • 第21题：

    单选题
    A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）
    A

    Alias

    B

    View

    C

    Schema

    D

    Trigger


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement?（）
    A

    SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);

    B

    SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;

    C

    SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;

    D

    SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    Application A is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE employee SET salary = salary * 1.1 WHERE empno='000010' UPDATE department SET deptname = 'NEW dept' WHERE deptno='A00'Application B is designed to execute the following SQL statements within a single Unit of Work (UOW). UPDATE department SET deptname = 'OLD DEPT' WHERE deptno='A00' UPDATE employee SET salary = salary * 0.5 WHERE empno='000010' Application A and application B execute their first SQL statement at the same time. When application A and application B try to execute their second SQL statement, a deadlock occurs. What will happen?（）
    A

    The database manager will rollback the transaction in both applications.

    B

    The database manager will rollback the transaction in one of the two applications.

    C

    Application B will successfully update the EMPLOYEE and DEPARTMENT tables; Application A will be placed in a lock wait state.

    D

    Application A will successfully update the EMPLOYEE and DEPARTMENT tables; Application B will terminate when the lock timeout value is reached.


    正确答案： C
    解析： 暂无解析

  • 第24题：

    单选题
    Given the following table definitions: EMPLOYEE ID NAME DEPTID 01Smith 10 02Bossy 20 03 20 Peterson 04Goss 30 05Pape 40 06Avery 50 07O'Neal 60 08Carter 50 DEPARTMENT ID DEPTNAME 05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4 Which of the following queries will produce the same result set as the query above?（）
    A

    SELECT e.id, d.deptname FROM employee e, department d WHERE e.id > 4

    B

    SELECT e.id, d.deptname FROM employee e INNER JOIN department d ON e.deptid = d.id WHERE e.id > 4

    C

    SELECT e.id, d.deptname FROM employee e FULL OUTER JOIN department d ON e.id = d.id WHERE e.id > 4

    D

    SELECT e.id, d.deptname FROM employee e LEFT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4 UNION ALL SELECT e.id, d.deptname FROM employee e RIGHT OUTER JOIN department d ON e.deptid = d.id WHERE e.id > 4


    正确答案： C
    解析： 暂无解析

相关内容