Discussion
Home ‣ Certification ‣ Oracle Certification See What Others Are Saying!
- Question
What are the different types of SQL statements ?
- Correct Answer
- SQL statements are broadly classified into three They are 1 DDL ? Data Definition Language DDL is used to define the structure that holds the data For example, Create, Alter, Drop and Truncate table 2 DML ? Data Manipulation Language DML is used for manipulation of the data itself Typical operations are Insert, Delete, Update and retrieving the data from the table The Select statement is considered as a limited version of the DML, since it can't change the data in the database But it can perform operations on data retrieved from the DBMS, before the results are returned to the calling function 3 DCL ? Data Control Language DCL is used to control the visibility of data like granting database access and set privileges to create tables, etc Example - Grant, Revoke access permission to the user to access data in the database
- 1. If you wanted administrators to see a message when logging into the router, which command would you use?
Options- A. message banner motd
- B. banner message motd
- C. banner motd
- D. message motd Discuss
- 2. At which layer of the OSI model would you assume the problem is if you type show interface serial 1 and receive the following message? Serial 1 is down, line protocol is down
Options- A. Physical layer
- B. Data Link layer
- C. Network layer
- D. None Discuss
- 3. Which commands loads a new version of the Cisco IOS into a router?
Options- A. copy flash ftp
- B. copy ftp flash
- C. copy flash tftp
- D. copy tftp flash Discuss
- 4. What is the command to copy a Cisco IOS to a TFTP server? Discuss
- 5. When a PC sends a packet to another PC in a remote network, what destination IP address and MAC address will be in the frame that it sends to its default gateway? Discuss
- 6. What is the administrative distance of OSPF?
Options- A. 90
- B. 100
- C. 110
- D. 120 Discuss
- 7. With which network type will OSPF establish router adjacencies but not perform the DR/BDR election process?
Options- A. Point-to-Point
- B. Backbone area 0
- C. Broadcast multi-access
- D. Non-broadcast multi-access Discuss
- 8. A network administrator needs to configure a router with a distance-vector protocol that allows classless routing. Which of the following satisfies those requirements?
Options- A. IGRP
- B. OSPF
- C. RIPv1
- D. EIGRP Discuss
- 9. You get a call from a network administrator who tells you that he typed the following into his router: Router (config) #router ospf 1 Router (config-router) # network 10.0.0.0. 255. 0.0.0 area 0 He tells you he still can't see any routes in the routing table. What configuration error did the administrator make?
Options- A. The wildcard mask is incorrect
- B. The OSPF area is wrong
- C. The OSPF Process ID is incorrect.
- D. The AS configuration is wrong Discuss
- 10. Which proprietary Cisco STP extensions would put a switch port into err-disabled if a BPDU is received on this port? Discuss
More questions
Correct Answer: banner motd
Explanation:
The typical banner is a message of the day (MOTD) and is set by using the global configuration mode command banner motd.
Correct Answer: Physical layer
Explanation:
If you see that a serial interface and the protocol are both down, then you have a physical layer problem. If you see serial 1 is up, line protocol is down, then you are not receiving (Data Link) Keepalives from the remote end.
Correct Answer: copy tftp flash
Explanation:
The command copy tftp flash will allow you to copy a new IOS into flash memory on your router.
Correct Answer: copy flash tftp
Correct Answer: It will use the gateway interface MAC at L2 and the actual destination IP at L3
Correct Answer: 110
Explanation:
The administrative distance (AD) is a very important parameter in a routing protocol. The lower the AD, the more trusted the route. If you have IGRP and OSPF running , by default IGRP routes would be placed in the routing table because IGRP has a lower AD of 100. OSPF has an AD of 110. RIPv1 and RIPv2 both have an AD of 120, and EIGRP is the lowest, at 90.
Correct Answer: Point-to-Point
Explanation:
No DR is assigned on any type of point-to-point link. No DR/BDR is assigned on the NBMA point-to-multipoint due to the hub/spoke topology. DR and BDR are elected on broadcast and non-broadcast multi-access network. Frame relay is a non-broadcast multiaccess (NBMA) network by default.
Correct Answer: EIGRP
Explanation:
In this question, we're calling EIGRP just plain old distance vector. EIGRP is an advanced distance-vector routing protocol, sometimes called a hybrid routing protocol because it uses the characteristics of both distance-vector and link-state routing protocols.
Correct Answer: The wildcard mask is incorrect
Explanation:
The administrator typed in the wrong wildcard mask configuration. The wildcard should have been 0.0.0.255 or even 0.255.255.255.
Correct Answer: BPDUGuard
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.