Question
You can add a row using SQL in a database with which of the following?
The command to remove rows from a table 'CUSTOMER' is:
The SQL WHERE clause:
The wildcard in a WHERE clause is useful when?
A view is which of the following?
The command to eliminate a table from a database is:
SQL data definition commands make up a(n) ________
Which of the following is the correct order of keywords for SQL SELECT statements?
A subquery in a SQL SELECT statement is enclosed in:
Which of the following are the five built-in functions provided by SQL?
In a SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Which of the following do you need to consider when you make a table in SQL?
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Which one of the following sorts rows in SQL?
SQL can be used to:
The SQL keyword BETWEEN is used:
Which of the following is not a valid table join type in SQL?
Which of the following services use TCP? (Choose Two)
In which layer in the TCP/IP stack does the SSL handshake occur?
Which of the following is a private IP address?
What protocol is used to find the hardware address of a local device?
Which protocol does DHCP use at the Transport layer?
Which protocol does Ping use?
You want to implement a mechanism that automates the IP configuration, including IP address, subnet mask, default gateway, and DNS information. Which protocol will you use to accomplish this?
Which device can be used to route IP addresses? (Choose Two)
How long is an IPv6 address?
What protocol is used between E-Mail servers?
If you are required to request a new IP address to the DHCP server, which command would you run?
How can the DNS cache be deleted?
What command can be used in Linux to resolve hostnames?
What is the equivalent to task manager in Linux?
Which command is/are used to remove directory in Linux?
Which directory in Linux contains all the config file of the system?
Suppose I am in /etc directory and I want to go to my home directory which command should I use?
Which command(s) is/are used to get help about a command in Linux? (Choose Two)
Which command is used to list all the files in your current directory(including hidden)?
Which command is used to create file in Linux?
In Linux everything stored as a:
Which of the following command(s) is/are used to reboot a Linux system?
A swap partition is actually:
To search a pattern in a file _________ can be used
The mounted partition information is stored in:
_______ will add contents to an existing file
Explain what is the major difference between NTFS ( New Technology File System) or FAT (File Allocation Table) on a local server?
Which file contains all of the Active Directory Database and all of the AD objects?
How do you install the default Telnet Client on Windows Server 2012?
What is a Global Catalogue?
From the following Hypervisors, which one runs directly on the system hardware?
What is the command for viewing the system information in Windows?
What is the SysWOW64 folder in Windows?
What is the equivalent in Mac OS X for HKEY_CURRENT_USER in the Windows Registry?
What is the default folder for applications on MAC OS?
How do you uninstall an application on MAC?
How do you find the MAC OS version?
What protocols and ports can Active Directory use for communication? (Choose Two)
How do I manage drivers for connecting to databases?
What is a Domain Trust?
What dependencies are required to install a new Active Directory on Windows Server?
Can this IP address be assigned to a computer: 192.168.1.255/24
What is a Router?
Which protocol is used for a secure browser internet connection?
What is DNS?
What is a Proxy ?
What is ARP?
How do you list the contents of a directory in Linux ?
How do you change between directories in Linux?
Name a command that elevates a user to super user in Linux
Name a common text editor in Linux
What Linux command is used to change permissions on a directory/file?
In relation to permissions on Linux, what does 777 mean?
What is a common Linux command to install applications? (Choose Two)
How do you change the system locale on Windows 7/10?
