Online Access Free C2090-556 Practice Test

When is a cursor necessary in an SQL program?

• A.A cursor is necessary when a query returns more than one row and you wish to examine their content before an update or delete statement is executed.
• B.A cursor is necessary when a query returns one row and you wish to examine its content and maybe update it or delete it.
• C.A cursor is necessary before an after trigger can be created.
• D.A cursor is only necessary when using DISTINCT, UNIQUE, ORDER BY, GROUP BY or aggregates in SQL statements.

Which predicate is used in a query to perform searches with Basic Text Search?

• A.bts_contains()
• B.bts_in()
• C.bts_search()
• D.bts_like()

Assuming you have an employee table that stores the salary for each employee. What will this query return?
SELECT AVG(salary), STDEV(salary) FROM employees;

• A.Average salary and standard deviation for all rows assuming zero for NULL salaries.
• B.Average salary and standard deviation for all rows assuming the average value for NULL salaries.
• C.Average salary and standard deviation for all rows not containing NULL salaries.
• D.Average salary and standard deviation for all rows.

Using the following statements to insert new rows into an empty table:
INSERT INTO customer(name,cc) VALUES ("Alice", encrypt_aes("1234567890123456"));
INSERT INTO customer(name,cc) VALUES ("Bob", encrypt_aes("1234567890123478"));
What are the two valid answers for the following SQL? (Choose two.)
SELECT * FROM customer WHERE decrypt_char(cc) MATCHES "1234*";

• A.Zero rows if SET ENCRYPTION PASSWORD has been not set.
• B.Two rows containing NULL data.
• C.Two rows but the cc field will be decrypted.
• D.Two rows but only the name fields are returned.
• E.Two rows if SET ENCRYPTION PASSWORD has been set.

Which statement about casting is correct?

• A.In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.
• B.When you create a distinct data type, the database server automatically registers explicit casts from the distinct data type to the source data type and from the source data type to the distinct data type.
• C.You don't need create casts on distinct types to handle conversions between the new distinct data type and other data types in the database, the server takes care of that automatically.
• D.When you create an opaque data type, the server automatically define template casts to handle conversions between the internal and external representations of the opaque data type.