最新的Oracle Database SQL - 1z0-071免費考試真題

A. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,023.

B. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,0236.

C. A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.

D. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as #####

E. A row whose UNIT_PRICE column contains the value 10235.99 will be displayed as $1,023.

A. The ROLLBACK statement does not release locks resulting from table updates.

B. Data Control L anguage (DCL) statements, such as GRANT and REVOKE, can be rolled back.

C. Data consistency is not guaranteed after a rollback.

D. A transaction interrupted by a system failure is automatically rolled back.

E. If the ROLLBACK statement is used without TO SAVEPOINT, then all savepoints in the transaction are deleted .

A. SELECT can be granted only on tables and views.

B. DELETE can be granted on tables, views, and sequences.

C. INSERT can be granted on tables, views, and sequences.

D. REFERENCES can be granted only on tables and views.

E. ALTER can be granted only on tables and sequences.

F. UPDATE can be granted only on tables and views.

A. SELECT * FROM "123";

B. SELECT * FROM '123';

C. SELECT * FROM V'123V';

D. SELECT * FROM TABLE (123) ;

A. The && prefix will not prompt for a value even if the substitution variable is not previously defined in the session.

B. Both & and && can prefix a substitution variable name in queries and DML statements.

C. An & prefix to an undefined substitution variable, which is referenced twice in the same query, will prompt for a value twice .

D. & can prefix a substitution variable name only in queries. DML

E. An && prefix to an undefined substitution variable, which is referenced multiple times in multiple queries, will prompt for a value once per query.

A. providing database transaction control

B. processing sets of data

C. providing variable definition capabilities.

D. providing update capabilities for data in external files

E. providing graphical capabilities

A. A synonym can be available to all users .

B. A synonym cannot be created for a PL /SQL package.

C. A synonym created by one user can refer to an object belonging to another user.

D. Any user can drop a PUBLIC synonym.

E. A SEQUENCE can have a synonym.

A. A CHAR column definition does not require the length to be specified

B. The default length for a CHAR column is always one character

C. A VARCHAR2 column definition does not require the length to be specified

D. A BLOB stores unstructured binary data within the database

E. A BFILE stores unstructured binary data in operating systerm files

F. A VARCHAR2 blank pads column values only if the data stored is non numeric and contains no special characlers

A. ORDER BY"CUST NO"

B. ORDER BY "Last Name"

C. ORDER BY CUSTNO

D. ORDER BY 2, cust_id

E. ORDERBY2, 1

A. It can be an inner join.

B. It must be a full outer join.

C. It must be an equijoin.

D. The join key column must have an index.

E. It can be a left outer join.

A. CEIL returns the largest integer less than or equal to a specified number.

B. LAST_DAY returns the date of the last day of the month for the date argument passed to the function.

C. ADD_MONTHS adds a number of calendar months to a date.

D. LAST_DAY return the date of the last day the previous month only.

E. ADD_MONTHS works with a character string that can be implicitlyt converted to a DATE data type.

F. CEIL requires an argument which is a numeric data type.

G. LAST_DAY returns the date of the last day of the current ,month onlyu.

A. SELECT 'The first_name is '' || first_name || '' FROM employees ;

B. SELECT 'The first_name is \'' || first_name || '\'' FROM employees;

C. SELECT 'The first_name is ''' ||first_name||''' FROM employees ;

D. SELECT 'The first_name is '|| first_name|| '' FROM employees;

E. SELECT 'The first_name is '''||first_name ||'''' FROM employees ;

A. An expression in the first SELECT list must have a column alias for the expression

B. Queries using set operators do not perform implicit conversion across data type groups (e.g. character, numeric)

C. All set operators are valid on columns all data types.

D. CHAR columns of different lengths used with a set operator retum a vAacsua mhtoe e equals the longest CHAR value.

E. In a query containing multiple set operators INTERSECT always takes precedence over UNION and UNION ALL

A. Sequences can always have gaps.

B. A sequence number that was allocated can be rolled back if a transaction fails.

C. A sequence can issue duplicate values.

D. A sequence's unallocated cached values are lost if the instance shuts down.

E. A sequence can only be dropped by a DBA.

F. Two or more tables cannot have keys generated from the same sequence.