Online Access Free A2090-610 Exam Questions

An SQL function named DEPT_INFO was created as follows:

What is the correct way to use this function in a query?

• A.SELECT TABLE dept_id, dept_name FROM dept_info()
• B.SELECT dept_info(dept_id, dept_name)
• C.SELECT dept_id, dept_name FROM TABLE(dept_info()) AS results
• D.SELECT dept_id, dept_name FROM dept_info()

Given the following DDL statement: CREATE TABLE sales (item CHAR(20)); If a DBA wishes to increase the size of the ITEM column, which SQL statement needs to be used?

• A.ALTER TABLE sales MODIFY COLUMN item CHAR(40);
• B.ALTER TABLE sales ALTER COLUMN item SET DATA TYPE CHAR(40);
• C.ALTER TABLE sales ALTER COLUMN item CHAR(40);
• D.ALTER TABLE sales ADD COLUMN item CHAR(40);

Which statement about application-period temporal tables is true?

• A.Consists of a pair of columns with database-manager maintained values that indicate the period when a row is current.
• B.Consists of explicitly-supplied timestamps and a separate associated history table.
• C.Is useful when one wants to keep both user-based period information and system-based historical information.
• D.Is based on explicitly-supplied timestamps that define the time periods during which data is valid.

By default, where is the data stored for a column defined with an XML data type?

• A.In an XML index.
• B.In line with the rest of the data for the table, for XML columns less than 32KB.
• C.In an XML storage object that is separate from the table.
• D.In line with the rest of the data for the table.

If a user has been granted SYSCTRL authority, which activities can they perform?

• A.Load operations
• B.Monitor database performance
• C.Create and drop databases
• D.Backup/copy table spaces