违法和不良信息举报 联系客服
免费注册 登录

A number of applications issue the following SQL statement:S

题目
单选题
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
解析： 暂无解析
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

View the Exhibit for some of the current parameter settings. A user logs in to the HR schema and issues the following commands:SQL> CREATE TABLE emp(empno NUMBER(3),ename VARCHAR2(20),sal NUMBER(8,2));SQL> INSERT INTO emp(empno,ename) VALUES(1,‘JAMES‘);At this moment, a second user also logs in to the HR schema and issues the following command:SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);What happens in the above scenario?（）

A. The second user‘s session immediately produces the resource busy error.

B. The second user‘s command executes successfully.

C. The second user‘s session waits for a time period before producing the resource busy error.

D. A deadlock is created.


参考答案：C

第2题：

You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  • A、 The DBWn process writes to the datafile.
  • B、 Changes in the background process are recorded.
  • C、 The log file is updated with the current SCN number.
  • D、 The System Change Number （SCN） is recorded in the control file.
  • E、 The changes to the listener configuration in the listener.ora file are recorded.

正确答案:A,D

第3题：

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? （）

A. The results are not sorted.

B. The results are sorted numerically.

C. The results are sorted alphabetically.

D. The results are sorted numerically and then alphabetically.


参考答案：D

第4题：

Which of the following will begin a new unit of work?（）

  • A、The CONNECT statement
  • B、The first FETCH of a cursor
  • C、The BEGIN TRANSACTION statement
  • D、The first executable SQL statement

正确答案:D

第5题：

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

第6题：

From SQL*Plus, you issue this SELECT statement:You use this statement to retrieve data from a data table for()。

A. Updating

B. Viewing

C. Deleting

D. Inserting

E. Truncating


参考答案：B, D

第7题：

You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE；  What does the statement generate？（）

  • A、A text copy of the control file.
  • B、A binary copy of the control file.
  • C、A file containing a SQL statement which will re-create the database.
  • D、A file containing a SQL statement which will re-create the control file.

正确答案:D

第8题：

Which of the following cannot be used as input to the SQL Tuning Advisor?() (Choose all that apply.)

A. A single SQL statement provided by a user

B. An existing SQL Tuning Set (STS)

C. A preprocessed Database Replay workload

D. A schema name

E. SQL statement identified in EM as using excessive resources


参考答案：C, D

第9题：

A batch application executes a large number of update statements. The service level agreement for the application states that the application must complete its work as quickly as possible to ensure that dependent workloads can start ontime. What is one way to help the application complete quickly?（）

  • A、Code the application to issue a LOCK TABLE statement.  
  • B、Code the application to issue a LOCK ROW statement.  
  • C、Decrease the number of I/O servers.  
  • D、Increase the locklist parameter. 

正确答案:A

第10题：

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

更多相关问题
相关内容