my_pg_082_在线真题试卷与模拟练习_my_pg_082_考试宝

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

1. You issued this command
DROP TABLE hr employees; Which three statements are true?

2.Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

3.Which three statements are true about multiple row subqueries?

4.Examine the description of the BOOKS_TRANSACTIONS table:

Name Null? Type

---------------------------------------------

TRANSACTION_ID NOT NULL VARCHAR2(6)

TRANSACTION_TYPE VARCHAR2(2)

BORROWED_DATE DATE

BOOK_ID VARCHAR2(6)

MEMBER_ID VARCHAR2(6)

Which two WHERE conditions give the same result?

5.Which two statements are true about the Oracle join and ANSI join syntax?

6.Examine the description of PRODUCT_DETAILS table:
Name Null Type
-----------------------------------------
PRODUCT_ID NOT NULL NUMBER(2)
PRODUCT_NAME NOT NULL VARCHAR2(25)
PRODUCT_PRICE NUMBER(8,2)
EXPIRY_DATE DATE
Which two statements are true?

7.Examine these statements executed in a single Oracle session:
Create table product(pcode number(2),pname varchar2(20));
Insert into product values(1,’pen’);
Insert into product values(2,’pencil’);
Insert into product values(3,’fountain pen’);
Savepoint a;
Update product set pcode = 10 where pcode = 1;
Commit;
Delete from product where pcode = 2;
Savepoint b;
Update product set pcode = 30 where pcode = 3;
Savepoint c;
Delete from product where pcode = 10;
Rollback to savepoint b;
Commit;

8.Which two statements are true about Oracle synonyms?

9.What is true about non-equijoin statement performance?

10.The SALES table has columns PROD ID and QUANTITY_ SOLD of data type NUMBER. Which two queries execute successfully?

11.Examine the description of the EMPLOYEES table:
Name Null? Type
-------------------------------------
EMP_ID NOT NULL NUMBER
EMP_NAME VARCHAR2(10)
DEPT_ID NUMBER(2)
SALARY NUMBER(8,2)
JOIN_DATE DATE
NLS_DATE FORMAT is set to DD-MON-YY.
Which query requires explicit data type conversion?

12.Examine this command:ALTER DATABASE MOVE DATAPILE '/u01/sales01.dbf' '/u02/sales02.dbf'; Which two statements are true?

13.Which two statements are true about INTERVAL data types?

14.Which two statements are true about substitution variables?

15.Which three statements are true about sequences in a single instance Oracle database?

16.Which two statements are true about the tools used to configure Oracle Net Services?

17.Examine the description of the MEMBERS table:
Name Null? Type
-------------------------------------
MEMBER_ID NOT NULL VARCHAR2(6)
FIRST_NAME VARCHAR2(50)
LAST_NAME NOT NULL VARCHAR2(50)
ADDRREG VARCHAR2(50)
CITY VARCHAR2(25)
Examine the partial query:
Select city,last_name lname from members …;
You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query?

18. Which is the default column or columns for sorting output from compound queries using SET operators such as INTERSECT in a SQL statement?

19.Which two statements are true about single row functions?

21. In the PROMOTIONS table, the PROMO BEGIN DATE column is of data type DATE and the default date format is DD-MON-RR. Which two statements are true about expressions using PROMO BEGIN DATE contained in a query?

更多题库