Application A holds an Exclusive lock on table TAB1 and needs to acquire an Exclusive lock on table TAB2. Application B holds an Exclusive lock on table TAB2 and needs to acquire an Exclusive lock on table TAB1. If lock timeout is set to -1 and both applications are using the Read
Stability isolation level, which of the following will occur?

• A. Applications A and B will cause a deadlock situation
• B. Application B will read the copy of table TAB1 that was loaded into memory when Application A first read it
• C. Application B will read the data in table TAB1 and see uncommitted changes made by Application A
• D. Application B will be placed in a lock-wait state until ApplicationA releases its lock

Given the following two tables:
NAMES
NAME NUMBER
Wayne Gretzky 99 Jaromir Jagr 68 Bobby Orr 4 Bobby Hull 23 Mario Lemieux 66
POINTS
NAME POINTS
Wayne Gretzky 244 Bobby Orr 129 Brett Hull 121 Mario Lemieux 189 Joe Sakic 94
How many rows would be returned using the following statement?
SELECT name FROM names, points

• A. 0
• B. 10
• C. 5
• D. 25

Which of the following isolation levels will lock all rows scanned to build a result data set?

• A. Cursor Stability
• B. Repeatable Read
• C. Read Stability
• D. Uncommitted Read

Given the following information:
Protocol: TCP/IP Port Number: 5000 Host Name: DB_SERVER Database Name: TEST_DB Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?

• A. CATALOG TCPIP NODE 5000 REMOTE SERVERdb_server OSTYPE LINUX;
  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
• B. CATALOG DATABASEtest_db AS test_db REMOTE TCPIP SERVER db_server PORT 5000
  OSTYPE LINUX;
• C. CATALOG TCPIP NODEdb_server REMOTE db_server PORT 5000 OSTYPE LINUX;
  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;
• D. CATALOG TCPIP NODEdb_server REMOTE db_server SERVER 5000 OSTYPE LINUX;
  CATALOG DATABASE test_db AS test_db AT NODE db_server AUTHENTICATION SERVER;