Which of the following is a NOT correct statement of ASSURANCE MANAGEMENT? a. It is the process that assures the contents of the base are always known and documented adequately b. It assures that the …
Which of the following is a NOT correct statement of ASSURANCE MANAGEMENT? a. It is the process that assures the contents of the base are always known and documented adequately b. It assures that the documentation is accurate and that all security policies are correctly implemented. c. A control that has been deliberately set to counter an identified threat. d. It establishes and maintains a precise description of the information asset base, its constituent elements, and their interrelationship.
Various permissions accompany these licenses and do not limit installation to a single computer. Select one: True False
Various permissions accompany these licenses and do not limit installation to a single computer. Select one: True False
Which is NOT the correct statement for unique physical components? a. Switches and hubs are physical components interconnecting computers within a network b. The cables are not the physical link among…
Which is NOT the correct statement for unique physical components? a. Switches and hubs are physical components interconnecting computers within a network b. The cables are not the physical link among these elements. c. The unique physical components of the networks are switches, hubs, routers, and cables. d. Routers connect that network to a common resource such as the internet.
Threats can be classified into two categories: a. outsider and insider b. hackers and cyber-criminals c. controlled and uncontrolled d. theft and human error
Threats can be classified into two categories: a. outsider and insider b. hackers and cyber-criminals c. controlled and uncontrolled d. theft and human error
Which is true about Adware? A. A. Adware is a common form of spyware that opens a computer to ads delivered from the internet. B. B. Like an unwanted telemarketer, adware is directly malicious; it doe…
Which is true about Adware? A. A. Adware is a common form of spyware that opens a computer to ads delivered from the internet. B. B. Like an unwanted telemarketer, adware is directly malicious; it does use up valuable time and system resources. a. A is incorrect, and B is correct b. Both are incorrect c. A is correct, and B is incorrect d. A and B are correct
The _________ is software that is interposed between all subjects and objects within the system. This is part of configuring the operating system for security a. Access control b. access permissions c…
The _________ is software that is interposed between all subjects and objects within the system. This is part of configuring the operating system for security a. Access control b. access permissions c. preprogrammed access d. reference monitor
11. In the initial creation of a table, if a UNIQUE constraint is included for a composite column that requires the combination of entries in the specified columns to be unique, which of the following…
11. In the initial creation of a table, if a UNIQUE constraint is included for a composite column
that requires the combination of entries in the specified columns to be unique, which of the
following statements is correct?
a. The constraint can be created only with the ALTER TABLE command.
b. The constraint can be created only with the table-level approach.
c. The constraint can be created only with the column-level approach.
d. The constraint can be created only with the ALTER TABLE … MODIFY command.
12. Which type of constraint should you use on a column to allow entering only values above 100?
a. PRIMARY KEY
b. UNIQUE
c. CHECK
d. NOT NULL
13. Which of the following commands can be used to enable a disabled constraint?
a. ALTER TABLE … MODIFY
b. ALTER TABLE … ADD
c. ALTER TABLE … DISABLE
d. ALTER TABLE … ENABLE
14. Which of the following keywords allows the user to delete a record from a table, even if
rows in another table reference the record through a FOREIGN KEY constraint?
a. CASCADE
b. CASCADE ON DELETE
c. DELETE ON CASCADE
d. DROP
e. ON DELETE CASCADE
15. Which of the following data dictionary objects should be used to view information about the
constraints in a database?
a. USER_TABLES
b. USER_RULES
c. USER_COLUMNS
d. USER_CONSTRAINTS
e. None of the above objects should be used.
16. Which of the following types of constraints can’t be created at the table level?
a. NOT NULL
b. PRIMARY KEY
c. CHECK
d. FOREIGN KEY
e. None of the above constraints can be created at th
The FOREIGN KEY constraint should be added to which table? a. the table representing the “one” side of a one-to-many relationship b. the parent table in a parent-child relationship c. the child table …
The FOREIGN KEY constraint should be added to which table?
a. the table representing the “one” side of a one-to-many relationship
b. the parent table in a parent-child relationship
c. the child table in a parent-child relationship
d. the table that doesn’t have a primary key
8. What is the maximum number of columns you can define as a primary key when using the
column-level approach to creating a table?
a. 0
b. 1
c. 30
d. 255
9. Which of the following commands can you use to rename a constraint?
a. RENAME
b. ALTER CONSTRAINT
c. MOVE
d. NEW NAME
e. None of the above commands can be used.
10. Which of the following is a valid SQL statement?
a. CREATE TABLE tablel
(col1 NUMBER PRIMARY KEY,
col2 VARCHAR2(20) PRIMARY KEY,
col3 DATE DEFAULT SYSDATE,
col4 VARCHAR2(2));
b. CREATE TABLE tablel
(col1 NUMBER PRIMARY KEY,
col2 VARCHAR2(20),
col3 DATE,
col4 VARCHAR2 (2) NOT NULL,
CONSTRAINT tablel_col3_ck
CHECK (col3=SYSDATE));
c. CREATE TABLE tablel
(col1 NUMBER,
col2 VARCHAR2(20),
col3 DATE,
col4 VARCHAR2(2),
PRIMARY KEY (coll));
d. CREATE TABLE tablel
(coll NUMBER,
col2 VARCHAR2(20),
col3 DATE DEFAULT SYSDATE,
col4 VARCHAR2(2);
1. Which of the following statements is correct? a. A PRIMARY KEY constraint allows NULL values in the primary key column(s). b. You can enable a dropped constraint if you need it in the future. c. Ev…
1. Which of the following statements is correct?
a. A PRIMARY KEY constraint allows NULL values in the primary key column(s).
b. You can enable a dropped constraint if you need it in the future.
c. Every table must have at least one PRIMARY KEY constraint, or Oracle 12c doesn’t
allow the table to be created.
d. None of the above statements is correct.
2. Which of the following is not a valid constraint type?
a. PRIMARY KEYS
b. UNIQUE
c. CHECK
d. FOREIGN KEY
3. Which of the following SQL statements is invalid and returns an error message?
a. ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid);
b. ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid);
c. ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid);
d. ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid)
REFERENCES publisher (pubid);
e. All of the above statements are invalid.
4. What is the maximum number of PRIMARY KEY constraints allowed for a table?
a. 1
b. 2
c. 30
d. 255
5. Which of the following is a valid SQL command?
a. ALTER TABLE books ADD CONSTRAINT UNIQUE (pubid);
b. ALTER TABLE books ADD CONSTRAINT PRIMARY KEY (pubid);
c. ALTER TABLE books MODIFY (pubid CONSTRAINT NOT NULL);
d. ALTER TABLE books ADD FOREIGN KEY CONSTRAINT (pubid) REFERENCES
publisher (pubid);
e. None of the above commands is valid.
6. How many NOT NULL constraints can be created at the table level by using the CREATE
TABLE command?
a. 0
b. 1
c. 12
d. 30
e. 255
_____________ dictates the type of physical access control and is primary consideration in physical security planning. a. Software b. Personnel c. Location d. Sets of Equipment
_____________ dictates the type of physical access control and is primary consideration in physical security planning. a. Software b. Personnel c. Location d. Sets of Equipment