Accenture
Primers
Assessments
Accenture Dumps
Coding Bank
Blog
Topics
Must Know
Mock Assessment 2026
Complete Question Index
Browse through all 2134 assessment questions (Page 4 of 15)
Database Management • Data Manipulation Language
Which statement would you use to add a primary key constraint to the patient table using the id_number column, immediately enabling the constraint?
Database Management • Data Manipulation Language
Composite key is used in one to one relationship. State true or false.
Database Management • Data Manipulation Language
Which CREATE TABLE statement is valid?
Database Management • Data Manipulation Language
Cascade constraints are used only in drop statements. State True or False.
Database Management • Function - Scalar & Aggregate
select substr("Oracle World",1,6) from dual;
Database Management • Function - Scalar & Aggregate
ABC company wants to give each employee a $100 salary increment. You need to evaluate the results from the EMP table prior to the actual modification....
Database Management • Function - Scalar & Aggregate
To display the names of all promos done after January 1, 2001 starting with the latest promo. Which query would give the required result? (Choose all ...
Database Management • Function - Scalar & Aggregate
Which statement is true regarding the default behavior of the ORDER BY clause?
Database Management • Function - Scalar & Aggregate
To calculate the number of days from 1st Jan 2007 till date: Dates are stored in the default format of dd-mm-rr. Which SQL statements would give the r...
Database Management • Function - Scalar & Aggregate
To generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should ha...
Database Management • Function - Scalar & Aggregate
The CUSTOMERS table has these columns: CUSTOMER_ID NUMBER(4) NOT NULL; CUSTOMER_NAME VARCHAR2(100) NOT NULL; CUSTOMER_ADDRESS VARCHAR2(150); CUSTOMER_...
Database Management • Function - Scalar & Aggregate
Generate a list of all customer last names with their credit limits from the CUSTOMERS table. Customers who do not have a credit limit should appear l...
Database Management • Function - Scalar & Aggregate
To display the names of employees that are not assigned to a department. Evaluate this SQL statement: SELECT last_name, first_name FROM employee WHERE...
Database Management • Function - Scalar & Aggregate
To update the CUST_CREDIT_LIMIT column to NULL for all the customers, where CUST_INCOME_LEVEL has NULL in the CUSTOMERS table. Which SQL statement wil...
Database Management • Rdbms Concepts
Tom has designed a payroll software for XYZ technology.The software will store the salary details into the database and later he can retrieve the same...
Database Management • Select Statement
Which statement is used to manipulate data without affecting the data in the table?
Database Management • Select Statement
Which operator is equivalent to the ‘or’ operator?
Database Management • Select Statement
How to retrieve department_id column without any duplication from employee relation?
Database Management • Select Statement
Select the suitable option for retrieving all the employees whose name ends with "kumar"?
Database Management • Select Statement
Select the suitable option for retrieving all the employees whose salary range is between 40000 and 100000?
Database Management • Select Statement
Which statement about SQL is true?
Database Management • Select Statement
Select the suitable option for retrieving all the employees who have a manager?
Database Management • Select Statement
Which statement is true regarding distinct keywords?
Database Management • Select Statement
You need to remove all the data from the employee table while leaving the table definition intact. You want to be able to undo this operation. How wou...
Database Management • Select Statement
Which option is used to delete data from both parent and child tables?
Database Management • Select Statement
How do we represent comments in oracle?
Database Management • Select Statement
Which query will change the cust_address to 'Panama' for those who are from ‘Los Angeles’?
Database Management • Select Statement
Which statement is used to update multiple rows in a single query?
Database Management • Select Statement
A DML statement is used to modify the structure of the database. State True or false.
Database Management • Select Statement
Which statements are true regarding constraints?
Database Management • Select Statement
Which query will delete all the data in the Employee table that belongs to the employee id 1207?
Database Management • Select Statement
Create table subjects(Sub_id number(2) primary key,Subj_name varchar(50)); Insert into subjects values (null,’Oracle’); What will be the output of the...
Database Management • Select Statement
Which statement is true when a DROP TABLE command is executed on a table?
Essentials • Genai
In a neural network, what does a neuron compute?
Essentials • Genai
Which function introduces non-linearity in a neural network?
Essentials • Genai
Which of the following is NOT a layer type in a typical neural network?
Essentials • Genai
Which application of ML is used to detect unusual patterns in data?
Essentials • Genai
In which type of ML does an agent learn by interacting with an environment?
Essentials • Genai
Which of the following is a common activation function in neural networks?
Essentials • Genai
How is a neural network's performance typically evaluated during training?
Essentials • Genai
Which of the following is a challenge in training deep neural networks?
Essentials • Genai
What is the role of the loss function in training a neural network?
Essentials • Genai
What is the primary purpose of backpropagation?
Essentials • Genai
What is the primary purpose of a loss function in training neural networks?
Essentials • Genai
Which of the following is a technique to prevent overfitting in neural networks?
Essentials • Genai
Which of the following is NOT a common machine learning algorithm?
Essentials • Genai
What is the main difference between regression and classification?
Essentials • Genai
What is the primary goal of machine learning?
Essentials • Genai
In the context of neural networks, what does the term "backpropagation" refer to?
Essentials • Genai
Which component of a neural network is responsible for combining inputs and passing them to the next layer?
Essentials • Genai
Which activation function outputs a value between 0 and 1?
Essentials • Genai
Which of the following is NOT a type of machine learning?
Essentials • Genai
Which application of ML is used to group similar items?
Essentials • Genai
Which of the following is NOT a direct application of the Transformer architecture?
Essentials • Genai
Which generative model introduced a stochastic layer that models data in a latent space?
Essentials • Genai
What is the primary advantage of Transformers over RNNs in terms of processing sequences?
Essentials • Genai
Which AI model series by OpenAI, based on the Transformer architecture, is known for generating highly coherent content?
Essentials • Genai
What mechanism allows the Transformer model to weigh the importance of different words in a sequence?
Essentials • Genai
Which model can transform horse photos into zebra photos without direct comparison?
Essentials • Genai
What is the main innovation introduced by the "Attention Is All You Need" paper?
Essentials • Genai
Which model is known for its rules for creating stable and effective AI image-makers?
Essentials • Genai
Which model demonstrated that using larger architectures can produce better images?
Essentials • Genai
In the context of GANs, what is the role of the Discriminator?
Essentials • Genai
Who introduced Generative Adversarial Networks (GANs)?
Essentials • Genai
What is the primary purpose of generative models?
Essentials • Genai
Which of the following research papers is foundational for Variational Autoencoders (VAEs)?
Essentials • Genai
Which model uses a probabilistic approach to encode and decode data?
Essentials • Genai
Which of the following is NOT a direct application of GANs but rather an outcome of its influence?
Essentials • Genai
In which year were Generative Adversarial Networks (GANs) first introduced?
Essentials • Genai
Which architecture is primarily associated with attention mechanisms?
Essentials • Genai
What are the two main components of a GAN?
Essentials • Genai
Which model marked a significant milestone in the use of transformers in NLP?
Essentials • Genai
Which pioneering research in Generative AI specifically emphasized the generation of text sequences?
Essentials • Genai
How might AI transform the fitting experience in fashion retail?
Essentials • Genai
What is a potential challenge of over-relying on AI in fashion?
Essentials • Genai
Which is a potential future application of Generative AI in fashion?
Essentials • Genai
What could be a futuristic application of Generative AI in creating personalized clothing?
Essentials • Genai
Which brand has utilized AI for generating new clothing designs?
Essentials • Genai
How can Generative AI contribute to sustainable fashion?
Essentials • Genai
What aspect of AI in fashion raises concerns about user privacy?
Essentials • Genai
In the context of sustainability, how might AI be used in material design?
Essentials • Genai
Who is a prominent virtual influencer mentioned in the case study?
Essentials • Genai
How can Generative AI potentially impact inventory management in fashion?
Essentials • Genai
Beyond body image standards, what's another ethical concern regarding virtual models?
Essentials • Genai
Why might there be concerns about an over-reliance on data-driven AI in fashion?
Essentials • Genai
How does AI enhance the shopping experience?
Essentials • Genai
What ethical concern arises from the use of virtual models in fashion?
Essentials • Genai
What is the global valuation of the fashion industry?
Essentials • Genai
If an AI system is designed to label images of cats and dogs, it is primarily a _______ model.
Essentials • Genai
Which AI type is best for predicting outcomes?
Essentials • Genai
Which is NOT a real-world application of Generative AI?
Essentials • Genai
Which of the following is a direct application of Generative AI in the entertainment industry?
Essentials • Genai
In the context of AI, which model type is more concerned with the underlying distribution of data?
Essentials • Genai
What is Generative AI primarily used for?
Essentials • Genai
Generative AI can be used to create which of the following?
Essentials • Genai
How does Generative AI differ from Classification AI?
Essentials • Genai
Which statement best describes the role of Generative AI?
Essentials • Genai
Why is Generative AI considered significant in the realm of artificial intelligence?
Essentials • Genai
Which of the following fields can utilize Generative AI to create new, original content or simulations?
Essentials • Genai
Generative AI is closely related to which type of models?
Essentials • Genai
Which type of AI is primarily concerned with how data is generated rather than how it's separated?
Essentials • Genai
In which application is Generative AI NOT typically used?
Essentials • Genai
What does AI stand for?
Essentials • Genai
Which of the following is NOT a type of AI?
Essentials • Genai
Which statement best defines Generative AI?
Essentials • Genai
Which of the following is NOT a property of likelihood?
Essentials • Genai
Which model type aims to capture the joint probability P(x, y)?
Essentials • Genai
Which of the following best describes the difference between generative and discriminative models?
Essentials • Genai
Within the architecture of Generative Adversarial Networks (GANs), which duo of fundamental elements are paramount?
Essentials • Genai
For what tasks can generative models be applied?
Essentials • Genai
What does a probability distribution provide?
Essentials • Genai
What's a significant hurdle when training GANs?
Essentials • Genai
Within generative models, what function does the discriminator serve in GANs?
Essentials • Genai
How is the likelihood of data given a model symbolized?
Essentials • Genai
If a model is better at distinguishing between classes rather than generating data, it is likely a _______.
Essentials • Genai
Which model type is primarily concerned with determining P(y | x)?
Essentials • Genai
What is the primary goal of generative models in AI?
Essentials • Genai
Which statement best differentiates generative from discriminative models?
Essentials • Genai
Which of the following is crucial for understanding the behavior of generative models?
Essentials • Genai
In the context of generative models, what does P(x) represent?
Essentials • Genai
Which of the following is NOT a generative model?
Essentials • Genai
Generative models are primarily used for which of the following tasks?
Essentials • Genai
What does likelihood measure in the context of a model?
Essentials • Genai
In the context of models, what does P(x | y) typically represent?
Essentials • Genai
What is a primary application of VAEs mentioned in the case study?
Essentials • Genai
What is the y-axis label of the chart visualizing the error?
Essentials • Genai
Which is NOT a challenge in implementing VAEs for this use-case?
Essentials • Genai
For how many epochs is the VAE trained?
Essentials • Genai
What criterion is used to determine if a data point is anomalous?
Essentials • Genai
What is the VAE trained to learn effectively?
Essentials • Genai
Why is understanding the VAE's outputs challenging?
Essentials • Genai
In the VAE, what does the sampling function introduce?
Essentials • Genai
What two components combine to form the VAE's loss?
Essentials • Genai
Which of the following is NOT an attribute in the given data?
Essentials • Genai
What type of dataset does the manufacturing plant collect?
Essentials • Genai
How is the data divided for training the VAE?
Essentials • Genai
What does the VAE attempt to minimize during training?
Essentials • Genai
Why is data preprocessing required before training the VAE?
Essentials • Genai
Over time, due to certain changes, what might be required of the VAE model?
Essentials • Genai
In which application can VAEs detect unusual patterns?
Essentials • Genai
Which of the following is a key component of the VAE loss function?
Essentials • Genai
In which application might VAEs be used to enhance image quality?
Essentials • Genai
Why is the reparameterization trick important in VAEs?
Essentials • Genai
Which optimization technique is commonly used with VAEs?
Essentials • Genai
Autoencoders primarily focus on which aspect of data?
Essentials • Genai
Which of the following is NOT a typical use case for VAEs?
Essentials • Genai
Why is variational inference used in VAEs?
Essentials • Genai
How do VAEs differ from traditional autoencoders?
Essentials • Genai
What do VAEs use to generate a distribution over latent variables?
Essentials • Genai
Why are autoencoders considered generative models?
Previous
Page 4 of 15
Next