【071考試】最新OCP認證071考試題庫整理-第10題 071考試-第10題、choose the best answer
Which statement is true regarding the outcome of the above query?
A) It produces an error because the ORDER BY clause ...[詳細]
【071考試】最新OCP認證071考試題庫整理-第9題 071考試-第9題、choose two
Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session?
A) Only the second D...[詳細]
【071考試】最新OCP認證071考試題庫整理-第8題 071考試-第8題、choose two
Examine the structure of the PRODUCTS table.
Which two statements are true?
A) EXPIRY_DATE always stores date and time in charac...[詳細]
【071考試】最新OCP認證071考試題庫整理-第7題 071考試-第7題、choose the best answer
Evaluate the following SQL statement:
ALTER TABLE hr.emp
SET UNUSED (mgr_id);
Which statement is true regarding the e...[詳細]
【071考試】最新OCP認證071考試題庫整理-第6題 071考試-第6題、choose the best answer
In the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.
Evaluate th...[詳細]
【071考試】最新OCP認證071考試題庫整理-第5題 071考試-第5題、choose the best answer
Evaluate the following CREATE SEQUENCE statement:
CREATE SEQUENCE seq1
START WITH 100
INCREMENT BY 10
MAXVALUE 200
...[詳細]
【071考試】最新OCP認證071考試題庫整理-第4題 071考試-第4題、choose the best answer
View the Exhibits and examine PRODUCTS and SALES tables.
You issue the following query to display product name and the ...[詳細]
【071考試】最新OCP認證071考試題庫整理-第3題 071考試-第3題、choose three
View the Exhibit and examine the description of SALES and PROMOTIONS tables.
You want to delete rows from the SALES table, where ...[詳細]
【071考試】最新OCP認證071考試題庫整理-第2題 071考試第2題、choose two
Examine the description of the EMP_DETAILS table given below:
Which two statements are true regarding SQL statements that can be e...[詳細]
【071考試】最新OCP認證071考試題庫整理-第1題 071考試-第1題、choose the best answer
What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?
A) RDB...[詳細]