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

You issue the following statement：   SQL> SELECT FIRSTNAME， 

题目
单选题
You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）
A

 by using the DBMS_REPAIR package

B

 by using the DBVERIFY utility

C

 by using Block Media Recovery

D

 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

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

第2题：

Consider the following table called EMPLOYEES: ID FIRSTNAME LASTNAME JOB LEVELCLERK 3If the following SQL statement is executed, how many rows will be deleted? DELETE FROM employees WHERE 1 = 1()

A.0

B.1

C.3

D.6


参考答案：D

第3题：

The user Sue issues this SQL statement:GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement:GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement:GRANT SELECT ON sue. EMP TO timber;The user Sue issues this SQL statement:REVOKE select on sue. EMP FROM alice;For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?（）

A. Alice only

B. Alice and Reena

C. Alice, Reena, and Timber

D. Sue, Alice, Reena, and Timber


参考答案：C

第4题：

Given the following function: CREATE FUNCTION emplist （　） RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN ('A00', 'B00'); END How can this function be used in an SQL statement?

  • A、SELECT TABLE(EMPLIST()) FROM EMPLOYEE
  • B、SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
  • C、SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
  • D、SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

正确答案:D

第5题：

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

第6题：

The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statement:What is true about this SQL statement?()

A. The SQL statement displays the desired results.

B. The column in the WHERE clause should be changed to display the desired results.

C. The operator in the WHERE clause should be changed to display the desired results.

D. The WHERE clause should be changed to use an outer join to display the desired results.


参考答案：C

第7题：

Given the following function:CREATE FUNCTION emplist () RETURNS TABLE ( id CHAR(6) , firstname VARCHAR(12) , lastname VARCHAR(15) ) LANGUAGE SQL BEGIN ATOMIC RETURN SELECT EMPNO, FIRSTNME, LASTNAME FROM EMPLOYEE WHERE WORKDEPT IN (‘A00‘, ‘B00‘); ENDHow can this function be used in an SQL statement?

A.SELECT TABLE(EMPLIST()) FROM EMPLOYEE

B.SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE

C.SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE

D.SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t


参考答案：D

第8题：

In a test database, you issue the SELECT … INTO OUTFILE statement to create a file with your t1 table data. You then TRUNCATE this table to empty it.（）Mysql＞ SELECT * INTO OUTFILE ‘/tmp/t1.sql‘ from t1;mysql＞ TRUNCATE t1;

A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql

B.Mysql＞ INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘

C.$ mysql – u root – p – h localhost test ＜ /tmp/t1.sql

D.Mysql＞ LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1

E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql


参考答案：D, E

第9题：

现有表Employee，字段：id（int）、firstname（varchar）、lastname（varchar）；以下sql语句错误的是（）

  • A、select firstname+’.’+lastnameas’name’from employee
  • B、select firstname+’.’+lastname=’name’from employee
  • C、select’name’=firstname+’.’+lastnamefrom employee
  • D、select firstname，lastname from employee

正确答案:B

第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

更多相关问题
相关内容