1. Which of the following commands can be used to change a password for a user account? a. ALTER PASSWORD b. CHANGE PASSWORD c. MODIFY USER PASSWORD d. ALTER USER … PASSWORD e. none of the above 2. …

1. Which of the following commands can be used to change a password for a user account?
a. ALTER PASSWORD
b. CHANGE PASSWORD
c. MODIFY USER PASSWORD
d. ALTER USER … PASSWORD
e. none of the above
2. Which of the following statements assigns the role CUSTOMERREP as the default role for
Maurice Cain?
a. ALTER ROLE mcain
DEFAULT ROLE customerrep;
b. ALTER USER mcain
TO customerrep;
c. SET DEFAULT ROLE customerrep
FOR mcain;
d. ALTER USER mcain
DEFAULT ROLE customerrep;
e. SET ROLE customerrep
FOR mcain;

What is the purpose of the Express.js app.use() method? Question 4 options: B) To handle HTTP requests based on the URL and HTTP method C) To render a view template in the application D) To redirect t…

What is the purpose of the Express.js app.use() method?

Question 4 options:

B) To handle HTTP requests based on the URL and HTTP method

C) To render a view template in the application

D) To redirect the client to a different URL

A) To add middleware to the application

Which of the following is a templating engine commonly used with Express.js? Question 2 options: C) Handlebars A) React D) Vue.js B) Angular

Which of the following is a templating engine commonly used with Express.js?

Question 2 options:

C) Handlebars

A) React

D) Vue.js

B) Angular

Which of the following HTTP methods is used to retrieve data from the server in Express.js? Question 1 options: D) DELETE C) PUT B) POST A) GET

Which of the following HTTP methods is used to retrieve data from the server in Express.js?

Question 1 options:

D) DELETE

C) PUT

B) POST

A) GET

If a column has high selectivity or cardinality, which index type is most appropriate? a. IOT b. B-tree c. bitmap d. function-based index 11. If a column has low selectivity, this means: a. The column…

If a column has high selectivity or cardinality, which index type is most appropriate?
a. IOT
b. B-tree
c. bitmap
d. function-based index
11. If a column has low selectivity, this means:
a. The column contains many distinct values.
b. The column contains a small number of distinct values.
c. A WHERE clause is always used in a query on the column.
d. The selectivity of a column can’t be determined.
12. Oracle 12c automatically creates an index for which type of constraints?
a. NOT NULL
b. PRIMARY KEY
c. FOREIGN KEY
d. UNIQUE KEY
e. none of the above
f. only a and b
g. only b and d
13. Which of the following settings can’t be modified with the ALTER SEQUENCE command?
a. INCREMENT BY
b. MAXVALUE
c. START WITH
d. MINVALUE
e. CACHE
14. Which node of the B-tree index contains ROWIDs?
a. branch blocks
b. root block
c. leaf blocks
d. None of the above because the primary key is used to identify rows.
15. If the CACHE or NOCACHE options aren’t included in the CREATE SEQUENCE
command, which of the following statements is correct?
a. Oracle 12c generates 20 integers automatically and stores them in memory.
b. No integers are cached by default.
c. Only one integer is cached at a time.
d. The command will fail.
e. Oracle 12c g

Suppose the user Juan creates a table called MYTABLE with four columns. The first column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint, the third column has a CHECK constra…

Suppose the user Juan creates a table called MYTABLE with four columns. The first
column has a PRIMARY KEY constraint, the second column has a NOT NULL constraint,
the third column has a CHECK constraint, and the fourth column has a FOREIGN KEY
constraint. Given this information, how many indexes does Oracle 12c create automatically
when the table and constraints are created?
a. 0
b. 1
c. 2
d. 3
e. 4
7. Given the table created in Question 6, which of the following commands can Juan use to
create a synonym that allows anyone to access the table without having to identify his
schema in the table reference?
a. CREATE SYNONYM thetable
FOR juan.mytable;
b. CREATE PUBLIC SYNONYM thetable
FOR mytable;
c. CREATE SYNONYM juan
FOR mytable;
d. none of the above
8. Which of the following statements is true?
a. A gap can appear in a sequence created with the NOCACHE option if the system
crashes before a user can commit a transaction.
b. Any unassigned sequence values appears in the USER_SEQUENCE data dictionary
table as unassigned.
c. Only the user who creates a sequence is allowed to delete it.
d. Only the user who created a sequence is allowed to use the value generated by the
sequence.
9. When is creating an index manually inappropriate?
a. when queries return a large percentage of rows in the results
b. when the table is small
c. when the majority of table operations are updates
d. all of the above
e. only a and c

1. Which of the following generates a series of integers that can be stored in a database? a. a number generator b. a view c. a sequence d. an index e. a synonym 2. Which syntax is correct for removin…

1. Which of the following generates a series of integers that can be stored in a database?
a. a number generator
b. a view
c. a sequence
d. an index
e. a synonym
2. Which syntax is correct for removing a public synonym?
a. DROP SYNONYM synonymname;
b. DELETE PUBLIC SYNONYM synonymname;
c. DROP PUBLIC SYNONYM synonymname;
d. DELETE SYNONYM synonymname;
3. Which of the following commands can you use to modify an index?
a. ALTER SESSION
b. ALTER TABLE
c. MODIFY INDEX
d. ALTER INDEX
e. none of the above
4. Which of the following generates an integer in a sequence?
a. NEXTVAL
b. CURVAL
c. NEXT_VALUE
d. CURR_VALUE
e. NEXT_VAL
f. CUR_VAL

Which type of systems we have in the SAP S/4HANA Cloud 3-Sytem Landscape (3SL)?   Productive system Test system Quality system Development system Evaluation system Demo system

Which type of systems we have in the SAP S/4HANA Cloud 3-Sytem Landscape (3SL)? Productive systemTest systemQuality systemDevelopment systemEvaluation systemDemo system

Which is true about NETWORK SECURITY POLICIES? A. A. Embedded in the firewall software dictate access B. B. This does not interfere with controls a. Both are incorrect b. Only B is correct c. Only A i…

Which is true about NETWORK SECURITY POLICIES? A. A. Embedded in the firewall software dictate access B. B. This does not interfere with controls a. Both are incorrect b. Only B is correct c. Only A is correct d. A and B are correct