RDBMS Data Definition Language Create | Mobile

RDBMS Data Definition Language Create | Mobile_specification table

Write a query to Mobile_specification table with constraints mentioned.

Refer the below schema

 Result Description
 Summary of tests
+------------------------------+
| 3 tests run / 3 test passed  |
+------------------------------+

Comments

Must Read:

DFA Solutions

Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text To secure the http messages in the API calls, its necessary to: Select one: a. All the above b. Use cryptography c. implement identity management d. avoid hardcoding any sensitive data in the messages Feedback The correct answer is: All the above Question 2 Correct Mark 1.00 out of 1.00 Remove flag Question text A team has completed 10 Sprints and moving to the 11th Sprint. Till Sprint 10, the team has achieved an average of 50 story points per sprint. The same is projected as their velocity for the upcoming sprints with the Client. What is this approach called? Select one: a. Velocity Driven Sprint Planning b. Velocity Driven Commitment c. Commitment Driven Velocity d. Commitment Driven Sprint Planning Feedback The correct answer is: Velocity Driven Sprint Planning Question 3 Incorrect Mark 0.00 out of 1.00 Remove flag Question text Jack is grooming himself to be a potential Product Owner. Kno...

RDBMS Data Definition Language | Create Buses table

efer the below schema and create the buses table. Column Name Datatype Size Constraint Constraint name Bus_no Number 11 Primary key PK_BUSES Bus_name Varchar2 20 Type Varchar2 20 Total_seats Number 11 Avail_seats Number 11 Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

RDBMS Data Definition Language | Alter - Add CHECK constraint to Mobile_Master

RDBMS Data Definition Language Alter - Add CHECK constraint to Mobile_Master Refer the following schema and add a constraint CHK_WARRANTY in Mobile_Master table to ensure that the warranty in years is greater than zero. Evaluation Result: Result Description Summary of tests +------------------------------+ | 3 tests run / 3 test passed | +------------------------------+

RDBMS Data Definition Language | Drop Mobile Specification table (parent)

RDBMS Data Definition Language Drop Mobile Specification table (parent) Refer the following schema and drop Mobile Specification table. (Hint: To drop parent table all associate tables need to be dropped or Use 'cascade constraints' command) Evaluation Result: Result Description Summary of tests +------------------------------+ | 1 tests run / 1 test passed | +------------------------------+

RDBMS Data Definition Language | Purge Distributor table Truncate

RDBMS Data Definition Language Purge Distributor table Truncate The mobile management wants to purge all the records from the “Distributor “table. Write an SQL statement to purge all the records from the distributor table without allowing rollback activity. Evaluation Result: Result Description Summary of tests +------------------------------+ | 1 tests run / 1 test passed | +------------------------------+

Accenture Mock Quiz | Part 4

Question 31 Correct Marked out of 1.00 Flag question Question text What will be the output of the following Java code? class Test extends Throwable { } class Base extends Test {} public class Main { public static void main(String args[]) { try { throw new Base(); } catch(Test t) { System.out.println("Test Exception"); } finally { System.out.println("Finally block "); } } } Select one: a. Complilation error : Bass calss can't extends Test b. print-"Test Exception" c. Complilation error: Test Class cant extends Throwable d. print - "Test Exception" "Finally block " Feedback The correct answer is: print - "Test Exception" "Finally block " Question 32 Correct Marked out of 1.00 Flag question Question text Which of the following statement(s) is/are TRUE? (i) In a non-correlated(independent) subquery, the subquery is always executed only onc...

Data Formats ( XML & JSON ) XML AND JSON | Generate XSD for Persons

Generate XSD for Persons Generate XSD for the following XML. XYZ organization wants to store the details of persons in an xml file. The following scenario helps in designing the XML document. Here PersonList is the root tag. PersonList contains the entry of each person with adhaarno, name, age and address. <?xml version="1.0" encoding="UTF-8"?> <PersonList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="PersonList.xsd"> <Person> <adhaarno>414356782345</adhaarno> <name> <firstname>Zeenath</firstname> </name> <age>28</age> <address> <doorno...

Coin Change Combination

1. You are given a number n, representing the count of coins. 2. You are given n numbers, representing the denominations of n coins. 3. You are given a number "amt". 4. You are required to calculate and print the number of combinations of the n coins using which the amount "amt" can be paid. Note 1: You have an infinite supply of each coin denomination i.e. same coin denomination can be used for many installments in payment of "amt" Note 2: You are required to find the count of combinations and not permutations i.e. 2 + 2 + 3 = 7 and 2 + 3 + 2 = 7 and 3 + 2 + 2 = 7 are different permutations of same combination. You should treat them as 1 and not 3. Input Format A number n n1 n2 .. n number of elements A number amt Output Format A number representing the count of ...

UNIX Introduction to Unix | Pre-Quiz

Feedback Congratulations! You have passed by securing more that 80%. Question 1 Correct Mark 1.00 out of 1.00 Flag question Question text Solaris is the name of a flavor of UNIX from _____________. Select one: a. HP b. Sun Microsystems c. IBM d. Digital Equipment Corp Feedback Your answer is correct. The correct answer is: Sun Microsystems Question 2 Correct Mark 1.00 out of 1.00 Flag question Question text Match the following: HP-UX Answer 1 Choose... IBM Redhat Hewlett Packard Sun Microsystem AIX Answer 2 Choose... IBM Redhat Hewlett Packard Sun Microsystem Linux Answer 3 Choose... IBM Redhat Hewlett Packard Sun Microsystem Solaris Answer 4 Choose... IBM Redhat Hewlett Packard Sun Microsystem Feedback Your answer is correct. The correct answer is: HP-UX → Hewlett Packard, AIX → IBM, Linux → Redhat,...

Get's Answer

Search This Blog