GuideFoot - Learn Together, Grow Smarter. Logo

Questions in computers-and-technology

📝 Answered - Write SQL commands for the following queries (i) to (iv) based on the relations TRAINER and COURSE given below: TRAINER Table: | TID | TNAME | CITY | HIREDATE | SALARY | |-----|------------|------------|------------|--------| | 101 | SUNAINA | MUMBAI | 1998-10-15 | 90000 | | 102 | ANAMIKA | DELHI | 1994-12-24 | 80000 | | 103 | DEEPTI | CHANDIGARG | 2001-12-21 | 82000 | | 104 | MEENAKSHI | DELHI | 2002-12-25 | 78000 | | 105 | RICHA | MUMBAI | 1996-01-12 | 95000 | | 106 | MANIPRABHA | CHENNAI | 2001-12-12 | 69000 | COURSE Table: | CID | CNAME | FEES | STARTDATE | TID | |------|---------|-------|------------|-----| | C201 | AGDCA | 12000 | 2018-07-02 | 101 | | C202 | ADCA | 15000 | 2018-07-15 | 103 | | C203 | DCA | 10000 | 2018-10-01 | 102 | | C204 | DDTP | 9000 | 2018-09-15 | 104 | | C205 | DHN | 20000 | 2018-08-01 | 101 | | C206 | O LEVEL | 18000 | 2018-07-25 | 105 | I. Display all details of Trainers who are living in city CHENNAI. II. Count and Display the number of Trainers in each city. III. Display the Course details which have Fees more than 12000 and name ends with 'A'. IV. (A) Display the Trainer Name & Course Name from both tables where Course Fees is less than 10000. OR (B) Display the Cartesian Product of above two tables.

📝 Answered - Where do you input the website you want to visit? A. Address bank B. Login prompt C. Bookmark D. Address bar

📝 Answered - Which vertical design should be prioritized for guest Wi-Fi, conference areas, and network security? Options: - Hospitality - Multi-dwelling unit (MDU) - Education - Warehouse

📝 Answered - To make GitHub Copilot understand the existing code snippet—the methods, variables, etc.—the names should: Select one: A. All of the listed options B. Use proper naming conventions C. Add inline comments D. Have relevance to the usage

📝 Answered - How many different ways are there to save a document? A. Two B. One C. Four D. Three

📝 Answered - Which of the following statements is not TRUE regarding roles and profiles in SAP Basis? (Select ALL that apply) A) A profile can contain multiple roles B) Profiles can be directly granted to user C) Roles can reference multiple profiles D) Roles can be granted to user accounts

📝 Answered - Discuss one type of algorithm approach to use. Share one example of when you would use your selected type of algorithm. Explain why the characteristics associated with this algorithm make it a good fit for the example.

📝 Answered - What former employee returned to Apple and then introduced the iMac in 1998? A. Steve Jobs B. Jef Raskin C. Steve Wozniak D. Bud Tribble

📝 Answered - How do the functions of ICT tools support one another to complete a task?

📝 Answered - The primary unit of data storage in the personal computer is the Select one: a. external cache b. hard disk drive c. RAM d. media card