Welcome to your Data/Engineering Name Phone Email What is data engineering? Analyzing data patterns Designing data visualizations Managing and processing data pipelines Predicting future trends based on data All of the above Which of the following tasks is NOT a part of data engineering? Data collection Data visualization Data transformation Data storage All of the above What is the process of cleaning, normalizing, and transforming raw data to make it suitable for analysis? Data integration Data warehousing Data preparation Data visualization All of the above What is the purpose of a data warehouse in data engineering? Real-time data processing Data storage for business analytics Data transformation for machine learning Data visualization for stakeholders All of the above Which of the following joins can be used to perform the cartesian product of two tables Cross Join Full outer join Left join Inner join None of the above As the analytics manager of a 50-person e-commerce company selling mobile phones, you received a product file from a manufacturer to ensure all their products are listed on your site. However, a query on your Phone table shows no matches. What steps do you take to resolve this? Go back to the manufacturer and ask them to send a correct list with codes in your format. Conclude none of their inventory is currently available on your site. Ask one of your analysts if there is a table which maps your codes to your manufacturer codes. Go back to the manufacturer and get them to send a list with the product name instead of the product code, and use this to match against your products names. All of these would be good decisions. Which of the following regarding APIs is not true? APIs are often accompanied by documentation which explains how to use the API. Good APIs provide a clear and easy way for someone to obtain data from another system. Most APIs require some kind of authentication to be able to actually obtain real data. The data format returned by APIs is normally tabular, such as csv or tsv. If you were calling an API to update some data, you would use the PUT method. None of the above Generally speaking, in a standard relational database, which is true? A primary key in one table cannot be a foreign key in another table. Most data is stored as a string (varchar) which maximises flexibility. Data is stored in tables, with columns or fields representing features of the data. Data is stored in tables, with each column including a JSON object representing a feature of the data. Connecting to databases is always done via a GUI such as MySQL Workbench, or pgAdmin. Which of the following is NOT an aggregate function in SQL? AVG COUNT ORDER BY SUM MIN You are given a table named "Countries", how can you return all the records from this table sorted descending by "Name"? SELECT * FROM Countries SORT Name DESC SELECT * FROM Countries ORDER Name DESC SELECT * FROM Countries SORT BY Name SELECT * FROM Countries ORDER BY Name DESC SELECT * FROM Countries SORT BY Name DESC None of the above how do you select all the records from a table named "Apollo" where the "Name" is alphabetically between (and including) "Ali" and "Mohamed"? SELECT * FROM Apollo WHERE Name>'Ali' AND Name<'Mohamed' SELECT * FROM Apollo WHERE Name BETWEEN 'Ali' AND 'Mohamed' SELECT Name>'Ali' AND Name<'Mohamed' FROM Apollo The following SQL is which type of join? Equi-join Natural join Outer join Cartesian join Which of the following statements is true concerning subqueries? Involves the use of an inner and outer query. Cannot return the same result as a query that is not a subquery. Does not start with the word SELECT. All of the above. What type of join is needed when you wish to include rows that do not have matching values? Equi-join Natural join Outer join All of the above. With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible. True False In Python, you have defined a tuple as: tup = (1, 2, 3, 4, 5). Now, you want to update the value of the third item, 3, to 10. Which of the following options will you choose? tup(3) = 10 tup[2] = 10 tup[3] = 10 tup(2) = 10 All of the above None of the above What will the following code output? [1, 4, 9, 16, 25] [1, 4, 9, 16, 25, 36] [2, 4, 6, 8, 10] What does the zip() function in Python do? Combines two lists into a dictionary. Combines two lists into a list of tuples. Concatenates two lists into a single list. Reverses the order of elements in a list. What will be the output of the following code? [1, 2, 3, 4] [1, 2, 3] [1, 2, 3, 4, 4] [1, 2, 3, 4, 4, 4] Time's up
Welcome to your Laravel/vue Name Phone Email Eloquent mutator is: A transformation layer that sites between your eloquent model and the JSON responses that actually returned to your application's A mechanism that transforms an Eloquent attribute value when it is set A mechanism that transforms an Eloquent attribute value when it is accessed Laravel service providers are: Interfaces that allows the developer to use underlying classes in the service container The central place of all Laravel core services A tool to manage and resolve dependencies of your application In Laravel we use gates to: Classes that allows you to define and share the application's database schema Classes that organize authorization logic around a particular model or resource Authorize user actions against a given resource Laravel does not support gates Bootstrap directory is used to: Load configuration files Load Laravel classes and model Initialize a Laravel application Laravel facades are: A mechanism to filter requests coming to your application A static interface to use classes that are available in the service container of Laravel A way to mutate fields fetched from the database A way to abstract the functionality of certain Laravel classes Using the query builder, how to count the number of rows in a table? DB::table('articles')->total(); DB::table('articles')->rowCount(); DB::table('articles')->withCount(); DB::table('articles')->count(); Which of the following is the correct way to define a one to many relationship in Laravel? class User extends Model { public function posts() { return $this->hasMany(Post::class); } class User extends Model { public function posts() { return $this->belongsTo(Post::class); } } class User extends Model { public function posts() { return $this->hasOne(Post::class); } } class User extends Model { public function posts() { return $this->belongsToMany(Post::class); } } In Vue.js what is the difference between v-if and v-show? v-if renders the element only if the condition is true, while v-show toggles the element's visibility v-if toggle the element's visibility, while v-show renders the element conditionally v-if uses CSS to toggle the element's visibility, while v-show re-renders the element only if condition is true there is no difference between v-if and v-show What are Vue.js filters? A way that allows us to apply filters on array of data A way to filter input and do input validation A mechanism that allows us to apply common text formatting There is no concept of filters in Vue.js Which of the following directives is used for attaching event listeners that invoke methods? v-model v-on v-for v-if Where can Vue.js filters can be applied v-bind expressions Mustache interpolations Mustache interpolations and v-bind expressions v-bind and v-html expressions What are mixins? A method for distributing reusable style snippets to the Vue component A method for enabling global styling for the application A method for distributing reusable features to the Vue component How can you define reactive computed properties in composition-api? Use the computed property of the component instance. Use the computed function passed to the setup() function. Use the computed object. Use the ref object. In Vue.js, How we can create a two-way data binding for an input element? Time's up
Welcome to your Flutter test Name Phone Email What is Flutter? a. A database management system b. A programming language c. A cross-platform UI toolkit d. A version control system What is a widget in Flutter? a. An algorithm for sorting data b. A type of bug in code c. A basic building block of the user interface d. A data structure for storing app data Which file is used to declare app metadata and dependencies in a Flutter project? a. main.dart b. pubspec.yaml c. AndroidManifest.xml d. build.gradle What is the purpose of the setState method in Flutter? a. To update the device's state b. To change the app's theme c. To rebuild the widget's UI when its state changes d. To fetch data from a remote server Which widget is used to create a scrollable list of widgets in Flutter? a. Column b. Row c. ListView d. Container In Flutter, what does "hot reload" do? It restarts the app. It recompiles the entire app. It installs a new version of Flutter. It rebuilds the UI without restarting the app. What is the main function used for in a Flutter app? To define the app's color scheme To specify the app's entry point To configure the app's navigation To declare app-wide constants What is the purpose of a class in Dart? To create a blueprint for objects To group related variables and functions together To define a type of data All of the above What is the difference between an instance and a class? An instance is a specific object of a class. A class is a general concept, while an instance is a specific example of that concept. An instance is a variable, while a class is a data type. All of the above What is the purpose of a constructor in Dart? To initialize an object's state To create an instance of a class To define a method for a class All of the above What is the purpose of an exception in Dart? To handle errors To prevent code from crashing To throw an error when an unexpected situation occurs All of the above What is the purpose of the late keyword in Dart? To defer the initialization of a variable until it is first used. To improve performance by delaying unnecessary memory allocation. To make code more readable and maintainable. All of the above What is the difference between git fetch and git pull? git fetch only downloads changes from the remote repository, while git pull downloads and merges changes. git fetch updates the remote tracking branches, while git pull updates the local branches. git fetch is a safer command than git pull, as it does not attempt to merge changes. All of the above. 1 out of 13 Time's up