What statement is true regarding processor allocation when implementing micro-partitions? ()
第1题:
A. 17000.00
B. 17000*****
C. ****170.00
D. **17000.00
E. an error statement
第2题:
Examine the description of the MARKS table:SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects.Examine this SELECT statement based on the MARKS table:What is the result of the SELECT statement?()
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
第3题:
This statement is not ____ with what you said earlier.A. right B. consist C. accordance D. consistent
D consistent with 与。。一致
第4题:
The 192.168.0.0 network is not being propagated throughout the network. Observe the BGP configuration commands from the advertising router.What is the reason the 192.168.0.0 route is not being advertised? ()
A. The network 192.168.0.0 statement is missing mask 255.255.0.0
B. The network 192.168.0.0 statement is missing mask 0.0.255.255.
C. The network 10.0.0.0 statement is missing mask 255 .0.0.0.
D. The network 10.0.0.0 statement is missing mask 0.255.255.255.
E. The auto - summary configuration is missing.
第5题:
A. The DESCRIBE DEPT statement displays the structure of the DEPT table.
B. The ROLLBACK statement frees the storage space occupies by the DEPT table.
C. The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D. The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
第6题:
The EMPLOYEES table contains these columns:You need to write a query that will produce these results:1. Display the salary multiplied by the commission_pct.2. Exclude employees with a zero commission_pct.3. Display a zero for employees with a null commission value.Evaluate the SQL statement:What does the statement provide?()
A. All of the desired results
B. Two of the desired results
C. One of the desired results
D. An error statement
第7题:
A. 0
B. 1
C. 0.00
D. An error statement
第8题:
听力原文:If a statement that presents a summary of the revenues and expenses of a business unit for a specific period, what is it called?
(3)
A.the income statement
B.the balance sheet
C.the financial statement
D.the statement of cash flow
第9题:
A. The statement produces an error at line 1.
B. The statement produces an error at line 3.
C. The statement produces an error at line 6.
D. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all departments that pay less salary then the maximum salary paid in the company.
E. The statement returns the employee name, salary, department ID, and maximum salary earned in the department of the employee for all employees who earn less than the maximum salary in their department.
第10题:
What is a sub-select statement?
A.a select statement that selects a subset of fields in a table
B.a select statement that returns a subset of the data in a table
C.a select statement that appears within another select statement
D.a select statement that returns a subset of the constraints on a field