在SQL*PLUS中显示EMP表结构的命令是()
A、A.LIST EMP
B、B.DESC EMP
C、C.SHOW DESC EMP
D、D.STRUCTURE EMP
E、E.SHOW STRUCTURE EMP
A、A.LIST EMP
B、B.DESC EMP
C、C.SHOW DESC EMP
D、D.STRUCTURE EMP
E、E.SHOW STRUCTURE EMP
A、A.type array arr_type[emp.ename%type] index by binary_integer; B、B.type table arr_type[emp.ename%type] index by binary_integer; C、C.type arr_type is table of emp.ename%type index by binary_integer; D、D.type arr_type is pl_sql table of emp.ename%type index by binary_integer;
A、SQL*PLUS是ORACLE数据库的专用访问工具 B、SQL*PLUS是标准的SQL访问工具,可以访问各类关系型数据库 C、SQL*PLUS是所有ORACLE应用程序的底层API D、SQL*PLUS是访问ORACLE数据库的唯一对外接口 E、以上所述都不正确
A、用SQL*PLUS环境支持的SHOW命令 B、用DBMS_OUTPUT包的PUT_LINE过程 C、用PRINT命令来输出指定的字符串 D、用DISPLAY命令来输出指定的字符串 E、用DBMS_OUTPUT包的NEW_LINE过程
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.
A、/SQL*Plus commands cannot be abbreviated. B、/SQL*Plus commands are accessed 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.
A、SQL语言支持数据库的3级模式结构 B、一个基本表只能存储在一个存储文件中 C、一个SQL表可以是一个基本表或者是一个视图 D、数据库中数据的存储结构组成了关系数据库的内模式
A、Both SQL and /SQL*plus allow manipulation of values in the database. B、/SQL* Plus recognizes SQL satement and sends them to the server; SQL is the Oracle proprietary interface for executing SQL statements. C、/SQL* Plus language for communicating with the Oracle server to access data; SQL recognizes SQL statements and sends them to the server. D、/SQL manipulates data and table definition in the database; /SQL* Plus does not allow manipulation of values in the database.