单选题SGA是一块巨大的共享内存区域,被看成是Oracle数据库的一个大缓冲池,如果需要查看SGA的大小信息,可以使用如下()语句。ASELECT SGA FROM V$DBABSELECT * FROM V$DBACSELECT * FROM V$SGADSELECT size FROM V%DBA
单选题
SGA是一块巨大的共享内存区域,被看成是Oracle数据库的一个大缓冲池,如果需要查看SGA的大小信息,可以使用如下()语句。
A
SELECT SGA FROM V$DBA
B
SELECT * FROM V$DBA
C
SELECT * FROM V$SGA
D
SELECT size FROM V%DBA
参考解析
解析:
暂无解析
相关考题:
在SQL Server 2000中,有学生表(学号,姓名,年龄,所在系),学号是主码。在这个表上建有视图V1,V1视图的定义语句为: CREATE VIEW V1 AS SELECT姓名,年龄,所在系FROM学生表 WHERE年龄>=(SELECT AVG(年龄)FROM学生表) 有下列操作语句: Ⅰ.UPDATE V1 SET年龄=年龄+1 Ⅱ.SELECT*FROM V1 WHERE年龄>20 Ⅲ.DELETE FROM V1 WHERE年龄>20 Ⅳ.INSERT INTO V1 VALUES(,张三,20,‘计算机系’) 以上语句能正确执行的是A.仅Ⅰ和ⅡB.仅ⅡC.仅Ⅱ和ⅣD.仅Ⅰ、Ⅱ和Ⅲ
有如下SQL-SELECT语句SELECT * FROM HH WHERE 单价 BETWEEN 10.6 AND 13.4与该语句等价的是A.SELECT * FROM HH WHERE 单价=13.4 AND 单价=10.6B.SELECT * FROM HH WHERE 单价13.4 AND 单价10.6C.SELECT * FROM HH WHERE 单价=13.4 AND 单价=10.6D.SELECT * FROM HH WHERE 单价13.4 AND 单价10.6
与“SELECT*FROM教师表INTO DBF A”等价的语句是A.SELECT*FROM教师表TO DBF AB.SELECT*FROM教师表TO TABLE AC.SELECT*FROM教师表INTO TABLE AD.SELECT*FROM教师表INTO A
有SQL语句:SELECT * FROM 教师 WHERE NOT(工资3000 OR 工资2000)与如下语句等价的SQL语句是A)SELECT*FROM 教师 WHERE 工资 BETWEEN 2000 AND 3000B) SELECT*FROM 教师 WHERE 工资2000 AND 工资3000C)SELECT*FROM 教师 WHERE 工资2000 OR 工资3000D) SELECT*FROM 教师 WHERE 工资=2000 AND 工资3000
当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。 A.SELECT * FROM V$LOGFILEB.SELECT * FROM V$LOGC.SELECT * FROM V$LOGHISTORYD.SELECT * FROM V$DBA
当需要查询Oracle的控制文件的名称、位置和状态时,可以使用()语句。 A.SELECT name FROM V$CONTROLFILEB.SELECT name FROM V$CTRLLFILEC.SELECT name FROM V$USERFILESD.SELECT name FROM V$DBAFILE
假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。 A.SELECT*FROM CUSTOMERB.SELECT*CUSTOMERC.MODIFY*FROM CUSTOMERD.UPDATE*FROM CUSTOMER
关于两个表对应的不匹配查询的正确语句为() A.SELECT[ccode]FROM[GL_accsum]where not exists(SELECT*FROM[code]group by ccode having[ccode]=[GL_accsum].[ccode])B.SELECT[ccode]FROM[GL_accsum]v where ccode not in(SELECTccodeFROM[code] where[ccode]=[v].[ccode])C.select A. ccode from[GL_accsum]a left join code bon A.[ccode]=[b].[ccode] where B.ccode is nullD.select A.ccode codes from[GL_accsum]a join code bon A.[ccode]=[b].[ccode] where B.ccode is null
( 30 )与 “ SELECT * FROM 教师表 INTO DBF A ” 等价的语句是A ) SELECT * FROM 教师表 TO DBF AB ) SELECT * FROM 教师表 TO TABLE AC ) SELECT * FROM 教师表 INTO TABLE AD ) SELECT * FROM 教师表 INTO A
假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。A、SELECT*FROM CUSTOMERB、SELECT*CUSTOMERC、MODIFY*FROM CUSTOMERD、UPDATE*FROM CUSTOMER
变量v_time=’23-MAY-00’, 如下那条语句返回值为’01-JAN-00’?()A、select round(v_time,’DAY’) from dualB、select round(v_time,’YEAR’) from dualC、select round(v_time,’MONTH’) from dualD、A select round(to_char(v_time,’yyyy’)) from dual
下面哪条语句可以取出薪水最高的前三个人:()A、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY );B、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY ) WHERE ROWNUM=3;C、SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY DESC) WHERE ROWNUM=3;D、SELECT * FROM EMPLOYEES WHERE ROWNUM=3 ORDER BY SALARY DESC;
V5.x系统中,用SQL语句查询Sybase版本的语句是()A、select ##versionB、select ##version from masterC、select @@version from masterD、select @@version
设有关系模式商品(商品号,商品名称,单价,数量,类别),建立统计每类商品总数量的视图的正确语句是()A、CREATE VIEW v1AS SELECT类别,SUM(数量)FROM商品GROUP BY类别B、CREATE VIEW v1AS SELECT类别,COUNT(数量)FROM商品GROUP BY类别C、CREATE VIEW v1(类别,总数量)AS SELECT类别,SUM(数量)FROM商品GROUP BY类别D、CREATE VIEW v1(类别,总数量)AS SELECT类别,COUNT(数量)FROM商品GROU PBY类别
有关系模式:学生表(学号,姓名,所在系),建立统计每个系的学生人数的视图的正确语句是()A、CREATE VIEW v1AS SELECT所在系,COUNT(*)FROM学生表GROUP BY所在系B、CREATEVIEW v1AS SELECT所在系,SUM(*)FROM学生表GROUP BY所在系C、CREATE VIEW v1(系名,人数)AS SELECT所在系,SUM(*)FROM学生表GROUP BY所在系D、CREATE VIEW v1(系名,人数)AS ELECT所在系,COUNT(*)FROM学生表GROUP BY所在系
如果要将查询的职工信息保存到数组tms中,应输入语句()。A、SELECT*FROM职工INTO ARRAY tinsB、SELECT*FROM职I INTO CURSOR tinsC、SELECT*FROM职I INTO DBF tinsD、SELECT*FROM职工INTO TABLE tms
当需要查询Oracle的控制文件的名称、位置和状态时,可以使用()语句。A、SELECT name FROM V$CONTROLFILEB、SELECT name FROM V$CTRLLFILEC、SELECT name FROM V$USERFILESD、SELECT name FROM V$DBAFILE
SGA是一块巨大的共享内存区域,被看成是Oracle数据库的一个大缓冲池,如果需要查看SGA的大小信息,可以使用如下()语句。A、SELECT SGA FROM V$DBAB、SELECT * FROM V$DBAC、SELECT * FROM V$SGAD、SELECT size FROM V%DBA
当需要查询日志文件所有组及其成员的名称和文件位置,可以使用()方式。A、SELECT * FROM V$LOGFILEB、SELECT * FROM V$LOGC、SELECT * FROM V$LOGHISTORYD、SELECT * FROM V$DBA
A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL connect smith/smith Connected. SQL SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION()A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
当需要返回当前用户的名字,可以执行如下()SQL语句。A、SELECT user FROM V$DBAB、SELECT user FROM dualC、SELECT name FROM dualD、SELECT name FROM V$DBA
假设需要查询Oracle数据文件的文件名和存储位置,可以使用如下()方式。A、SELECT name,status FROM V$datafileB、SELECT name,statusFROM V$userfileC、SELECT name,status FROM V$DBAD、SELECT name,status FROM V$ctrlfile
单选题“客户”表和“贷款”表的结构如下:客户(客户号,姓名,出生日期,身份证号)贷款(贷款编号,银行号,客户号,贷款金额,贷款性质)建立视图统计每个客户贷款的次数,正确的SQL语句是( )。ACREATE VIEW v_dk AS SELECT客户号,count(*)AS次数FROM贷款BCREATE VIEW v_dk AS SELECT客户号,count(*)AS次数FROM贷款COMPUTE BY客户号CCREATE VIEW v_dk AS SELECT客户号,count(*)AS次数FROM贷款ORDER BY客户号DCREATE VIEW v_dk AS SELECT客户号,count(*)AS次数FROM贷款GROUP BY客户号
单选题变量v_time=’23-MAY-00’, 如下那条语句返回值为’01-JAN-00’?()Aselect round(v_time,’DAY’) from dualBselect round(v_time,’YEAR’) from dualCselect round(v_time,’MONTH’) from dualDA select round(to_char(v_time,’yyyy’)) from dual
单选题有关系模式:学生表(学号,姓名,所在系),建立统计每个系的学生人数的视图的正确语句是()ACREATE VIEW v1AS SELECT所在系,COUNT(*)FROM学生表GROUP BY所在系BCREATEVIEW v1AS SELECT所在系,SUM(*)FROM学生表GROUP BY所在系CCREATE VIEW v1(系名,人数)AS SELECT所在系,SUM(*)FROM学生表GROUP BY所在系DCREATE VIEW v1(系名,人数)AS ELECT所在系,COUNT(*)FROM学生表GROUP BY所在系
单选题设有关系模式商品(商品号,商品名称,单价,数量,类别),建立统计每类商品总数量的视图的正确语句是()ACREATE VIEW v1AS SELECT类别,SUM(数量)FROM商品GROUP BY类别BCREATE VIEW v1AS SELECT类别,COUNT(数量)FROM商品GROUP BY类别CCREATE VIEW v1(类别,总数量)AS SELECT类别,SUM(数量)FROM商品GROUP BY类别DCREATE VIEW v1(类别,总数量)AS SELECT类别,COUNT(数量)FROM商品GROU PBY类别