QUESTION 1What determines which bits in an IP address represent the subnet, and which represent the host? A. SubnetB. unicastC. netmaskD. multicastE. broadcast Answer: C
QUESTION 1What can you do with the DBMS_LOB package? A. Use the DBMS_LOB.WRITE procedure to write data to a BFILE.B. Use the DBMS_LOB.BFILENAME function to locate an external BFILE.C. Use the DBMS_LOB.FILEEXISTS function to find the location of a BFILE.D. Use the DBMS_LOB.FILECLOSE procedure to close the file being accessed. Answer: D
QUESTION 1Examine the parameters for your database instance:NAMETYPE VALUE————————– ——————————- —————————undo_management string AUTOundo_retentioninteger 12 00undo_tablespace string UNDOTBS1You execute the following command:SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;Which statement is true in this scenario? A. Undo data is written to flashback logs after 1200 seconds.B. Inactive undo data is retained for 1200 seconds even if subsequent transactions […]
QUESTION 1You need to create a table for a banking application. One of the columns in the table has the following requirements:1) You want a column in the table to store the duration of the credit period.2) The data in the column should be stored in a format such that it can be easily added […]
QUESTION 1You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.How can you detect the cause of the degraded performance? A. Enable Memory Access Mode, which reads performance data from […]
QUESTION 1As part of archiving the historical data, you want to transfer data from one database to another database, which is on another server. All tablespaces in the source database are read/write and online. The source and target databases use the same compatibility level and character sets. View the Exhibit and examine the features in […]
QUESTION 1Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two.) A. An extent cannot spread across data files.B. A segment cannot spread across data files.C. A data file can belong to only one tablespace.D. A data file can have only one segment created in it.E. A […]
QUESTION 1Which two statements below could explain why the vSphere Client is reporting N/A for hyperthreading? (Choose two.) A. The physical CPUs in the host do not support hyperthreading.B. Hyperthreading is disabled in the host’s BIOS.C. The physical CPUs in the host are not multi-core.D. The number of CPUs meets or exceeds the maximum without […]
QUESTION 1The VMware vCenter Server Appliance has been deployed using default settings.What user name and password are used to log in to the administration interface to configure the appliance? A. The initial user name and password must be supplied on the first login attempt.B. The initial user name and password must be supplied during deployment.C. […]
QUESTION 1A user has a perimeter firewall and up-to-date antivirus software. The user is asking what else they can do to improve their security. Which of the following will have the MOST impact on network security? (Select TWO). A. Install additional antivirus softwareB. Disable screen saversC. Conduct a daily security auditD. Assign security rights based […]
QUESTION 1 Small form factor PCs that utilize full-height PCI and PCI-Express cards need which of the following supplementary items to allow for proper installation? A. FireWire cards B. Riser cards C. Storage cards D. Network cards Answer: B
QUESTION 1Evaluate the following CREATE TABLE commands:CREATE TABLE orders(ord_no NUMBER(2) CONSTRAINT ord_pk PRIMARY KEY,ord_date DATE,cust_id NUMBER(4));CREATE TABLE ord_items(ord_no NUMBER(2),item_no NUMBER(3),qty NUMBER(3) CHECK (qty BETWEEN 100 AND 200),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT it_pk PRIMARY KEY (ord_no,item_no),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));The above command fails when executed. What could be the reason? A. SYSDATE cannot be […]
QUESTION 1Which of the following protocols operates at the HIGHEST level of the OSI model? A. ICMPB. IPSecC. SCPD. TCP Answer: C
QUESTION 1 An administrator has a network subnet dedicated to a group of users. Due to concerns regarding data and network security, the administrator desires to provide network access for this group only. Which of the following would BEST address this desire? A. Install a proxy server between the users’ computers and the switch to […]
QUESTION 1New Simulation: Crimp out a T568B. Answer: White/Orange, Orange, White/Green, Blue, White/Blue, Green, White/Brown, Brown.Explanation:
