Tag Archives: sales

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf SIZE

You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE ‘/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.) A. It must be smaller than the smallest BIGFILE tablespace B. Free space is managed using freelists C. Any data files added to the tablespace must have a size… Read More »

A bookstore's sales are represented by a list of Sale objects populated with the name of the customer

A bookstore’s sales are represented by a list of Sale objects populated with the name of the customer and the books they purchased.public class Sale {private String customer;private List<Book> items;// constructor, setters and getters not shown}public class Book {private String name;private double price;// constructor, setters and getters not shown}Given a list of Sale objects, tList, which code fragment… Read More »

A company has an existing sales application using a Java 8 jar file containing packages: com.company.customer;

A company has an existing sales application using a Java 8 jar file containing packages:com.company.customer;com.company.customer.orders;com.company.customer.info;com.company.sales;com.company.sales.leads;com.company.sales.closed;com.company.orders;com.company.orders.pending;com.company.orders.shipped.To modularize this jar file into three modules, customer, sales, and orders, which module-info.java would be correct?A)B)C)D) A. Option A B. Option D C. Option C D. Option B Correct Answer: C

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE `/u01/app/oracle/sales01.dbf SIZE

You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE `/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two statements are true about the SALES tablespace? (Choose two.) A. Any data files added to the tablespace must have a size of 5 gigabytes B. It uses the database default blocksize C. Free space is managed using freelists D. It must be smaller than the… Read More »

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE. Examine this command: SQL&gt; CREATE TABLE

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.Examine this command:SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);Which segment or segments, if any, are created as a result of executing the command? A. T1, an index segment for the primary key, a LOB segment, and a lobindex segment B. T1, an index segment for the primary key, and a… Read More »

A bookstore's sales are represented by a list of Sale objects populated with the name of the customer

A bookstore’s sales are represented by a list of Sale objects populated with the name of the customer and the books they purchased.public class Sale {private String customer;private List<Book> items;// constructor, setters and getters not shown}public class Book {private String name;private double price;// constructor, setters and getters not shown}Given a list of Sale objects, tList, which code fragment… Read More »

A company has an existing sales application using a Java 8 jar file containing packages: com.company.customer;

A company has an existing sales application using a Java 8 jar file containing packages:com.company.customer;com.company.customer.orders;com.company.customer.info;com.company.sales;com.company.sales.leads;com.company.sales.closed;com.company.orders;com.company.orders.pending;com.company.orders.shipped.To modularize this jar file into three modules, customer, sales, and orders, which module-info.java would be correct?A)B)C)D) A. Option B B. Option A C. Option D D. Option C Correct Answer: D

A company has an existing sales application using a Java 8 jar file containing packages: com.company.customer;

A company has an existing sales application using a Java 8 jar file containing packages:com.company.customer;com.company.customer.orders;com.company.customer.info;com.company.sales;com.company.sales.leads;com.company.sales.closed;com.company.orders;com.company.orders.pending;com.company.orders.shipped.To modularize this jar file into three modules, customer, sales, and orders, which module-info.java would be correct?A)B)C)D) A. Option D B. Option B C. Option C D. Option A Correct Answer: C

A company has an existing sales application using a Java 8 jar file containing packages: com.company.customer;

A company has an existing sales application using a Java 8 jar file containing packages:com.company.customer;com.company.customer.orders;com.company.customer.info;com.company.sales;com.company.sales.leads;com.company.sales.closed;com.company.orders;com.company.orders.pending;com.company.orders.shipped.To modularize this jar file into three modules, customer, sales, and orders, which module-info.java would be correct?A)B)C)D) A. Option B B. Option C C. Option D D. Option A Correct Answer: B

A bookstore's sales are represented by a list of Sale objects populated with the name of the customer

A bookstore’s sales are represented by a list of Sale objects populated with the name of the customer and the books they purchased.public class Sale {private String customer;private List<Book> items;// constructor, setters and getters not shown}public class Book {private String name;private double price;// constructor, setters and getters not shown}Given a list of Sale objects, tList, which code fragment… Read More »