16. Which of the following is the standard extension used for a script file? a. .spt b. .srt c. .script d. .sql 17. A rollback occurs automatically when: a. A DDL command is executed. b. A DML command…
16. Which of the following is the standard extension used for a script file?
a. .spt
b. .srt
c. .script
d. .sql
17. A rollback occurs automatically when:
a. A DDL command is executed.
b. A DML command is executed.
c. The user exits the system.
d. none of the above
18. What is the maximum number of rows that can be deleted from a table at one time?
a. 1
b. 2
c. 3
d. unlimited
19. Which of the following is a correct statement?
a. If you attempt to add a record that violates a constraint for one of the table’s columns,
only the valid columns for the row are added.
b. A subquery nested in the VALUES clause of an INSERT INTO command can return
only one value without generating an Oracle 12c error message.
c. If you attempt to add a record that violates a NOT NULL constraint, a blank space is
inserted automatically in the appropriate column so that Oracle 12c can complete the
DML operation.
d. None of the above statements is correct.
20. What is the maximum number of records that can be modified with a single UPDATE
command?
a. 1
b. 2
c. 3
d. unlimited
Referring to this week’s “Looking at the Bigger Picture” video, discuss something about Excel that you do not understand or want to learn more about. Use the F1 shortcut to access the Help menu in Exc…
Referring to this week’s “Looking at the Bigger Picture” video, discuss something about Excel that you do not understand or want to learn more about. Use the F1 shortcut to access the Help menu in Excel and conduct a search about something you want to learn more about. Share what you searched, your results, and what you learned from your search. What are some ways that you can use Excel in your personal, professional, and academic life?
A ________tracks the status of network traffic traveling across it in a” state table.” The firewall is programmed to distinguish legitimate traffic for different types of connections using that table….
A ________tracks the status of network traffic traveling across it in a” state table.” The firewall is programmed to distinguish legitimate traffic for different types of connections using that table. a. stateful firewall b. cannot be the 2 firewall types c. can be the 2 firewall types d. stateless firewall
10. You issue the following command: INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, NULL, ‘C’). The command will fail if which of the following statements is true? a. Col1 has a PRIMARY KEY co…
10. You issue the following command: INSERT INTO homework10 (col1, col2, col3) VALUES
(‘A’, NULL, ‘C’). The command will fail if which of the following statements is true?
a. Col1 has a PRIMARY KEY constraint enabled.
b. Col2 has a UNIQUE constraint enabled.
c. Col3 is defined as a DATE column.
d. None of the above would cause the command to fail.
11. Which of the following releases a lock currently held by a user on the HOMEWORK10 table?
a. A COMMIT command is issued.
b. A DDL command is issued to end a transaction.
c. The user exits the system.
d. A ROLLBACK command is issued.
e. all of the above
f. none of the above
12. Assume you have added eight new orders to the ORDERS table. Which of the following
is true?
a. Other users can view the new orders as soon as you execute the INSERT INTO
command.
b. Other users can view the new orders as soon as you issue a ROLLBACK command.
c. Other users can view the new orders as soon as you exit the system or execute a
COMMIT command.
d. Other users can view the new orders only if they place an exclusive lock on the table.
13. Which of the following commands removes all orders placed before April 1, 2009?
a. DELETE FROM orders WHERE orderdate < '01-APR-09';
b. DROP FROM orders WHERE orderdate < '01-APR-09';
c. REMOVE FROM orders WHERE orderdate < '01-APR-09';
d. DELETE FROM orders WHERE orderdate > ’01-APR-09′;
14. How many rows can be added to a table by executing the INSERT INTO … VALUES
command?
a. 1
b. 2
c. 3
d. unlimited
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE * FROM homework10; b. DELETE *.* FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid …
Which of the following statements deletes all rows in the HOMEWORK10 table?
a. DELETE * FROM homework10;
b. DELETE *.* FROM homework10;
c. DELETE FROM homework10;
d. DELETE FROM homework10 WHERE amid = ‘*’;
e. Both c and d delete all rows in the HOMEWORK10 table.
5. Which of the following statements places a shared lock on at least a portion of a table
named HOMEWORK10?
a. SELECT * FROM homework10 WHERE col2 IS NULL FOR UPDATE;
b. INSERT INTO homework10 (col1, col2, col3) VALUES (‘A’, ‘B’, ‘C’);
c. UPDATE homework10 SET col3 = NULL WHERE col1 = ‘A’;
d. UPDATE homework10 SET col3 = LOWER (col3) WHERE col1 = ‘A’;
e. all of the above
6. Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this
order), which of the following commands stores a NULL value in Col3 of the
HOMEWORK10 table?
a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);
b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);
c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);
d. UPDATE homework10 SET col1 = col3;
7. Which of the following symbols designates a substitution variable?
a. &
b. $
c. #
d. –
8. Which of the following input values results in a successful INSERT of O’hara?
a. ‘O^
hara’
b. ‘O’ ‘hara’ (two single quotes following the O)
c. ‘O”hara’ (a double quote following the O)
d. Data values can’t contain quotes.
9. Which of the following commands locks the HOMEWORK10 table in EXCLUSIVE mode?
a. LOCK TABLE homework10 EXCLUSIVELY;
b. LOCK TABLE homework10 IN EXCLUSIVE MOD
Network infrastructures share the security issues associated with computers because the physical infrastructure of a network is hardware-based and enabled by software. The difference between the two i…
Network infrastructures share the security issues associated with computers because the physical infrastructure of a network is hardware-based and enabled by software. The difference between the two is that __________________. a. the sole responsibility of the network is communication rather than data storage. b. the sole responsibility of the network is protection rather than data processing. c. the sole responsibility of the network is communication rather than protection. d. the sole responsibility of the network is communication rather than data processing.
To ensure security, security architects implement technological countermeasures such as _____________. a. firewall, intrusion detection system (IDSs), and strong authentication. b. firewall, intrusion…
To ensure security, security architects implement technological countermeasures such as _____________. a. firewall, intrusion detection system (IDSs), and strong authentication. b. firewall, intrusion detection system (IDSs), and law on invasion. c. virus blocker, intrusion detection system (IDSs), and strong authentication. d. firewall, software invasion, and strong authentication.
1. Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQL*Plus. b. A commit is issued implicitly when a DDL command is executed. c. A co…
1. Which of the following is a correct statement?
a. A commit is issued implicitly when a user exits SQL Developer or SQL*Plus.
b. A commit is issued implicitly when a DDL command is executed.
c. A commit is issued automatically when a DML command is executed.
d. All of the above are correct.
e. Both a and b are correct.
f. Both a and c are correct.
2. Which of the following is a valid SQL statement?
a. SELECT * WHERE amid = ‘J100’ FOR UPDATE;
b. INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager);
c. DELETE amid FROM acctmanager;
d. rollback;
e. all of the above
3. Which of the following commands can be used to add rows to a table?
a. INSERT INTO
b. ALTER TABLE … ADD
c. UPDATE
d. SELECT … FOR UPDATE
Which is true on threats to the information? A. A. Logic bombs are common they are pieces of code attached to host programs and propagate or replicate when the host is executed. B. B. Malicious code i…
Which is true on threats to the information? A. A. Logic bombs are common they are pieces of code attached to host programs and propagate or replicate when the host is executed. B. B. Malicious code is virulent. a. Only A is correct b. A is incorrect, and B is correct c. Only B is correct d. Both are incorrect
Which is true about sniffers? A. A. Sniffers are common utilities employed to read any information in packets transmitted over a network. B. B. Sniffers are usually software utility monitors data traf…
Which is true about sniffers? A. A. Sniffers are common utilities employed to read any information in packets transmitted over a network. B. B. Sniffers are usually software utility monitors data traffic through a network or server. a. Both are incorrect b. Only B is correct c. Only A is correct d. A and B are correct