Operational assurance uses defined policies, procedures, tools, and standards to monitor, test, and review the software within its operational environment to detect vulnerabilities or violations. This…
Operational assurance uses defined policies, procedures, tools, and standards to monitor, test, and review the software within its operational environment to detect vulnerabilities or violations. This function should be performed on _______________. a. Last b. Middle c. start of operation d. continuous basis
Which is true about NETWORK FIREWALL TYPES? A. A. Two types of network firewalls are stateful and stateless. B. B. The earliest firewalls were packet-based stateless firewalls. a. A and B are correct …
Which is true about NETWORK FIREWALL TYPES? A. A. Two types of network firewalls are stateful and stateless. B. B. The earliest firewalls were packet-based stateless firewalls. a. A and B are correct b. Both are incorrect c. Only A is correct d. Only B is correct
Which of the following is true? a. All data in a table can be recovered if the table is dropped with the PURGE option. b. All data in a table can be recovered from the recycle bin if the table is drop…
Which of the following is true?
a. All data in a table can be recovered if the table is dropped with the PURGE option.
b. All data in a table can be recovered from the recycle bin if the table is dropped.
c. All data in a table is lost if the table is dropped.
d. All of the above statements are true.
15. Which of the following commands is valid?
a. RENAME customer# TO customernumber FROM customers;
b. ALTER TABLE customers RENAME customer# TO customernum;
c. DELETE TABLE customers;
d. ALTER TABLE customers DROP UNUSED COLUMNS;
16. Which of the following commands creates a new table containing two columns?
a. CREATE TABLE newname (coll DATE, col2 VARCHAR2);
b. CREATE TABLE newname AS (SELECT title, retail, cost FROM books);
c. CREATE TABLEnewname (coll, col2);
d. CREATE TABLE newname (coll DATE DEFAULT SYSDATE, col2 VARCHAR2 (1));
17. Which of the following is a valid table name?
a. 9NEWTABLE
b. DATE9
c. NEW”TABLE
d. None of the above are valid table names.
18. Which of the following is a valid datatype?
a. CHAR3
b. VARCHAR4(3)
c. NUM
d. NUMBER
19. Which object in the data dictionary enables you to verify DEFAULT column settings?
a. DEFAULT_COLUMNS
b. DEF_TAB_COLUMNS
c. USER_TAB_COLUMNS
d. None of the above
20. Which of the following SQL statements changes the size of the Title column in the BOOKS
table from the current length of 30 characters to the length of 35 characters?
a. ALTER TABLE books CHANGE title VARCHAR(35);
b. ALTER TABLE books MODIFY (title VARCHAR2(35));
c. ALT
7. Which of the following commands drops any columns marked as unused from the SECUSTOMERORDERS table? a. DROP COLUMN FROM secustomerorders WHERE column_status = UNUSED; b. ALTER TABLE secustomerorder…
7. Which of the following commands drops any columns marked as unused from the
SECUSTOMERORDERS table?
a. DROP COLUMN FROM secustomerorders WHERE column_status = UNUSED;
b. ALTER TABLE secustomerorders DROP UNUSED COLUMNS;
c. ALTER TABLE secustomerorders DROP (unused);
d. DROP UNUSED COLUMNS;
8. Which of the following statements is correct?
a. A table can contain a maximum of only one column marked as unused.
b. You can delete a table by removing all columns in the table.
c. Using the SET UNUSED clause allows you to free up storage space used by a column.
d. None of the above statements are correct.
9. Which of the following commands removes all data from a table but leaves the table’s
structure intact?
a. ALTER TABLE secustomerorders DROP UNUSED COLUMNS;
b. TRUNCATE TABLE secustomerorders;
c. DELETE TABLE secustomerorders;
d. DROP TABLE secustomerorders;
10. Which of the following commands changes a table’s name from OLDNAME to NEWNAME?
a. RENAME oldname TO newname;
b. RENAME table FROM oldname TO newname;
c. ALTER TABLE oldname MODIFY TO newname;
d. CREATE TABLE newname (SELECT * FROM oldname);
11. The default width of a VARCHAR2 field is:
a. 1
b. 30
c. 255
d. None—there’s no default width for a VARCHAR2 field.
12. Which of the following is not a valid statement?
a. You can change the name of a table only if it doesn’t contain any data.
b. You can change the length of a column that doesn’t contain any data.
c. You can delete a column that doesn’t contain any data.
d. You ca
For a greater challenge, first prompt the user to enter the size of the new square. In order to get this to work, you’ll need to add a JTextField to the panel where a user can type the size they wish …
For a greater challenge, first prompt the user to enter the size of the new square. In order to get this to work, you’ll need to add a JTextField to the panel where a user can type the size they wish to use. The JTextField has not been provided for you – where should it go? How will you access it?
1. Which of the following is a correct statement? a. You can restore the data deleted with the DROP COLUMN clause, but not the data deleted with the SET UNUSED clause. b. You can’t create empty tables…
1. Which of the following is a correct statement?
a. You can restore the data deleted with the DROP COLUMN clause, but not the data
deleted with the SET UNUSED clause.
b. You can’t create empty tables—all tables must contain at least three rows of data.
c. A table can contain a maximum of 1000 columns.
d. The maximum length of a table name is 265 characters.
2. Which of the following is a valid SQL statement?
a. ALTER TABLE secustomersspent ADD DATE lastorder;
b. ALTER TABLE secustomerorders DROP retail;
c. CREATE TABLE newtable AS (SELECT * FROM customers);
d. ALTER TABLE drop column *;
3. Which of the following is not a correct statement?
a. A table can be modified only if it doesn’t contain any rows of data.
b. The maximum number of characters in a table name is 30.
c. You can add more than one column at a time to a table.
d. You can’t recover data contained in a table that has been truncated.
4. Which of the following is not a valid SQL statement?
a. CREATE TABLE anothernewtable (newtableid VARCHAR2(2));
b. CREATE TABLE anothernewtable (date, anotherdate)
AS (SELECT orderdate, shipdate FROM orders);
c. CREATE TABLE anothernewtable (firstdate, seconddate)
AS (SELECT orderdate, shipdate FROM orders);
d. All of the above are valid statements.
5. Which of the following is true?
a. If you truncate a table, you can’t add new data to the table.
b. If you change the default value of an existing column, all existing rows containing a
NULL value in the same column are set to the ne
Which of the following are true with regards to recurring tasks? Group of answer choices All occurrences of a recurring task are organized under a single summary recurring task. As with a regular summ…
Which of the following are true with regards to recurring tasks? Group of answer choices All occurrences of a recurring task are organized under a single summary recurring task. As with a regular summary task, the duration of a summary recurring task ranges from the earliest start date to the latest finish date of the individual occurrences of the recurring task. Each occurrence of the recurring task is sequentially numbered. All of the above
Project schedules a recurring task to start at the plan’s default start time. Group of answer choices True False
Project schedules a recurring task to start at the plan’s default start time. Group of answer choices True False
Which of the following operators is NOT necessarily normal? Question 5Select one: Diagonalizable operator Hermitian operator Unitary operator Self-adjoint operator
Which of the following operators is NOT necessarily normal? Question 5Select one: Diagonalizable operator Hermitian operator Unitary operator Self-adjoint operator
Which of the following statements about CSS is true? a.) CSS is able to alter how a page is displayed as well as generate some dynamic behavior. b.) CSS is used for simple visual alteration and cannot…
Which of the following statements about CSS is true? a.) CSS is able to alter how a page is displayed as well as generate some dynamic behavior. b.) CSS is used for simple visual alteration and cannot perform complex feats like animations or effects. c.) CSS is required for a web page to function. d.) CSS requires JavaScript in order to be injected into HTML.