Homechevron_rightEngineeringchevron_rightRPSC Programmerchevron_rightProgrammer DBMSchevron_rightTruncating tables shall ________.

Truncating tables shall ________.

  • Q. Truncating tables shall ________.
  • filter_dramaExplanation
    Answer is : A

    The correct answer is option 1.

    Concept:

    TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, indexes, and so on remain. To remove the table definition in addition to its data, use the DROP TABLE statement.

    SQL Truncate:

    The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.

    Syntax:

    TRUNCATE TABLE table_name;

    SQL Drop:

    The DROP TABLE command deletes a table in the database.

    Syntax:

    DROP TABLE table_name;

    So truncating tables shall empty a table completely but drop table deletes a table in the database.

    Hence the correct answer is empty a table completely.

Discussion

    No one started the discussion yet. Break the ice and start the conversation.
    Please Login to be part of the discussion.

Similar Questions

  • 1.

    Which of the following statements is/are TRUE?

    (i) Efficiency of CSMA/CD is \(\frac{1}{1 + 6.44a}\), where a = Tp/Tt

    (ii) Polling works like Time Division Multiplexing

    (iii) Maximum efficiency of pure aloha is 36.8%.

  • filter_dramaExplanation
    Answer is : C

    The correct answer is option 3.

    Concept:

    Option 1: Efficiency of CSMA/CD is \(\frac{1}{1 + 6.44a}\), where a = Tp/Tt

    True, In CSMA/CD Efficiency of CSMA/CD =\({T_x} \over {T_x+e.2 T_p}\)

    \(= {{1} \over {1+e.2{{ T_p} \over T_x}} } \)

    Jam signal is to alert all other stations that the collisions have taken place. It takes Tp to alert all stations. where a = Tp/Tt

    \(= {{1} \over {1+e.2{{ T_p} \over T_x}}+{T_p \over T_x} } \\={{1} \over {1+2 a e}+a} \\={{1} \over {1+2 a (2.7)}+a} \\={{1} \over {1+ 6.4}a}\)

    Option 2: Polling works like Time Division Multiplexing.

    False, Polling is an access control method, A polling is conducted in which all the stations are willing to send data to participate. In Time Division Multiplexing (TDM), the Time of the link is divided into fixed-size intervals called time slots or time slices.

    Option 3: Maximum efficiency of pure aloha is 36.8%.

    FalseIn pure aloha, any station can transmit the data at any time. In pure aloha, Maximum efficiency = 18.4%. In slotted aloha, any station can transmit the data at the beginning of any time slot. In slotted aloha, Maximum efficiency = 36.8%.

  • 2. Big Data is generally characterised by three Vs that stand for ______, _____ and ______.
  • filter_dramaExplanation
    Answer is : D

    Concept:

    Big data is a field that treats ways to analyse, systematically extract information from, or otherwise deal with data sets that are too large or complex to be dealt with by traditional data-processing application software.

    Explanation:

    Big Data can be defined using the famous 3 Vs - Volume, Velocity and Variety.

    VOLUME:

    Volume refers to the amount of data generated through websites, portals and online applications.

    VELOCITY:

    With Velocity we refer to the speed with which data are being generated.

    VARIETY

    Variety in Big Data refers to all the structured and unstructured data that has the possibility of getting generated either by humans or by machines.

    The most added data are unstructured -texts, tweets, pictures & videos.

  • 3.

    Consider different activities related to email.

    m1: Send an email from a mail client to a mail server

    m2: Download an email from mailbox server to a mail client

    m3: Checking email in a web browser

    Which is the application level protocol used in each activity?

  • filter_dramaExplanation
    Answer is : C

    The correct answer is option 3

    SMTP:

    • SMTP stands for Simple Mail Transfer Protocol and it is an application layer protocol.
    • SMTP is used to send an email from a mail client to a mail server.
    • SMTP uses port 25.

    POP:

    • POP stands for Post Office Protocol and it is also an application layer protocol.
    • POP allows an email client to download an email from an email server.

    HTTP:

    The Hypertext Transfer Protocol (HTTP) is an Application Layer protocol and is used to check email in a web browser.

    So, m1 : SMTP  m2 : POP m3 : HTTP

  • 4. A ______refers to a database that stores data in a structured format, using rows and columns.
  • filter_dramaExplanation
    Answer is : D

    A database is a set of data stored in a computer, and it is usually structured in a way that makes the data easily accessible.

    List - I List - II
    Hierarchical Database Model
    • The hierarchical Database Model is a data-based model in which the data are organized into a tree-like structure.
    • These data are connected to one another as links and stored as records.
    • The hierarchical database model mandates that each child record has only one parent, whereas each parent record can have one or more child records.
    Network Database
    • A network database model allows multiple records to be linked to the same owner file.
    • This allows each record to have multiple parents and multiple child records, and it is formed in a web-like structure of network records.
    • The main advantage is that it allows for more natural modeling of relationships between records or entities.
    Object Database
    • Object Database Management System (ODBMS) combines database capabilities with object-oriented programming language capabilities.
    • It allows programmers to develop the product, store them as objects, and replicate or modify existing objects to make new objects within ODBMS.
    Relational Database Management System
    • A Relational Database Management System (RDBMS) refers to a database that stores data in a structured format, using rows and columns.
    • RDBMS is a program that allows its users to create, update, and administer a relational database.
    • Most RDBMS use the MySQL language to access the database.  

    Therefore Relational Database Management System refers to a database that stores data in a structured format, using rows and columns.

  • 5.

    Consider the relation Emp-Dept with SSn as key

    Ename

    SSn

    EAddr

    Dept.

    No

    Dept.

    Name

    Dept.

    Manager

    SSn

     

    Which of the following is (are) invalid operation(s)?

    a) Inserting an employee without name and address

    b) Inserting an employee with only SSn

    c) Inserting a department with no employee

    d) Inserting an employee without SSn

  • filter_dramaExplanation
    Answer is : B

    Concept:

    • Here employee and department both table are merged into one table so right most SSn id is foreign key and second entry from left side is key of employee table.


    Statement a:

     Inserting an employee without name and address, is a valid statement because only SSn which is key should not be NULL other entries can be NULL.

    Statement b:

    Inserting an employee with only SSn, is a valid statement because only SSn which is key should not be NULL and here SSn is not NULL so valid statement

    Statement c:

    Inserting a department with no employee is a valid statement because foreign key can have NULL value.

    Statement d:

    Inserting an employee without SSn is not a valid statement because SSn employee id cannot be NULL

    So option 2 is the correct answer.

Programmer DBMSTopics

leaderboardLeaderboard
  • Rahul Kumar

    191 Points

  • VIKRAM JEET

    54 Points

  • GEETHIKA CHOWDARY

    53 Points

  • sunita saini

    52 Points

  • Zain

    49 Points