Technical Test | Synoriq | Campus Recruitment Drive

The command used to give privileges to database users in RDBMS is GRANT. This command allows the database administrator to grant specific privileges such as SELECT, INSERT, UPDATE, DELETE, etc., to users or user groups. It is an essential command for managing user access and permissions in a relational database management system.

In a sequential search, the algorithm starts searching from the beginning of the list and compares each element with the target element until a match is found or the end of the list is reached. The formula (N+1)/2 represents the average number of comparisons required in a sequential search. This formula takes into account that, on average, the target element is likely to be found in the middle of the list. Therefore, the number of comparisons needed is half of the total number of elements (N), plus one.

The given code defines a function called "fun" that takes an integer "n" and an array "arr" as parameters. Inside the function, a pointer variable "p" is declared and initialized to 0. Then, a loop is executed where the variable "i" is incremented by 1 on each iteration until it is greater than "n". In each iteration, the value at the memory location pointed by "p" is assigned to the element at index "i" of the array "arr". Finally, in the main function, the "fun" function is called with arguments 4 and "arr". After the function call, a loop is executed to print the elements of the array "arr". Therefore, the output will be 1, 2, 3, 4.

The correct answer is "Human Interface Guidelines." This is the name of the design language standards as described by Apple. These guidelines provide developers with recommendations and best practices for creating user interfaces that are consistent and intuitive across Apple devices. They cover various aspects such as layout, typography, color, and interaction patterns to ensure a cohesive and user-friendly experience for Apple users.

An outer join returns all the records from both tables, including the unmatched records. Therefore, it has the potential to return the maximum number of records compared to other join types.

The correct answer is both B and C. The function should be defined as int f(int a, int b) because the return type is missing. Additionally, there is a redeclaration of the variable "a" within the function, which is not allowed.

The given code snippet uses a switch statement to check the value of the variable "color". Since the value of "color" is 2, it matches with the case 2 and the code block under it is executed. Therefore, the output will be "green". However, there are no break statements after each case, so the code will continue to execute the code blocks under the subsequent cases as well. As a result, the output will be "green aqua other".

The correct answer is "char name[6]= { ‘I’, ‘N’, ‘D’, ‘I’, ‘A’, ‘\0’};". This is the correct syntax for storing the word "INDIA" in a character array in C programming. The array is declared as "name" with a size of 6, which is enough to store the characters of the word "INDIA" plus the null character '\0' at the end to indicate the end of the string. Each character is enclosed in single quotes and separated by commas.

A style sheet is used to define the visual appearance of a website or document. It includes specifications for elements such as font, colors, and layout. While type face (font), CMYK colors, and RGB colors are all commonly included in a style sheet to determine the visual aspects of text and graphics, logo design is not typically included in a style sheet. Logo design refers to the creation of a unique symbol or graphic that represents a brand or organization, and is usually separate from the overall visual design specifications of a website or document.

The given code snippet includes two for loops, one iterating N times and the other iterating M times. Inside each loop, the variable a is incremented by the random number generated by the rand() function. Similarly, the variable b is incremented by the random number generated in the second for loop.

Since the two for loops are independent and not nested, the time complexity of the code is O(N+M). This is because the time taken to execute the first loop is proportional to N, and the time taken to execute the second loop is proportional to M.

The space complexity of the code is O(1) because the variables a and b are the only additional space used, and they do not depend on the size of N or M.

The code snippet is using the sizeof() function to determine the size of a void pointer. In this case, the size of a void pointer is 8 bytes because the code is compiled using a 64-bit compiler. In a 64-bit system, the size of a pointer is typically 8 bytes.

The code defines a structure named "node" with three integer variables: a, b, and c. It then creates an instance of the structure named "num" with the values 3, 5, and 6 assigned to its variables.

Next, a pointer named "ptr" is created and assigned the address of the "num" instance.

The printf statement is used to print the value at a specific memory location. The expression *((int*)ptr + 1 + (3-2)) is used to calculate the memory location.

Here, ptr is cast to a pointer to an int and then incremented by 1. The expression (3-2) evaluates to 1. So, the final expression becomes *((int*)ptr + 1 + 1), which points to the second int variable in the structure.

Therefore, the value printed is 6.

The resolution that is commonly used while creating a website mockup in Adobe Photoshop is 72 ppi. This is because web graphics are typically displayed on screens with a standard resolution of 72 pixels per inch. Using a higher resolution such as 300 ppi or 150 ppi would result in larger file sizes and slower loading times, without any noticeable improvement in image quality on screen. Therefore, it is recommended to use a resolution of 72 ppi for web design mockups.

Foundation is a CSS framework similar to Bootstrap. It provides a collection of pre-designed and pre-built components, such as grids, buttons, forms, and navigation, that can be easily customized and used to create responsive and visually appealing websites. Like Bootstrap, Foundation also offers a responsive grid system, responsive typography, and a variety of UI components that help streamline the web development process and ensure consistent design across different devices and screen sizes.

Oracle is not a relational database because it is actually a hybrid database that combines elements of both relational and object-oriented databases. While it does support relational database management system (RDBMS) functionality, it also includes features for managing complex data types and structures, making it more versatile than a traditional relational database.