Which command would you execute to restore to a specific moment-in-time?
A. onbar -t timestamp
B. onbar -r -log lognum
C. onbar -r -t timestamp
D. onbar -r -l timestamp
What are two ways to create table t1 with row level locking? (Choose two.)
A. Execute the command "create table t1 (c1 int) locking row".
B. Execute the command "create table t1 (c1 int) lock level row".
C. Execute the command "create table t1 (c1 int) lock mode row".
D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
E. Set the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table t1(c1 int)".
How can you determine which databases are created in an instance?
A. use dbschema utility
B. inspect ONCONFIG file
C. List reserved pages with oncheck -pr
D. run SELECT name FROM sysmaster:sysdatabases
How does an administrator allocate a new dbspace from the storagepool?
A. Use the SQL Admin API
B. Use the oninit command
C. Use the onadmin command
D. Use the onspaces command.
Which of the following methods will allow you to determine how much space is currently in use?
A. Query the $ table
B. Query the sysstats database
C. Query the sysusers database
D. Query the sysmaster database
Which of the following privileges can NOT be granted to a role?
A. Type-Level
B. Table-Level
C. Routine-Level
D. Database-Level
In which two places may a function be used in a SELECT statement? (Choose two.)
A. in a subquery
B. in a HAVING clause
C. in a GROUP BY clause
D. in the ORDER BY clause
E. in the select (or projection) list
Given the following table definition: CREATE TABLE t1(col1 BOOLEAN); Which of the following statements will fail to insert a row?
A. INSERT INTO t1 values ('t');
B. INSERT INTO t1 values ('f');
C. INSERT INTO t1 values (1);
D. INSERT INTO t1 values (NULL);
Which two database objects can be created using fragmentation? (Choose two.)
A. view
B. table
C. index
D. trigger
E. synonym
Which of the following is true of system catalogs?
A. one system catalog per chunk
B. one system catalog per instance
C. one system catalog per database
D. one system catalog per installation
